This chrome extension allows Oracle Fusion SaaS developers and business analysts to run SQL queries against database. ** Changes…
This chrome extension allows Oracle Fusion SaaS developers and business analysts to run SQL queries against database.
** Changes in version 1.9:
1. Support for special characters added.
2. Now characters like < > and other XML special characters will not break the results.
3. In order to use it - please reinstall the utility report by using the Installation instructions.
** Changes in version 1.8:
1. Reverted query calculation to support big records.
** Changes in version 1.7:
1. Added support for special characters in SQL and in response. Previously broke the results.
** Changes in version 1.6:
1. Added support for unicode characters in results.
** Changes in version 1.5:
1. Corrupted ZIP fixed.
** Changes in version 1.4:
1. Added divider between SQL and results.
2. Utils report changed to show empty columns. Users will have to update the report in BIP catalog.
** Changes in version 1.3:
1. Added Object Browser and Refresh Metadata.
** Changes in version 1.2:
1. Syntax highlight is added by implementing SQL editor as Visual Studio Monaco editor.
To use this extension follow the next steps:
1. Install the extension and expose it on your browser toolbar.
2. Click on CFQ icon on the toolbar - it will open CFQ UI.
3. Register the Fusion SaaS instances you want to work with by using Environments button.
4. If you are using CFQ for the first time with currently logged in instance, follow the steps described in Installation instructions.
5. Click on Login button and provide Fusion SaaS environment which is currently selected. Currently we support only local Fusion SaaS users. Your password will be kept in the session for subsequent query executions and will be sent to Fusion SaaS server only. Upon Login process the values are just saved in the session but not checked, they will be checked during the first query execution. If your password or user are not valid - you will get Unauthorized error.
6. Enter one or more queries in the Query box
7. Use Run Query button or Ctrl/Cmd+Enter combination to run currently selected text or full text if nothing selected.
You are welcome to rate this plugin and let us know what you think about it to [email protected].