Skip to main content
Last updated on

Create a NetSuite connection

Create a NetSuite connection in Catalog Explorer to store token-based authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create NetSuite ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites​

Complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection​

  1. In the Databricks workspace, click Catalog > External locations > Connections > Create connection.
  2. On the Connection basics page of the Set up connection wizard, specify a unique Connection name.
  3. In the Connection type drop-down menu, select NetSuite.
  4. (Optional) Add a comment.
  5. Click Next.
  6. On the Authentication page, enter the following credentials:
    • Consumer Key: The OAuth consumer key from your NetSuite integration.
    • Consumer Secret: The OAuth consumer secret from your NetSuite integration.
    • Token ID: The access token ID for your NetSuite user.
    • Token Secret: The access token secret for your NetSuite user.
    • Role ID: The internal ID of the Data Warehouse Integrator role in NetSuite.
    • Host: The hostname from your NetSuite JDBC URL.
    • Port: The port number from your NetSuite JDBC URL.
    • Account ID: The account ID from your NetSuite JDBC URL.
  7. Click Test connection to verify that you can connect to NetSuite.
  8. Click Create connection.

Next steps​

Create an ingestion pipeline.

On this page