Workday HCM connector reference

Important

This feature is in Beta. Workspace admins can control access to this feature from the Previews page. See Manage Azure Databricks previews.

This page contains reference documentation for the managed Workday Human Capital Management (HCM) connector in Lakeflow Connect.

Supported data

The connector supports the following tables:

• workers
• payroll_result

Automated transformations

Workday returns a highly nested response from its API. Azure Databricks automatically unnests this data. As a result, each source table has one raw table (for example, workers_raw) and one or more unnested tables (for example, workers).

The following table lists the raw tables and their corresponding materialized views:

Raw table name	Materialized view
workers_raw	worker_positions worker_position_payroll_reporting_code worker_position_job_classification worker_position_compensation worker_collective_agreement worker_probation_period worker_position_manager worker_position_end_employment_reason worker_leave_status worker_secondary_termination_reason worker_position_organization workers
payroll_result_raw	payroll_national_id payroll_line payroll_line_pay_component payroll_line_related_calculation payroll_line_withholding payroll_local_city_authority_tax_worktag payroll_local_county_authority_tax_worktag payroll_state_authority_tax_worktag payroll_result

Connection properties

When you create a connection to Workday HCM, you must provide the following properties. To retrieve these values, see Configure authentication to Workday HCM. For steps to create the connection, see Workday HCM.

Property	Description
Client ID	The OAuth client ID from the registered API client in Workday.
Client Secret	The OAuth client secret from the registered API client in Workday.
Refresh Token	The OAuth refresh token generated for the integration system user account.
Tenant Name	Your Workday tenant identifier. To find this value, select My Account > Organization ID in Workday.
Instance URL	The URL of your Workday instance (for example, https://wd2-impl-services1.workday.com).