Create a ServiceNow connection

Create a ServiceNow connection in Catalog Explorer to store authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create ServiceNow 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.

The following authentication methods are supported:

• U2M OAuth (recommended)
• OAuth Resource Owner Password Credentials (ROPC)

Prerequisites

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

Create a connection

U2M OAuth

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 ServiceNow.

4. In the Auth type drop-down menu, select OAuth.

5. (Optional) Add a comment.

6. Click Next.

7. On the Authentication page, enter the following:

   • Instance URL: ServiceNow instance URL.
   • OAuth scope: Leave the default value useraccount.
   • Client secret: The client secret that you obtained in the source setup.
   • Client ID: The client ID that you obtained in the source setup.

8. Click Sign in with ServiceNow.

9. Sign in using your ServiceNow credentials.

   You're redirected to the Databricks workspace.

10. Click Create connection.

ROPC

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 ServiceNow.
4. In the Auth type drop-down menu, select OAuth Resource Owner Password.
5. (Optional) Add a comment.
6. Click Next.
7. On the Authentication page, enter the following:
   • User: Your ServiceNow username.
   • Password: Your ServiceNow password.
   • Instance URL: ServiceNow instance URL.
   • Client ID: The client ID that you obtained in the source setup.
   • Client secret: The client secret that you obtained in the source setup.
8. Click Create connection.

Next steps

Create an ingestion pipeline.