Skip to Main Content

Introducing OSAAS JDBC driver: Revolutionizing Oracle Fusion Cloud Database Connectivity

Unlock Seamless Database Integration

Connect your Java applications effortlessly to Oracle Fusion Application database to perform any kind of select statements. Designed with performance, security, and flexibility in mind, our JDBC driver streamlines database connectivity like never before.

OsaaS JDBC driver allows you to use any database management software which supports custom jdbc driver. Our favorite is DBeaver - one of the best database management tools. Our JDBC driver supports all DBeavear's features for Oracle SaaS Fusion users.

Features at a Glance

  • Multi-POD Support: Seamlessly connects to a wide range of Oracle's Fusion SaaS pods.

  • Connection Options: Oracle SaaS databases can be accessed through multiple methods of authentication, including direct login with username and password and SSO login which can be one of every SSO providers defined in Oracle Fusion SaaS.

  • Whitelisting of Oracle SaaS pods: As an owner of license you can permit connections to any Oracle SaaS pods or restrict it to specific list of urls

  • License Floating: License can be moved from one PC to another

  • Logical SQL: Supports logical SQL to write queries based on Subject Area and not on regular DB tables

Key Features in combination with DBeaver (community/pro)

User Interface

  • Provides a user-friendly interface for managing databases.

  • Available on Windows, Linux and MacOS platforms

  • Multi-Platform Support: Integrates with various database platforms including MySQL, PostgreSQL, Oracle, SQL Server and more.

  • Collaboration Tools: Foster teamwork and collaboration with built-in sharing, commenting and version control features.

  • Convenient navigation among data

  • Custom filters of table content of query results, including filters base cell values.

  • Results ordering by column

  • Allows you to quickly copy data or column names back into the editor, making it easy to reference previous queries.

Table suggestion

Suggests (Autocompletes) a list of matching tables while you type. For every table in the list, available columns are shown.

Column suggestion

Suggests (Autocompletes) a list of matching columns of the table while you type. Each column's metadata is shown.

Client Grouping Aggregation Function

You can define aggregation function such as SUM,AVG,COUNT distinct and others and see the results for chosen columns without re-executing the query. Grouping is supported as well.

Export options

DBeaver provides a wide range of export formats: CSV, XLSX, HTML, TXT, JSON, XML, Markdown, and SQL.

Therefore, you can export your data from Oracle SaaS application to any of the mentioned formats using OSaaS JDBC driver.

    Two ways for exporting data:
  1. Exporting with re-executing query, is usable when actual result may have more records then when was initially fetched.
  2. Coping already fetched data.

Additional Usable Futures

  • Multiple results sets on single tab.
  • Multi(detached) window.
  • Configurable SQL formatting.
  • SQL templates.
  • If you need to connect to additional databases (Oracle, MSSql and many others) you don't need to use multiple SQL query tools.
Release 1.0