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.
OneCloud connects to an array of relational technologies via their native JDBC interface. Currently, OneCloud can support the following major relational technologies:
- Microsoft SQL Server
- Oracle Database
- IBM DB2
- Amazon RDS
- SAP HANA
If you do not see your relational database listed, please contact OneCloud support at firstname.lastname@example.org and we would be happy to discuss your requirements.
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 the URL requires the PostgreSQL database name.
*Note: check parameters with your NetSuite administrator and be sure to get a valid NetSuite Account ID
The following is an example JDBC URL: jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev