Frequently Asked Questions
If you don’t find your answers here, please reach out to our support team!
Yes, anytime SQL Connect has a new update, the user will be notified on the platform and we recommend our customers to download and use the new update immediately. Each of the new updates contains multiple fixes and stability improvements and enhancements.
With IntelliSense, you’ll be able to write SQL queries with ease and speed by providing you with real-time suggestions for keywords, table names, and columns, as you type. This powerful feature can help you write accurate and efficient queries in a fraction of the time, all while minimizing the risk of syntax errors.
SQL Connect Connects to Oracle Fusions Cloud using HTTPS Hypertext Transfer Protocall. We do not store or collect your Oracle POD information, Oracle Cloud Credentials, SQL’s Run, Data Returned.
Yes currently, we are compatible with only Oracle Fusion Cloud Applications. SQL Connect is a proprietary tool that only Connects to Oracle Fusion Cloud Applications.
SQL Connect by SplashBI can query data only from Oracle Cloud Applications. Other database connections are not supported by SQL Connect. However, there are different reporting solutions offered by SplashBI where developers can connect to multiple databases for reporting and analytics.
If you have implemented Single Sign On (SSO) with dual mode (chooser option) then you can use your Oracle Cloud credentials to establish connection. This is done only ONCE per pod/connection. If you have SSO that requires multi factor authentication, then that may not work with SQL Connect.
Of course! Our friendly and knowledgeable customer services reps are available to answer your questions via email from M-F, 8 am EST to 5 PM PST.
Yes, SQL Connect offers a centralized user administration portal where you can add/deactivate users, reset passwords if necessary. For instructions, please reach out to [email protected]. Support team can set up a user as an admin for the user management activities.
You can download the latest software from the location below.
You may have to setup BI Publisher if your organization is using SQL Connect for the first time or you have a newer version. Please find the instructions in the below link to update the connections (Step 2 if you are using Local Connections or Step 3 if you are using SSO Connections)
Here is How to run a SQL Query in Oracle SAAS (Fusion) cloud environment.
As you probably know by now, there are multiple ways to extract desired data out of Oracle Cloud SAAS applications including HCM/ERP/SCM cloud.
These steps are a quick and easy way to extract data by running a SQL query in Oracle Fusion Cloud with SQL Connect
Step 1 – Launch SQL Connect app from your desktop.
Step 2 – If you already have a connection setup to your desired Pod, then use that or create a new connection. This should take 2 minutes.
Step 3 – Write your query, or Open the existing file that contains your query.
Step 4 – Press CTRL – Enter or Press the RUN button on the user interface.
Step 5 – You should be able to see the Query results if there are no errors. If the query has any errors, you can review the errors and correct them before running the query again.
You can also review the time it took to run the query and other relevant details by clicking the “view SQL” link on the status bar. And that is how you run a SQL query in Oracle fusion cloud.
Prerequisites for this is that you must have the right role in order to run query and get the data required. If you do not have the role you may need to contact your BI admin to provide assistance in getting this setup. Its a one time activity, and will save you hours of work in future. Its easy to run SQL query against Oracle SAAS Cloud using SQLConnect.