Deprecation of the OneCloud Relational BizApp
The OneCloud Relational BizApp has been deprecated in favor of individual connection-specific BizApps for the individual databases. This approach provides an optimized and enhanced connectivity across the ranged of relational technologies that OneCloud supports.
- Amazon Redshift
- IBM Db2
- Microsoft SQL Server
- NetSuite JDBC
- Oracle Relational and ADW
- SAP HANA JDBC
If there is a relational system that is not supported, then please use the generic OneCloud JDBC BizApp that allows any bring your own JDBC driver to be used.
The OneCloud Relational BizApp enables OneCloud to integrate with relational databases via standard ANSI SQL. Combining the ability to perform relational operations across other applications including Workday, Namely, and performance management applications such as Anaplan, IBM Planning Analytics, and Oracle EPM allows OneCloud customers to tightly and bi-directionally integrate their relational systems with other applications.
OneCloud currently supports the following relational operations:
- Query - Query database tables and views with complex SQL statements
- Insert into Table - Bulk insert data into a target relational table
- Run Command - Run SQL commands and stored procedures
- Update Table - Update records in a target table.
For documentation on all available commands, see the Relational Operations Command Reference.
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 Relational Services from the service drop-down and select the appropriate Runner.
Properly formatted JDBC URL
Display additional content when troubleshooting.
The following is an example of a working connection. Please substitute your own values.
The following are JDBC connection string examples. Please contact your system administrator to confirm the settings for your environment.
Microsoft SQL Server
*Note the URL requires the Oracle database instance name.
*Note the URL requires the DB2 database name.
*Note the URL requires the MySQL database name.
*Note: check parameters with your NetSuite administrator and be sure to get a valid NetSuite Account ID
*Note the URL requires the PostgreSQL database name.
The following is an example JDBC URL: jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev