Help & FAQ

SQL Connect is SplashBI’s enterprise SQL workspace and desktop SQL IDE for querying, exploring, validating, and managing data across enterprise applications. Originally built for Oracle Fusion Cloud ERP, SCM, and HCM, it gives developers a proper SQL editor for Fusion data without requiring a BI Publisher data model for every custom query.

SplashBI SQL Connect also connects to Oracle ATP/ADW, Oracle Database, Workday, MySQL, Snowflake, Salesforce, and other data sources from one consistent workspace.

SQL Connect is built primarily for technical developers, ERP consultants, BI Publisher and OTBI report developers, integration engineers, data engineers, and enterprise application teams. It also serves DBAs, finance and HR systems analysts, and data analysts who need an SQL development tool to write Oracle Fusion SQL queries and validate data across environments.

When comparing OTBI vs BI Publisher, both are reporting tools, while SQL Connect is a SQL development workspace. With Oracle BI Publisher in Oracle Fusion, running and revising custom SQL requires repeatedly creating or editing a BIP data model through Reports & Analytics. The interface offers a small query window, no SQL syntax validation, a preview limited to around 200 rows, and XML exports.

SQL Connect replaces this process with a full SQL editor featuring IntelliSense, syntax highlighting, schema browsing, continuous result viewing, and one-click CSV or Excel exports. Oracle OTBI remains suited to dashboards and subject-area reporting.

No. While an OTBI vs BI Publisher evaluation compares reporting options, SQL Connect serves a different purpose. It complements Oracle Fusion Cloud reporting and broader BI platforms by helping technical teams write and validate SQL, inspect underlying rows, and troubleshoot reports. It has no semantic layer, dashboards, or scheduled distribution, so it works alongside OTBI, BI Publisher, or SplashBI rather than replacing them.

SplashBI SQL Connect launched in 2019 and now has more than 300 active customers and 20,000 users worldwide. Retention is currently around 98.5%. Public references include LinkedIn, McDonald’s, Chewy, AS Watson Group, Arlington Public Schools, Envision Healthcare, and City of Tampa. Customers span the public sector, healthcare, manufacturing, and education.

SQL Connect exports results from Oracle Fusion SQL queries to CSV and Excel in one click from the results grid.

To a degree. The beta Query Builder lets users assemble queries through drag-and-drop, while SplashAI acts as an SQL query generator that converts plain-English prompts into natural language SQL users can review and refine. These text-to-SQL capabilities help occasional SQL users, but SQL Connect remains a technical tool rather than a self-service reporting product.

No, and no tool can. Oracle Fusion Cloud does not expose its SaaS database directly to subscribers. Access must go through an intermediary layer such as the Oracle Fusion REST API, Oracle Fusion SOAP API, or BI Publisher. SQL Connect handles that layer while letting developers write familiar Oracle Fusion SQL in a proper editor, providing a database IDE experience without the manual BI Publisher steps.

SQL Connect supports Oracle Fusion SQL through the same Oracle-provided layer used by BI Publisher. It respects existing Oracle Fusion user roles, so users see only the data their roles permit. The desktop tool does not modify or install anything in your Fusion environment. Your security, legal, and Oracle account teams should still review it as they would any third-party tool accessing production data. SplashBI supports the Oracle Fusion security review with detailed documentation.

Users need the appropriate Oracle Fusion user roles to run SQL queries and retrieve data, just as they do when running a BI Publisher report. If the required access is missing, a BI administrator must assign the relevant Fusion role. This is a one-time setup step.

Yes. SQL Connect supports Oracle Fusion SQL queries against views that require Apps initialization. This includes Oracle Fusion HCM SQL queries that depend on Apps initialization, which most native and general-purpose SQL tools do not handle.

SQL Connect uses background execution for long-running Oracle Fusion SQL queries. A query continues processing while you work in another tab, extending execution beyond the default BI Publisher timeout limits. Intensive Oracle Fusion Cloud jobs are documented to run for up to 18,000 seconds.

Yes. SQL Connect lets you save multiple Oracle Fusion Cloud POD connections and organize them into logical groups, making it clear whether you are working in DEV, TEST, or PROD. You can use the same Oracle Fusion SQL workspace for each connection. Standard supports up to two cloud connections, while Enterprise supports unlimited cloud connections.

Not through a direct database connection. Oracle SQL Developer connects directly to Oracle Database and ATP, but Oracle Fusion Cloud does not expose its SaaS database to subscribers. Native custom SQL usually runs through a BI Publisher data model. SQL Connect provides a desktop editor for that Fusion workflow using Oracle-provided BIP and REST services.

Oracle Fusion Cloud does not provide a SQL worksheet for its SaaS database. To write SQL queries in Oracle Fusion, users typically create a BI Publisher data model through Reports & Analytics. SQL Connect provides a desktop IDE for the same Oracle Fusion SQL queries, adding IntelliSense, schema browsing, complete results, and CSV or Excel exports without repeating the data-model workflow after every change.

To run a SQL query in Oracle Fusion Cloud natively, execute it through a BI Publisher data model. SQL Connect provides an Oracle Fusion SQL editor over HTTPS for the same type of query, with background execution for long-running jobs that might otherwise hit BI Publisher timeout limits.

For SQL and Oracle Fusion reporting, use SQL Connect for ad hoc SQL development and validation alongside OTBI, BI Publisher, or SplashBI for dashboards and distribution. In an OTBI vs BI Publisher evaluation, SQL Connect complements either option. A SplashBI and SQL Connect stack covers both requirements, but SQL Connect itself is not a BI platform.

