Create an Oracle Eloqua connection

Important

This feature is in Beta. To use it, a workspace admin must turn on Lakeflow Connect for Oracle Eloqua from the Previews page. See Manage Azure Databricks previews.

Create an Oracle Eloqua 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 Oracle Eloqua 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 Oracle Eloqua.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites

Complete the source setup. Use the credentials and API base URL retrieved there 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, specify a Connection name.
3. In the Connection type drop-down menu, select Oracle Eloqua.
4. (Optional) Add a comment.
5. Click Next.
6. On the Authentication page, enter the following credentials from Configure authentication to Oracle Eloqua:
   • Client ID: The Client ID of your Oracle Eloqua OAuth application.
   • Client Secret: The Client Secret of your Oracle Eloqua OAuth application.
   • API Base URL: The base URL of your Oracle Eloqua instance, for example https://secure.p03.eloqua.com.
7. Click Sign in with Oracle Eloqua. Sign in to Oracle Eloqua and accept the app's request to access Oracle Eloqua on your behalf.
8. Complete authentication and return to the connection form.
9. Click Create connection.

Next steps

Create an ingestion pipeline.