The OneCloud Oracle Autonomous Data Warehouse (ADW) | RDBMS BizApp enables OneCloud to integrate with these relational systems natively. This ability can then be combined with other business intelligence applications including Tableau and Power BI, performance management applications such as Anaplan, IBM Planning Analytics, Planful, and Oracle EPM and systems of record that include SAP, Workday, and Oracle Financials, to allow OneCloud customers to tightly and bi-directionally integrate their Oracle relational systems with other applications.

Connection Setup

To enable OneCloud to interact with a relational system, you’ll need to navigate to the connection manager to create a connection.

From here, choose Oracle Relational and ADW from the service drop-down, select the appropriate Runner, and use the Oracle RDBMS | ADW Connection Parameters to complete the setup.

📓 Oracle ADW

To use this connector with Oracle ADW, you need to use the Oracle Wallet provided with the database. Note that the following files need to be added as resources to the connection when using the Oracle Wallet. The TNS_ADMIN parameters accordingly point to the location of these resources that are accordingly used at runtime.

  • cwallet.sso.lck\n* ewallet.p12.lck

  • cwallet.sso

  • ewallet.p12

  • keystore.jks

  • sqlnet.ora

  • tnsnames.ora

  • truststore.jks

  • ojdbc.properties

📓 Oracle ADW TNS_ADMIN path
The TNS_ADMIN path points to the location where the resources can be found. As these resources are a part of the connection, use the following conventions based upon the type of operating system of the host GroundRunner.

  • Unix-based: TNS_ADMIN=./

  • Windows-based: TNS_ADMIN=.

Note: If connecting to Oracle ADW via a CloudRunner, then use the Unix-based convention.

📓 Default Oracle Relational Database Port

The default Oracle relational database port is 1521, but it could be different depending on your environment.

📓 Oracle Relational Connection Parameters

Visit the Oracle Documentation portal to learn more about additional connection parameters that can be leveraged.

Connection Example

The following is an example of a working connection. Please substitute your own values.

⚠️ This BizApp requires the installation of a Java runtime. For best system compatibility please install Java 8.

Did this answer your question?