Announcing Workday Data Connect federation in Unity Catalog
We're excited to announce the publicly available Beta of the Workday Data Connect federation connector for Unity Catalog...
Databricks has announced the public beta of the Workday Data Connect federation connector for Unity Catalog, enabling zero-copy access to Workday HR and finance data within the Databricks platform.
What happened
Databricks has released the public beta of the Workday Data Connect federation connector, which allows data teams to access Workday HR and finance data directly within the Databricks Data + AI Platform without copying the data. This integration is part of a partnership between Databricks and Workday, enabling zero-copy data access and governance through Unity Catalog.
Why it matters
This development allows organizations to combine Workday's HR and finance data with other enterprise data sources for real-time analytics and AI applications, improving decision-making and operational efficiency. It also provides a governed, secure way to access data without duplicating it, reducing storage costs and ensuring data consistency.
- Zero-copy data access reduces storage costs and ensures data consistency.
- Unity Catalog provides robust governance and access controls for federated Workday data.
- Organizations can leverage Workday data for real-time analytics and AI applications without moving the data.
- Three integration methods are available, allowing flexibility based on use cases.
- The solution supports natural language queries via Genie and other Databricks tools.
The bigger picture
The integration enables more efficient data analysis and AI application development by allowing direct access to Workday data without duplication. It enhances data governance and security, supports real-time analytics, and reduces the need for complex data pipelines.
Databricks' Workday Data Connect federation connector offers a zero-copy, governed way to access Workday HR and finance data within the Databricks platform, enabling more efficient analytics and AI applications.
Technical details
- Workday Data Connect federation connector
- Unity Catalog
- Lakehouse Federation
- OAuth connection
- Foreign catalog
- Iceberg REST catalog
- JDBC connection
- Delta tables
- SCD2 (Slowly Changing Dimension Type 2)
FAQ
What is Workday Data Connect federation in Databricks?
It is a Lakehouse Federation connector for Unity Catalog that allows Databricks to query Workday HR and finance data directly without copying the data.
Does the Workday connector copy data into Databricks?
No, it provides zero-copy access, so Workday remains the system of record for HR and finance data.
How is Workday data governed in Databricks?
Unity Catalog governs access to federated Workday data through catalog-, schema-, and table-level permissions, ensuring security and compliance.
What are the ways to bring Workday data into Databricks?
There are three methods: Lakeflow Connect for managed ingestion, Workday Data Connect federation for zero-copy analytics, and Live Data Query via JDBC for on-demand lookups.
How can I use Workday data with Genie?
Once Workday data is available in a Unity Catalog foreign catalog with proper permissions, it can be used alongside other data in Genie for natural language queries.
This summary and analysis were generated with AI from the original article and may contain errors. Read the original for the full story.
Read the full story
Originally published by Databricks Blog on Oct 8, 2026.
Comments
Sign in to join the discussion.