The OneCloud Oracle Autonomous Data Warehouse (ADW) | RDBMS BizApp enables OneCloud to natively integrate with these relational systems. 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, Host Analytics, 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.
For documentation on all available commands, see the Oracle RDBMS | ADW Command Reference.
Need a specialized Oracle RDBMS | ADW Command?
If there are specific Oracle operations RDBMS | ADW that your company is looking to perform email@example.com to discuss the requirements and the possibility to incorporate the capability into OneCloud.
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 and select the appropriate Runner.
|Username||TextField||The username to authenticate with.|
|Password||TextField||The password to authenticate with.|
|Connection URL||TextField||The connection URL Examples: |
To use this connector with Oracle ADW you will need to use the Oracle Wallet provided with the database. It should be noted that when using the Oracle Wallet, the following files need to be added as resources to the connection. The
Oracle ADW TNS_ADMIN path\nThe 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.
Note: If connecting to Oracle ADW via a CloudRunner, then use the Unix-based convention.
See the connection example below.
Default Oracle Relational Database Port
The default Oracle relational database port is 1521 but 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.
The following is an example of a working connection. Please substitute your own values.