Create a Workday Reports connection

Create a Workday Reports 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 Workday Reports 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. For Connection name, enter a unique name for the Workday connection.
3. For Connection type, select Workday Reports.
4. For Auth type, select OAuth Refresh Token or Username and password (basic authentication), then click Next.
5. (OAuth refresh token) On the Authentication page, enter the Client ID, Client secret, and Refresh token that you obtained in the source setup.
6. (Basic authentication) Enter your Workday username and password.
7. Click Create connection.

Next steps

Create an ingestion pipeline.