To natively integrate with the NetSuite® system via a SQL interface as part of a chain, add a step with a NetSuite JDBC connection command. To integrate data from NetSuite and perform NetSuite database operations across other applications including Tableau®, Power BI®, and performance management applications such as Anaplan®, IBM® Planning Analytics, Host Analytics®, and Oracle® EPM, combine these commands with theirs within a chain.
To enable these commands, an IT admin first creates a NetSuite JDBC connection and configures its credentials and properties:
|Username||Enter the username to authenticate with|
|Password||Enter the password to authenticate with|
|Connection URL||Enter the connection URL, such as
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
SELECT query, and receives the results as a comma-separated values (CSV) file
|SQL Text/File||Enter the SQL text or file to execute|
|Delimiter||Select the delimiter to use in the CSV output|
|Preview Results||To see a preview of the returned row, check this box|
|Result Set (CSV)||File|
|3||Error||Failed to run the command|