Help Desk

Submit a ticket My Tickets
Welcome
Login

NetSuite JDBC BizApp


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 JDBC Command?

If there are specific NetSuite JDBC operations that your company is looking to perform support@onecloud.io to discuss the requirements and the possibility to incorporate the capability into OneCloud.

Connection Setup

The 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. Now, enter values for the following fields: 

InputTypeDetail
UsernameTextFieldThe username to authenticate with
PasswordTextFieldThe password to authenticate with
Connection URLTextFieldThe 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 portal 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.

B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.