OneCloud

NetSuite JDBC

❗️

This article has expired. Please visit the OneCloud Knowledge Base for the latest documentation.

👍

Premium BizApp

The OneCloud NetSuite JDBC BizApp enables OneCloud to natively integrate with the NetSuite system via a SQL interface. Combining the ability to perform NetSuite database queries across other applications including Tableau and Power BI and performance management applications such as Anaplan, IBM Planning Analytics, Host Analytics, and Oracle EPM, allows OneCloud customers to integrate data from NetSuite to these target applications.

For documentation on all available commands, see the NetSuite JDBC Command Reference.

📘

Need a specialized NetSuite command?

If there are specific NetSuite operations that your company is looking to perform, please contact [email protected] to discuss the requirements and we would be happy to consider adding the capability to the product.

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

Input

Type

Detail

Username

TextField

The username to authenticate with.

Password

TextField

The password to authenticate with.

Connection URL

TextField

The connection url. (e.g jdbc:ns://{Server Host}:{Server Port};ServerDataSource={Server Data Source};encrypted=1;Ciphersuites={Cipher Suite};CustomProperties=(AccountID={Account Id};RoleID={Role Id}))

📘

NetSuite JDBC Connection Parameters

Visit NetSuite's documentation to learn more about additional connection parameters that can be leveraged.

Connection Example

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

Updated 8 months ago

NetSuite JDBC


Suggested Edits are limited on API Reference Pages

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