# \#workday **URL:** https://community.cdata.com/tag/workday/67.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [Comprehensive Workday Integration with CData Sync](https://community.cdata.com/t/comprehensive-workday-integration-with-cdata-sync/1158)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [August 8, 2025, 2:01pm UTC](https://community.cdata.com/t/comprehensive-workday-integration-with-cdata-sync/1158 "2025-08-08T14:01:25Z")
Most ETL/ELT tools provide connectivity to Workday; however, the connection is limited because it is only through Reports as a Service (RaaS). With the CData Sync Workday connector, users get more connection options, inc… --- ## [How to Access Live Data from the WQL for a Workday Report](https://community.cdata.com/t/how-to-access-live-data-from-the-wql-for-a-workday-report/1007)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [January 29, 2025, 6:07pm UTC](https://community.cdata.com/t/how-to-access-live-data-from-the-wql-for-a-workday-report/1007 "2025-01-29T18:07:11Z")
CData Workday Drivers and Connectors now allow users to create tables that execute specific Workday Query Language (WQL) statements for Workday reports. The new stored procedure, CreateWQLSchema, processes the output fro… --- ## [Replicate Workday WQL Data to Snowflake using Workday Prompts (without errors)](https://community.cdata.com/t/replicate-workday-wql-data-to-snowflake-using-workday-prompts-without-errors/711)
**Author:** [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\ **Replies:** 1\ **Last updated:** [May 16, 2024, 1:36pm UTC](https://community.cdata.com/t/replicate-workday-wql-data-to-snowflake-using-workday-prompts-without-errors/711 "2024-05-16T13:36:27Z")
Replicating Workday Data: The Challenges Replicating Workday HCM and Financials data can be a challenging task in itself, especially when the Workday APIs are so vast, support a variety of data models, and offer differen… --- ## [unable to view the data from customerinvocies view](https://community.cdata.com/t/unable-to-view-the-data-from-customerinvocies-view/709)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [May 7, 2024, 3:06pm UTC](https://community.cdata.com/t/unable-to-view-the-data-from-customerinvocies-view/709 "2024-05-07T15:06:34Z")
Hi Ethem, i am unable to the data in customerinvoices object. any filters do we need to appliy kindly help me. i have attached the error images please check.. Thanks, Chari --- ## [Unable to schedule the CData SSIS job in sql server Agent job.](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 1\ **Last updated:** [April 26, 2024, 10:32pm UTC](https://community.cdata.com/t/unable-to-schedule-the-cdata-ssis-job-in-sql-server-agent-job/703 "2024-04-26T22:32:12Z")
Hi Ethem Q, i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing w… --- ## [Unabale to see the user created workday views/datasets on CData SSIS connector](https://community.cdata.com/t/unabale-to-see-the-user-created-workday-views-datasets-on-cdata-ssis-connector/681)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [April 26, 2024, 7:13pm UTC](https://community.cdata.com/t/unabale-to-see-the-user-created-workday-views-datasets-on-cdata-ssis-connector/681 "2024-04-26T19:13:20Z")
Hi Team, in workday SSIS cdata connector whatever my team has been created new views based on workday system datasets are not visible on views dropdown list. is there any permissions issue? or user created views we w… --- ## [Error from Workday SSIS connector extention question](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 3\ **Last updated:** [March 20, 2024, 6:56pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector-extention-question/666 "2024-03-20T18:56:12Z")
Hi Ethem, thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attac… --- ## [Error from Workday SSIS connector](https://community.cdata.com/t/error-from-workday-ssis-connector/664)
**Author:** [@Renukachari\_Kasee](https://community.cdata.com/u/Renukachari_Kasee)\ **Replies:** 7\ **Last updated:** [March 15, 2024, 6:42pm UTC](https://community.cdata.com/t/error-from-workday-ssis-connector/664 "2024-03-15T18:42:25Z")
Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise. “Invalid FROM clause starting with character: 6405. Invalid WQL syntax.” i am using below query from workday. select \* fro… --- ## [CData Sync – HTTPS endpoint connectivity enablement (Linux)](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-linux/639)
**Author:** [@Aleksander\_P](https://community.cdata.com/u/Aleksander_P)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 2:28pm UTC](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-linux/639 "2024-02-23T14:28:51Z")
There are several data sources (Workday, Google BigQuery) that require HTTPS connectivity, in order to define a successful source/destination connection within CData Sync. By default, Sync is installed as HTTP web ser… --- ## [CData Sync – HTTPS endpoint connectivity enablement (Windows)](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-windows/638)
**Author:** [@Aleksander\_P](https://community.cdata.com/u/Aleksander_P)\ **Replies:** 0\ **Last updated:** [February 23, 2024, 2:19pm UTC](https://community.cdata.com/t/cdata-sync-https-endpoint-connectivity-enablement-windows/638 "2024-02-23T14:19:39Z")
There are several data sources (Workday, Google BigQuery) that require HTTPS connectivity, in order to define a successful source/destination connection within CData Sync. By default, Sync is installed as HTTP web serve… --- ## [Workday WQL Error](https://community.cdata.com/t/workday-wql-error/582)
**Author:** [@joshphillipssr](https://community.cdata.com/u/joshphillipssr)\ **Replies:** 1\ **Last updated:** [December 22, 2023, 9:21pm UTC](https://community.cdata.com/t/workday-wql-error/582 "2023-12-22T21:21:04Z")
Using CData Sync Cross Platform with Workday WQL connection. Some queries work successfully, but a bunch fail with this message: \[0\] Received error from Workday: Invalid WQL query: !\*\*! This error occurred during a requ… --- ## [Enable object permissions in Workday](https://community.cdata.com/t/enable-object-permissions-in-workday/491)
**Author:** [@Rodrigo\_de\_Albuquerque](https://community.cdata.com/u/Rodrigo_de_Albuquerque)\ **Replies:** 0\ **Last updated:** [October 26, 2023, 5:52pm UTC](https://community.cdata.com/t/enable-object-permissions-in-workday/491 "2023-10-26T17:52:38Z")
When you query a table or view using any of our Workday connectors, you might see an error like the below or anything similar which mentions denied permissions: In this case, the user needs to give permissions to… --- ## [How to find the correct value for the Host and Tenant in Workday](https://community.cdata.com/t/how-to-find-the-correct-value-for-the-host-and-tenant-in-workday/444)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [October 9, 2023, 3:37pm UTC](https://community.cdata.com/t/how-to-find-the-correct-value-for-the-host-and-tenant-in-workday/444 "2023-10-09T15:37:50Z")
To get the correct value for the Host and Tenant connection properties, please follow this link: CData ODBC Driver for Workday - Host All you have to do is log in to your workday account and navigate to View API Cli… --- ## [Welcome to the Ask Me Anything (AMA) on CData Workday Integrations! 🎉](https://community.cdata.com/t/welcome-to-the-ask-me-anything-ama-on-cdata-workday-integrations/413)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 6\ **Last updated:** [September 28, 2023, 3:29pm UTC](https://community.cdata.com/t/welcome-to-the-ask-me-anything-ama-on-cdata-workday-integrations/413 "2023-09-28T15:29:17Z")
:spiral\_calendar: Event Dates: September 22-29, 2023 :round\_pushpin: Location: Right here in this threaded discussion on the CData Community Site :busts\_in\_silhouette: Experts on Deck: Jerod Johnson, Riley James, Jon Ty… --- ## [Workday + CData: Connection & Integration Best Practices](https://community.cdata.com/t/workday-cdata-connection-integration-best-practices/421)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [September 26, 2023, 2:53pm UTC](https://community.cdata.com/t/workday-cdata-connection-integration-best-practices/421 "2023-09-26T14:53:21Z")
CData provides comprehensive connectivity to your Workday data. If you’re just getting started, you can read our Knowledge Base article on connecting to the robust Workday Query Language (WQL) and Reports-as-a-Service (R… --- ## [Workday Newsletter](https://community.cdata.com/t/workday-newsletter/416)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [September 26, 2023, 2:41pm UTC](https://community.cdata.com/t/workday-newsletter/416 "2023-09-26T14:41:42Z")
Finally! Connect to Workday data in your favorite data tools With the Workday Rising event kicking off in San Francisco this week, we’re highlighting CData connectivity solutions that help you bring Workday data to ent… --- ## [New Case Study Alert: Santa Clara University Leverages CData for Workday Integration 📊](https://community.cdata.com/t/new-case-study-alert-santa-clara-university-leverages-cdata-for-workday-integration/408)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [September 21, 2023, 6:00pm UTC](https://community.cdata.com/t/new-case-study-alert-santa-clara-university-leverages-cdata-for-workday-integration/408 "2023-09-21T18:00:23Z")
Hey Community, We’re thrilled to share a new case study that showcases how Santa Clara University is using CData to connect to Workday and visualize historical student data. This is an excellent example of how CData’s… --- ## [📣 Announcement: Ask Me Anything (AMA) on Workday & CData Integrations](https://community.cdata.com/t/announcement-ask-me-anything-ama-on-workday-cdata-integrations/403)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [September 19, 2023, 8:45pm UTC](https://community.cdata.com/t/announcement-ask-me-anything-ama-on-workday-cdata-integrations/403 "2023-09-19T20:45:16Z")
:spiral\_calendar: Event Dates: September 22-29, 2023 :round\_pushpin: Where: Threaded discussion right here on the CData Community Site :busts\_in\_silhouette: Experts on Deck: Jerod Johnson, Riley James, Jon Tye, and oth… --- ## [🌟 CData Experts at Workday Rising 2023: Let's Discuss the Future of Work and Innovation! 🌟](https://community.cdata.com/t/cdata-experts-at-workday-rising-2023-lets-discuss-the-future-of-work-and-innovation/385)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [September 7, 2023, 6:30pm UTC](https://community.cdata.com/t/cdata-experts-at-workday-rising-2023-lets-discuss-the-future-of-work-and-innovation/385 "2023-09-07T18:30:55Z")
Hey CData Community, We’re excited to share that our experts will be attending the Workday Rising event on September 26–29 in San Francisco, California. This event promises to be a fantastic mix of innovation, community… --- ## [Workday & CData (video playlist)](https://community.cdata.com/t/workday-cdata-video-playlist/364)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [August 29, 2023, 6:11pm UTC](https://community.cdata.com/t/workday-cdata-video-playlist/364 "2023-08-29T18:11:30Z")
Connect Workday to the Tools you Love with CData Software Access Workday data in all of the systems you use every day, including BI & analytics tools, databases, data warehouses, and custom apps. BI & analytics: Access, … --- ## [Workday – must include inputs (“prompts”) to query certain tables](https://community.cdata.com/t/workday-must-include-inputs-prompts-to-query-certain-tables/351)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [August 22, 2023, 7:40pm UTC](https://community.cdata.com/t/workday-must-include-inputs-prompts-to-query-certain-tables/351 "2023-08-22T19:40:47Z")
Workday requires inputs, which they call “prompts”, to successfully execute queries. The inputs are rarely intuitive values. For example, to query journalLines, you need to use the following query: SELECT \* FROM j… --- ## [Tip of the Quarter: Easily publish real-time Workday data to PowerBI.com or Power BI desktop](https://community.cdata.com/t/tip-of-the-quarter-easily-publish-real-time-workday-data-to-powerbi-com-or-power-bi-desktop/181)
**Author:** [@Lori](https://community.cdata.com/u/Lori)\ **Replies:** 0\ **Last updated:** [May 9, 2023, 5:28pm UTC](https://community.cdata.com/t/tip-of-the-quarter-easily-publish-real-time-workday-data-to-powerbi-com-or-power-bi-desktop/181 "2023-05-09T17:28:24Z")
There are so many benefits to connecting real-time to Workday data from Power BI. No install, just signup for Connect Cloud \> Configure DSN. Easily find the connector in Power BI (under Other data sources) Connection t… --- ## [Looker & CData Connect Cloud (video playlist)](https://community.cdata.com/t/looker-cdata-connect-cloud-video-playlist/143)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [April 5, 2023, 6:21pm UTC](https://community.cdata.com/t/looker-cdata-connect-cloud-video-playlist/143 "2023-04-05T18:21:21Z")
Work with Live Workday Data in Looker Studio Use CData Connect Cloud to connect to Workday and provide access to live Workday data in Looker Studio. Work with Live SharePoint Data in Looker Studio Use CD… --- ## [Power BI & CData (video playlist)](https://community.cdata.com/t/power-bi-cdata-video-playlist/142)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [April 5, 2023, 5:22pm UTC](https://community.cdata.com/t/power-bi-cdata-video-playlist/142 "2023-04-05T17:22:58Z")
CData Power BI Connectors - Getting Started A brief overview of downloading, installing, and analyzing data in Power BI using a CData Power BI Connector. How to Connect to Workday in Power BI Learn how t… --- ## [Unable to see Views in WorkDay JDBC connection.](https://community.cdata.com/t/unable-to-see-views-in-workday-jdbc-connection/106)
**Author:** [@prestona](https://community.cdata.com/u/prestona)\ **Replies:** 1\ **Last updated:** [March 24, 2023, 9:07pm UTC](https://community.cdata.com/t/unable-to-see-views-in-workday-jdbc-connection/106 "2023-03-24T21:07:11Z")
I just connected with the CData Workday JDBC driver and I am only able to see the Stored Procedures but no views. My connection string looks like this: jdbc:cdata:workday:User=myuser;Password=mypassword;Tenant=mycompany… --- ## [Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service](https://community.cdata.com/t/comprehensive-workday-connectivity-through-workday-wql-and-reports-as-a-service/65)
**Author:** [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\ **Replies:** 0\ **Last updated:** [March 20, 2023, 9:21pm UTC](https://community.cdata.com/t/comprehensive-workday-connectivity-through-workday-wql-and-reports-as-a-service/65 "2023-03-20T21:21:28Z")
The CData connectivity solutions for Workday enable seamless integration of Workday data in modern reporting, analytics, ETL, and custom applications. CData’s standards-based drivers and connectors include built-in suppo…