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.
Connection Properties
To enable these commands, an IT admin first creates a NetSuite JDBC connection and configures its credentials and properties:
| Input | Detail |
| Username | Enter the username to authenticate with |
| Password | Enter the password to authenticate with |
| Connection URL | Enter the connection URL, such as jdbc:ns://{Server Host}:{Server
Port};ServerDataSource={Server Data Source};encrypted=1;Ciphersuites={Cipher
Suite};CustomProperties=(AccountID={Account Id};RoleID={Role
Id}) |
Note: All sensitive credentials are automatically encrypted and stored at 2,048-bit encryption.
Execute Query
Executes a SELECT query, and receives the results as a comma-separated values (CSV) file
Inputs
| Input | Detail |
| 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 |
Outputs
| Output | Output Type |
| Record Count | Integer |
| Result Set (CSV) | File |
Exit Codes
| Code | Type | Detail |
| 0 | Success | Success |
| 1 | Error | Invalid inputs |
| 3 | Error | Failed to run the command |