Create a Salesforce Marketing Cloud connection

Create a Salesforce Marketing Cloud 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 Salesforce Marketing Cloud 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 Ingest data from Salesforce Marketing Cloud.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites

Complete Configure OAuth for Salesforce Marketing Cloud ingestion into Azure Databricks. Use the authentication details you obtain to create the connection.

Create a connection

1. In the Azure Databricks workspace, click Catalog > Create > Create a connection.
2. On the Connection basics page of the Set up connection wizard, enter a unique Connection name.
3. In the Connection type drop-down menu, select Salesforce Marketing Cloud.
4. (Optional) Add a comment.
5. Click Next.
6. On the Authentication page, enter the following credentials from the source setup:
   • Subdomain: The 28-character subdomain for your Marketing Cloud instance, starting with mc.
   • Marketing ID: The Marketing ID (MID).
   • Client ID: The client ID from the API Integration Package.
   • Client Secret: The client secret from the API Integration Package.
7. Click Create connection.

Next steps

Ingest data from Salesforce Marketing Cloud.