SQL Connect currently supports Oracle Fusion Cloud ERP, SCM, and HCM PODs; Oracle ATP and Oracle ADW; Oracle Database; MySQL; Snowflake; Workday; Salesforce; Jira; ADP; SAP; and ServiceNow. Additional data sources are added based on customer demand.

Yes. SQL Connect can query Salesforce using either native Salesforce SOQL or familiar SQL-92 syntax. SQL users do not need to learn how to write a SOQL query in Salesforce before working with Salesforce data.

Yes, SQL Connect has an existing Workday & UKG connector. If your use case involves Workday Prism, SplashBI will confirm compatibility with your specific setup.

Yes. SQL Connect supports cross-database queries, so a single SQL statement can join data across two or more connections. You can combine Oracle Fusion Cloud tables with Workday, SQL Server, Oracle Database, or Snowflake in one query, without exporting each result set and reconciling it by hand. This makes cross-system reconciliation, validation, and reporting possible from a single SQL workspace.

Yes. SQL Connect connects directly to Oracle E-Business Suite (Oracle EBS) and other on-premise environments through its native Oracle Database connector. Teams can work with APPS schemas and Oracle Fusion Cloud PODs from the same SQL workspace, supporting hybrid environments and EBS-to-Fusion migrations.

SQL Connect supports Oracle Fusion security through three layers. It respects existing Oracle Fusion user roles, adds role-based access control, object- and table-level permissions, and SSO, and provides audit reports that can log table access or full SQL statements. SplashBI is SOC 2 Type II and ISO 27001 certified, and SQL Connect undergoes penetration testing.

No. SQL Connect extends Oracle Fusion security rather than replacing it. Oracle Fusion user roles continue to control application access, while SQL Connect adds object-level RBAC for data accessed through SQL. For example, users may query standard views while being blocked from views that require Apps Initialization. Similar rules can restrict access to sensitive HR or procurement tables unless explicitly granted.

Yes. SQL Connect supports Oracle Fusion security with configurable, profile-level audit reports. Administrators can log the tables each user accessed or capture their full SQL statements for more detailed oversight.

Yes. SQL Connect Enterprise supports Single Sign-On (SSO) through SAML 2.0 and modern authentication protocols, integrating with Microsoft Entra ID, Okta, PingFederate, and Oracle IAM. MFA is enforced by your identity provider according to corporate policies, including authenticator apps, security keys, SMS, or push notifications. Database connections also follow the host environment’s native authentication policies.

SplashBI is SOC 2 Type II and ISO 27001 certified. SQL Connect undergoes penetration testing, and its two major annual releases include security and third-party library updates. A VPAT is in progress.

Yes. SplashBI can share its SOC 2 Type II report and relevant SQL Connect penetration testing documentation through the standard security review process, typically under an NDA. The team can send these documents directly to your security reviewer.

No. SQL Connect is a desktop client, and queries run directly between your local machine and source systems through the Oracle Fusion REST API, Oracle Fusion SOAP API, or Oracle Database. Results are rendered locally in memory and are never routed through or stored on SplashBI servers. The only outbound connection to SplashBI is HTTPS 443 traffic to sqlconnectportal.splashbi.com for license and entitlement verification.

No customer transactional data is sent to public AI models or used for training. For natural language SQL and text-to-SQL generation, SplashAI processes only the user prompt and relevant schema metadata within dedicated enterprise cloud boundaries, such as OCI Generative AI or Azure private endpoints. The generated SQL executes locally against your database, so business records remain within your environment.

SQL Connect list pricing is $50 per user per month or $450 per user per year for an individual licence. Pricing varies by user count and contract length. Enterprise Edition includes advanced security, unlimited connections, and SplashAI, with custom volume-tiered annual pricing. SplashBI can provide an exact quote for your team.

SplashBI SQL Connect Standard supports up to two cloud connections, SQL formatting, standard updates, and connections to MySQL, Oracle, and Snowflake. Enterprise adds unlimited cloud connections, IntelliSense, database browsing, SSO, priority updates, SplashAI for natural-language SQL, and table-level access controls.

No. A SQL Connect license is managed through user management rather than permanently tied to one machine. The software subscription license can be reassigned when a contractor rolls off or an employee leaves, so you can repurpose the seat instead of buying another.

No. SQL Connect uses a term-based software subscription license with monthly or annual billing rather than a perpetual license. The subscription funds quarterly enhancements and two major annual releases that keep security features and third-party libraries current.

Yes. SplashBI SQL Connect offers a 15-day free trial.

No. SQL Connect version upgrades are included at no extra cost. Enhancements and fixes are released quarterly, with major functional releases twice a year. Enterprise customers receive priority updates.

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

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.

No server infrastructure is required. The SQL Connect download installs a lightweight desktop client on 64-bit Windows 10/11 or macOS workstations. It connects directly to Oracle Fusion over outbound HTTPS 443 or Oracle Database over port 1521. IT only needs to allow local installation and outbound HTTPS access to sqlconnectportal.splashbi.com for license verification.

All SQL Connect subscriptions include support from 8 a.m. to 5 p.m. CST, Monday through Friday, plus 24/7 help for critical issues. Customers also receive Support Portal access, documentation, a knowledge base, and direct email or ticket support. Minor updates, major upgrades, and every Oracle Fusion quarterly update, including Oracle Fusion 26A through 26D, are included. Enterprise customers also receive onboarding, priority SLA routing, and Customer Success Manager support.

Install SQL Connect, connect to your Fusion POD over HTTPS 443, and authenticate using your existing Fusion roles. This creates a live desktop session, not a replicated warehouse. You can then run a SQL query in Oracle Fusion Cloud against current data and export the results to CSV or Excel. Scheduled distribution remains within BI Publisher, OTBI, or SplashBI.

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.

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 link above to update the connections.