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, Planful, and Oracle EPM, allows OneCloud customers to integrate data from NetSuite to these target applications.
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, select the appropriate Runner, and use the NetSuite JDBC Connection Parameters to complete the setup.
NetSuite JDBC Connection Parameters
Visit NetSuite’s Documentation portal to learn more about additional connection parameters that can be leveraged.
The following is an example of a working connection. Please substitute your own values.
For documentation on all available commands, see the NetSuite JDBC Command Reference.