We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →How to Access Live Workday Data in Power Automate Desktop via ODBC
The CData ODBC Driver for Workday enables you to integrate Workday data into workflows built using Microsoft Power Automate Desktop.
The CData ODBC Driver for Workday enables you to access live Workday data in workflow automation tools like Power Automate. This article shows how to integrate Workday data into a simple workflow, moving Workday data into a CSV file.
Through optimized data processing, CData ODBC Drivers offer unmatched performance for interacting with live Workday data in Microsoft Power Automate. When you issue complex SQL queries from Power Automate to Workday, the driver pushes supported SQL operations, like filters and aggregations, directly to Workday and utilizes the embedded SQL engine to process unsupported operations client-side (e.g. SQL functions and JOIN operations).
About Workday Data Integration
CData provides the easiest way to access and integrate live data from Workday. Customers use CData connectivity to:
- Access the tables and datasets you create in Prism Analytics Data Catalog, working with the native Workday data hub without compromising the fidelity of your Workday system.
- Access Workday Reports-as-a-Service to surface data from departmental datasets not available from Prism and datasets larger than Prism allows.
- Access base data objects with WQL, REST, or SOAP, getting more granular, detailed access but with the potential need for Workday admins or IT to help craft queries.
Users frequently integrate Workday with analytics tools such as Tableau, Power BI, and Excel, and leverage our tools to replicate Workday data to databases or data warehouses. Access is secured at the user level, based on the authenticated user's identity and role.
For more information on configuring Workday to work with CData, refer to our Knowledge Base articles: Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service & Workday + CData: Connection & Integration Best Practices.
Getting Started
Connect to Workday as an ODBC Data Source
If you have not already, first specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. You can use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.
To connect to Workday, users need to find the Tenant and BaseURL and then select their API type.
Obtaining the BaseURL and Tenant
To obtain the BaseURL and Tenant properties, log into Workday and search for "View API Clients." On this screen, you'll find the Workday REST API Endpoint, a URL that includes both the BaseURL and Tenant.
The format of the REST API Endpoint is: https://domain.com/subdirectories/mycompany, where:
- https://domain.com/subdirectories/ is the BaseURL.
- mycompany (the portion of the url after the very last slash) is the Tenant.
Using ConnectionType to Select the API
The value you use for the ConnectionType property determines which Workday API you use. See our Community Article for more information on Workday connectivity options and best practices.
API | ConnectionType Value |
---|---|
WQL | WQL |
Reports as a Service | Reports |
REST | REST |
SOAP | SOAP |
Authentication
Your method of authentication depends on which API you are using.
- WQL, Reports as a Service, REST: Use OAuth authentication.
- SOAP: Use Basic or OAuth authentication.
See the Help documentation for more information on configuring OAuth with Workday.
When you configure the DSN, you may also want to set the Max Rows connection property. This will limit the number of rows returned, which is especially helpful for improving performance when designing workflows.
Integrate Workday Data into Power Automate Workflows
After configuring the DSN for Workday, you are ready to integrate Workday data into your Power Automate workflows. Open Microsoft Power Automate, add a new flow, and name the flow.

In the flow editor, you can add the actions to connect to Workday, query Workday using SQL, and write the query results to a CSV document.
Add an Open SQL Connection Action
Add an "Open SQL connection" action (Actions -> Database) and configure the properties.
- Connection string: DSN=CData Workday Source
After configuring the action, click Save.

Add an Execute SQL Statement Action
Add an "Execute SQL statement" action (Actions -> Database) and configure the properties.
- Get connection by: SQL connection variable
- SQL connection: %SQLConnection% (the variable from the "Open SQL connection" action above)
- SQL statement: SELECT * FROM Workers
After configuring the action, click Save.

Add a Write to CSV File Action
Add a "Write to CSV file" action (Actions -> File) and configure the properties.
- Variable to write to: %QueryResult% (the variable from the "Execute SQL statement" action above)
- File path: set to a file on disk
- Configure Advanced settings as needed.
After configuring the action, click Save.

Add a Close SQL Connection Action
Add a "Close SQL connection" action (Actions -> Database) and configure the properties.
- SQL Connection: %SQLConnection% (the variable from the "Open SQL connection" action above)
After configuring the action, click Save.

Save & Run the Flow
Once you have configured all the actions for the flow, click the disk icon to save the flow. Click the play icon to run the flow.

Now you have a workflow to move Workday data into a CSV file.

With the CData ODBC Driver for Workday, you get live connectivity to Workday data within your Microsoft Power Automate workflows.
Related Power Automate Articles
This article walks through using the CData ODBC Driver for Workday with Power Automate Desktop. Check out our other articles for more ways to work with Power Automate (Desktop & Online):