CloudSQL helps you easily connect to your Oracle Fusion environment, run SQL queries, and export data for analysis. This guide walks you through the complete process from connecting to Oracle Fusion to executing and managing your first query efficiently.
If you haven’t registered for your CloudSQL free trial yet, check our blog on How to Register, Download and Activate CloudSQL Free Trial
Connect to Your Oracle Fusion Environment
To begin, you need to connect your local CloudSQL Desktop application to your Fusion environment. To create a connection:
Step 1: Launch the CloudSQL Desktop application.
Step 2: Click on Select a connection from the pop-up message and select the option Create new connection
Note: You’ll see three connection methods — Local Sign-In, SSO, and Connection file.
For other connection types, you can explore the following:
Step 3: Select the Local signing and enter the following
| Connection Name | Provide a short name to uniquely identify the Oracle fusion instance |
| Connection URL | Provide you Oracle fusion homepage Link Eg: https://fa-exxh-dev5-saasfademo1.ds-fa.oraclepdemos.com/ |
| Connection user name | Enter your Oracle Fusion account Username |
| Password | Enter your Oracle Fusion account Password |
Step 4: Click on Test and Create Connection to validate and create the connection.
Common Connection Issues and Fixes
Even if people follow the right steps exactly, they still run into those typical problems. This covers a fast way to handle and fix them.
- Using Incorrect URL or Login URL Instead of Home page URL: You should use your Home page URL. It usually seems like https://fa-abcd-dev1-saasfademo1.ds-fa.oraclepdemos.com
- Username or Password Incorrect: Double-check credentials and ensure your Fusion account has login access.
- Missing BI Role Access: Your fusion account must have the BI Author role, BI Administrator role or a custom role with similar privilege to run SQL. Request role assignment from your Fusion Security Admin if missing.
- No network or bad network: You must have a stable internet connection while creating the connection.
Run Your First SQL query in CloudSQL
CloudSQL opens your workspace. You can start running SQL queries right there on your Oracle Fusion data. Here is how you do it step by step.
Step 1: Write your SQL in the rich SQL editor
Tip: Explore the Database Browser. On the right panel, you will see the Database Browser one of CloudSQL’s key features. You can explore available schemas, tables, and views from your Fusion environment.
Tip: Use Column and Table Auto-Completion. The SQL Editor suggests table and column names as you type, helping you write queries faster and without errors.
Step 2: Click on the Executebutton (or press Ctrl + Enter) to execute.
CloudSQL will fetch the results from Oracle Fusion and display them in the Result Grid below the editor
Step 3: Click Export button to export to download in the required format. To know more about export, refer to our blog on Result Grid
At DataFusing, we are constantly improving CloudSQL for you by adding more and more features. Click here to start 30 Days Free Trial today.
Must Read: How to Sign Up, Download, and Activate Your CloudSQL Free Trial?
