Skip to main content

Frequently Asked Questions

SQL Connect is your trusted tool for efficient Oracle Fusion Cloud data querying. We’ve put together some of our most asked questions for you. Browse the FAQs below.

If you don’t find your answers here, please reach out to our support team!

Tech FAQ

If SQL Connect has released a new update, do I need to download new software?

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.

How Does the Intellisense feature of SQL Connect save time and reduce errors?

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.

What kind of security protocols does SQL Connect support?

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.

Does SQL Connect only extract data from Oracle Fusion Cloud applications?

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.

Can SQL Connect query data from Oracle ATP or ADW?

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.

Can I upgrade my SQL Connect subscription from Individual to Enterprise?

Yes, upgrading is easy. Please reach out to support at [email protected]. The support team will work with you with seamless upgrade experience.

Does SQL Connect support SSO?

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.

Do you offer customer service?

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.

Can I manage my users without reaching out to support?

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.

Install Instructions

You can download the latest software from the location below.

You can download the latest software from the location below.

https://sqlconnect.com/downloads

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)

https://www.sqlconnect.com/bipublishersecuritysetup/

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.