NetSuite SuiteAnalytics

The NetSuite SuiteAnalytics orchestration component uses NetSuite SuiteAnalytics Connect to retrieve data and load it into a table—this stages the data, so the table is reloaded each time. You can then use transformation components to enrich and manage the data in permanent tables.

Note

This component is only available for use with Hybrid SaaS agents.

Uploading NetSuite SuiteAnalytics drivers

Drivers for NetSuite SuiteAnalytics are not natively included in Hybrid SaaS agents, but you can upload them to your agent instance using the process in Uploading external drivers to the agent.

The required driver file can be obtained from NetSuite as follows:

Log in to your NetSuite account.
On the homepage of your NetSuite account, under the Settings module, click Set Up SuiteAnalytics Connect.
Select Linux 64-bit from the drop-down.
Click the Download button next to JDBC Driver. This will download a zip file that contains a file called NQjc.jar.
Note

It is also worth making a note of the following account information on this page, as you will need it to configure the connector properties:
- Account ID
- Role ID
Unzip the file and place the driver in the storage location you specified as described in Uploading external drivers to the agent. Do not change the driver file names.

Properties

Reference material is provided below for the Destination, Connect, and Configure properties.

Destination

Select your cloud data warehouse.

Connect

Authentication Type = drop-down

Select Username & Password or OAuth 2.0 Client Credentials, and add the appropriate credentials to the following fields.

See Troubleshooting, below, for possible issues caused by invalid credentials.

Username = string

Your NetSuite user name.

Only required if Authentication Type is Username & Password.

Password = drop-down

Displays a drop-down list of secret definitions. Select the secret definition that references the password corresponding to the username.

Only required if Authentication Type is Username & Password.

Account ID = string

The ID of your SuiteAnalytics Connect account. You can find this name in the Account ID field of the SuiteAnalytics Connect driver download page, under Your Configuration.

Only required if Authentication Type is Username & Password.

Role ID = string

The ID of your SuiteAnalytics Connect role. You can find this name in the Role ID field of the SuiteAnalytics Connect driver download page, under Your Configuration.

Only required if Authentication Type is Username & Password.

Authentication = drop-down

Opens a dialog to select an OAuth connection. Click Manage to navigate to the OAuths tab to review OAuth connections and to add new connections. Read OAuth to learn how to create an OAuth connection. Read NetSuite SuiteAnalytics authentication guide, which includes specific steps for acquiring NetSuite SuiteAnalytics credentials.

Only required if Authentication Type is OAuth 2.0 Client Credentials.

Connection Options = column editor

Parameter: A JDBC parameter supported by the database driver. Manual setup is not usually required, since sensible defaults are assumed.
Value: A value for the given parameter.

Click the Text Mode toggle at the bottom of the Connection Options dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.

Configure

Mode = drop-down

Basic: This mode will build a query for you using settings from the Schema, Data Source, Data Selection, Data Source Filter, Combine Filters, and Limit parameters. In most cases, this mode will be sufficient.
Advanced: This mode will require you to write an SQL-like query to call data from the service you're connecting to.

Note

While the query is exposed in an SQL-like language, the exact semantics can be surprising, for example, filtering on a column can return more data than not filtering on it. This is an impossible scenario with regular SQL.

:mod-sql-query: :mod-data-source: :mod-data-selection: :mod-data-source-filter: :mod-combine-filters: :mod-row-limit:

Deactivate soft delete for Azure blobs (Databricks)

If you intend to set your destination as Databricks and your stage platform as Azure Storage, you must turn off the "Enable soft delete for blobs" setting in your Azure account for your pipeline to run successfully. To do this:

Log in to the Azure portal.
In the top-left, click ☰ → Storage Accounts.
Select the intended storage account.
In the menu, under Data management, click Data protection.
Untick Enable soft delete for blobs. For more information, read Soft delete for blobs.

Troubleshooting

Validation failed

You may receive the following error when validating the component:

NetSuite Input Connector failed to validate: Internal network error, connection closed.

This error is typically caused by invalid credentials. Check your NetSuite SuiteAnalytics credentials (either Username/password or Oauth), and correct if necessary.

Snowflake	Databricks	Amazon Redshift
✅	✅	✅