OneCloud

Relational Operations

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.

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.

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 Relational Services from the service drop-down and select the appropriate Runner.

Input
Type
Detail

JDBC URL

TextField

Properly formatted JDBC URL

User name

TextField

Database username

Password

TextField

Database password

Debug

DropdownField

Display additional content when troubleshooting.

Connection Example

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

JDBC Samples

The following are JDBC connection string examples. Please contact your system administrator to confirm the settings for your environment.

Database
JDBC Connection String

Microsoft SQL Server

jdbc:sqlserver://localhost:1433

Oracle Database

jdbc:oracle:thin:@//localhost:1521/orcl

*Note the URL requires the Oracle database instance name.

IBM DB2

jdbc:db2://localhost:50000/dbname

*Note the URL requires the DB2 database name.

MySQL

jdbc:mysql://localhost:3306/dbname

*Note the URL requires the MySQL database name.

NetSuite

jdbc:ns://odbcserver.na2.netsuite.com:1708;ServerDataSource=NetSuite.com;encrypted=1;Ciphersuites=TLS_RSA_WITH_AES_128_CBC_SHA;CustomProperties=(AccountID=#######_SB1;RoleID=3)

*Note: check parameters with your NetSuite administrator and be sure to get a valid NetSuite Account ID

PostgreSQL

jdbc:postgresql://localhost:5432/database

*Note the URL requires the PostgreSQL database name.

Amazon Redshift

jdbc:redshift://endpoint:port/database

The following is an example JDBC URL: jdbc:redshift://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev

SAP BW

jdbc:jdbc4olap://127.0.0.1:8000/sap/bw/xml/xmla?sap-client=001

SAP HANA

jdbc:sap://hanasp11:30515

Relational Operations


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.