The OneCloud NetSuite JDBC BizApp enables OneCloud to integrate with the NetSuite system via a SQL interface natively. 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.
⚠️ This BizApp requires the installation of a Java runtime. For best system compatibility please install Java 8.