Set up a connection to NetSuite Analytics Warehouse (NSAW)

Start establishing a connection to NetSuite Analytics Warehouse (NSAW) in either of the following ways:

In the resulting Application list, click NetSuite Analytics Warehouse (NSAW).

First, you must name your connection.

Name (required): Enter a clear and distinguishable name for your connection.

Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.

Then, configure your authentication settings.

Username (required): Enter your user name for database authentication.

Password (required): Enter your password for database authentication.

Credentials .zip file (required): Upload the credentials.zip file (wallet file) for authentication. if you are a database administrator, you can follow the instructions and download client credentials. If you are not a database administrator, you can request your administrator to provide the file.

Service Name (required): Select the service name based on your workload. Each service provides a different level of performance and concurrency. For details, see the database service names.

After this, if you require to customize your connection, configure these settings.

Configure properties: Define additional configurations for the database connection. For example, you can configure the connection timeout if the server you are trying to connect to is slow.

Borrow concurrency from: Select another connection from the list. By default, all data flowing through a connection record is submitted to the respective endpoint application at the Concurrency level configured for that connection record. There are cases, however, where multiple integrator.io connections need to share the same concurrency level, and this field allows you to specify which connection you would like to borrow from. With borrowed concurrency, the data flowing through both connections will be submitted to the endpoint application together, via a shared concurrency model.

Auto-recover rate limit errors: This setting is enabled by default with a pre-defined value for Target concurrency level. You can disable the setting if required. To set or make changes in any of these settings, you must have administer or manage permissions.

Target concurrency (required if Auto-recover rate limit errors is enabled): This field is shown only if Auto-recover rate limit errors is enabled. Change the predefined value as required to limit the number of concurrent API requests allowed by the connection resource. See also, Setting currency level on a connection.

Concurrency level (required if Auto-recover rate limit errors is not enabled): When Auto-recover rate limit errors is enabled, the Concurrency level cannot be edited and shows the concurrency level that the platform is currently using (runtime). When Auto-recover rate limit errors is not enabled, enter a value to limit the number of concurrent API requests allowed by the connection resource. See also, Setting currency level on a connection.

Configure encrypted fields: Store all sensitive fields required by your imports and exports to access the app you are connecting to. Click the Expand window ( ) button to modify the JSON sent to the app in the Encrypted Advanced Field Editor. For example, enter {"secretKey": "someSecretKeyValue"}. (You can also retrieve these sensitive values elsewhere, such as How to test this connection?, via the example handlebars format {{{connection.http.encrypted.secretKey}}}.) Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s encrypted fields safe. When editing this form later, you must enter this value again; it is stored only when the connection is saved and never displayed as text.

Once you have configured the NetSuite Analytics Warehouse (NSAW) connection, click one of the following options:

When you test or save the connection, you will receive the following message:

The connection is added to your account.