Is it safe to query Oracle Fusion from an editor? Credentials and data
Before you connect any tool to a Fusion pod, you should know where credentials and results go. This is how FuiSQL handles them, so you can check it against your own policies.
The data path
- Your machine. You write SQL in VS Code.
- Oracle's own service. FuiSQL calls the BI Publisher report service your pod already exposes, over HTTPS.
- Your Fusion instance. The query runs there and rows return to VS Code, and nowhere else.
There is no middleware, no proxy and no FuiSQL server in the data path.
Credentials
Your username and password go only to your Fusion host. They are stored in VS Code's encrypted Secret Storage, not in plain text on disk.
Privileges
Queries run as a BI Publisher SQL data set, with exactly the privileges your Fusion account already has. FuiSQL adds no access. If your BI role cannot read a table, the query cannot either.
Results and history
History, results and exports are stored locally on your machine. FuiSQL's servers receive license requests only.
What to ask your security team
- Is uploading a small report to the BI Catalog allowed in the environment?
- Which BI roles may run SQL data sets, and in which environments?
- Where may exports containing business data be stored on laptops?
Start with a non-production environment. Then see how to run SQL against Oracle Fusion from VS Code.
Frequently asked questions
Does FuiSQL change data in Fusion?
FuiSQL runs queries as a BI Publisher SQL data set. It is meant for reading data, and it runs with your account's existing privileges.
Does FuiSQL see my results?
No. Results go from your Fusion pod to your computer. FuiSQL's servers only handle license requests.
Run SQL against Fusion from VS Code. FuiSQL has a free trial.
See FuiSQL Get it from the VS Code MarketplaceRelated guides
FuiSQL is an independent product by FuiSQL. Oracle and Fusion are trademarks of Oracle and/or its affiliates; FuiSQL is not affiliated with, endorsed by or sponsored by Oracle.