OneCloud

Relational Operations

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

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
  • MySQL
  • PostgreSQL
  • SAP HANA
  • NetSuite

If you do not see your relational database listed, please contact OneCloud support at support@onecloud.io 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.

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.

PostgreSQL

jdbc:postgresql://localhost:5432/database

*Note the URL requires the PostgreSQL database name.

SAP HANA

jdbc:sap://hanasp11:30515

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