Configure NetSuite for ingestion into Databricks

Preview

The NetSuite connector is in Public Preview.

Learn how to configure your NetSuite account for Databricks ingestion using token-based authentication (TBA).

Requirements

To configure NetSuite for Databricks ingestion, you must have the following:

• A NetSuite account with a SuiteAnalytics JDBC drivers license.
• Access to the NetSuite2.com data source. The legacy netsuite.com data source is not supported.
• Administrator privileges in NetSuite to create roles, users, and integrations.

Step 1: Enable TBA and create a role and a user

1. In your NetSuite account, go to Setup > Company > Enable Features.
2. Click the SuiteCloud tab.
3. In the Manage Authentication section, enable Token-Based Authentication.
4. Click Save.
5. Go to Setup > Users/Roles > Manage Roles > New.
6. Enter a role name (for example, LakeFlowRole).
7. On the Permissions tab, under Settings, add the following permissions:
   • Log in using Access Tokens
   • SuiteAnalytics Connect
   • Deleted Records
   • Custom Record Types
   • Custom Body Fields
   • Custom Column Fields
   • Custom Entity Fields
   • Custom Event Fields
   • Custom Item Fields
8. Click Save.
9. Go to Setup > Users/Roles > Manage Users > New.
10. Enter a username (for example, LakeFlowUser) and fill in the required fields.
11. On the Access tab, assign the following roles:
    • The role you created (for example, LakeFlowRole)
    • Data Warehouse Integrator
12. Click Save.

Step 2: Fetch the consumer key and secret

1. In NetSuite, go to Setup > Integration > Manage Integrations > New.

2. Enter a name for the integration (for example, Lakeflow Integration).

3. Enable Token-Based Authentication.

4. Optionally, configure other settings as needed for your organization.

5. Click Save.

6. After saving, NetSuite displays the Consumer Key and Consumer Secret. Copy these values to a secure location. You'll use them to create a connection in Databricks.

   important

   The consumer secret is only shown once. If you lose it, you must create a new integration.

Step 3: Fetch the token ID and secret

1. In NetSuite, log in as the user you created (for example, LakeFlowUser).

2. Go to Setup > Users/Roles > Access Tokens > New.

3. Select the application (integration) you created (for example, Lakeflow Integration).

4. Select the role you created (for example, LakeFlowRole).

5. Click Save.

6. NetSuite displays the Token ID and Token Secret. Copy these values to a secure location. You'll use them to create a connection in Databricks.

   important

   The token secret is only shown once. If you lose it, you must create a new access token.

Step 4: Get the role ID

1. In NetSuite, go to Setup > Users/Roles > Manage Roles.
2. Search for the Data Warehouse Integrator role.
3. Click the role to view its details.
4. Copy the Internal ID (role ID) to a secure location. You'll use it to create a connection in Databricks.

Step 5: Find the host, port, and account ID

1. In NetSuite, go to Settings > Set up SuiteAnalytics Connect.
2. The Your Configuration section shows your service host, port, and account ID information. Copy these values to a secure location. You'll use them to create a connection in Databricks.

Next steps

The next steps depend on your user persona:

User	Steps
Admin	Use Catalog Explorer to create a connection so that non-admins can create pipelines or use the data ingestion UI to create a connection and a pipeline.
Non-admin	Use any supported interface to create a pipeline from an existing connection.

Additional resources

• Enable the Token-based Authentication Feature in the NetSuite documentation
• Token-based Authentication (TBA) permissions in the NetSuite documentation