# Comprehensive Workday Connectivity through Workday WQL and Reports-as-a-Service

**URL:** <https://community.cdata.com/t/comprehensive-workday-connectivity-through-workday-wql-and-reports-as-a-service/65>\
**Category:** How-to with CData\
**Tags:** article, driver, workday, wql\
**Created:** [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")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![jerodj-cdata](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/jerodj-cdata/32/7_2.png) [@jerodj-cdata](https://community.cdata.com/u/jerodj-cdata)\
**Post date:** [March 20, 2023, 9:21pm UTC](https://community.cdata.com/t/comprehensive-workday-connectivity-through-workday-wql-and-reports-as-a-service/65/1 "2023-03-20T21:21:28Z")

</div>

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 support for Workday WQL and Reports-as-a-Service, enabling any user to work with exactly the Workday data they need in their preferred tools, applications, and platforms.

In this article, we walk through the complex querying available via CData’s support for Workday WQL and walk through configuring your Workday instance and your CData solution to enable CData’s support of Workday WQL and Reports-as-a-Service.

#### Contents

1. [Powerful Querying through Workday WQL](https://www.cdata.com/kb/articles/workday-wql-raas.rst#query)
2. [Connecting to the Workday WQL Service](https://www.cdata.com/kb/articles/workday-wql-raas.rst#wql)
3. [Connecting to Workday Reports-as-a-Service](https://www.cdata.com/kb/articles/workday-wql-raas.rst#raas)

## Powerful Querying through Workday WQL

The Workday WQL service enables high-performance querying of Workday data. Each CData Workday connectivity solution has a built-in SQL Engine that is optimized to work with Workday WQL. As such, CData solutions are able to push the complexities of queries for data down to Workday for processing. This results in faster responses to queries and less reliance on client-side resources for data processing. Supported SQL includes:

- Naming specific fields (columns) in&nbsp; **SELECT** &nbsp;statements
- SQL&nbsp; **WHERE** &nbsp;clauses to filter results
- SQL&nbsp; **GROUP BY** &nbsp;statements
- SQL&nbsp; **ORDER BY** &nbsp;statements
- SQL&nbsp; **LIMIT**
- SQL aggregations
  - **COUNT**
  - **COUNT(DISTINCT)**
  - **AVG**
  - **MIN**
  - **MAX**
  - **SUM**

- SQL inner and left&nbsp; **JOIN** &nbsp;statements

## Connecting to the Workday WQL Service

1. Enable the Workday WQL service before connecting from CData solutions:

2. Create a custom OAuth application for authentication through CData connectivity solutions:

3. Create a connection string or enter connection properties to connect to Workday:

## Connecting to Workday Reports-as-a-Service

To read reports exposed the through the Workday Reports-as-a-Service, set the&nbsp; **UseWQL** &nbsp;property to true in the CData solution and create a custom report to use this feature.

1. In Workday, open the Create Custom Report task.

2. Name the report&nbsp; **Reports as a Service**.

3. Enter&nbsp; **Advanced** &nbsp;for the report type.

4. Select&nbsp; **Enable As Web Service**.

5. Clear&nbsp; **Optimized for Performance**.

6. Enter&nbsp; **All Custom Reports** &nbsp;for the Data Source.

After the report is created, configure the report by adding columns and filters:

1. Add 4 Columns:&nbsp; **Fields** , add&nbsp;_Report Name_,&nbsp;_Web Service Namespace_,&nbsp;_Report Owner_, and&nbsp;_Brief Description_.

2. Set “Business Object” to&nbsp;_Custom Report_&nbsp;(select&nbsp;_Primary Business Object_,&nbsp;_Custom Report_)

3. Open the&nbsp;_Filter_&nbsp;tab and create 2 filters, using the&nbsp;_And_&nbsp;condition:

4. Click “OK” to save the report and click to dismiss any warnings.

The final step to accessing Reports as a Service is finding the URL associated with the report. This URL is used for the&nbsp; **CustomReportURL** &nbsp;connection property in your CData connectivity solution.

1. Open the newly created report.

2. Click the ellipsis (…) button beside the report title.

3. Find the&nbsp;_Web Services_&nbsp;tab within the pop-up.

4. Hover over the&nbsp;_Web Services_&nbsp;tab and select “View URLs.”

5. Right-click and copy the&nbsp;_Workday XML_&nbsp;URL.

At this point, you will be able to read data from any Custom Reports created in Workday.

## Free Trials & More Information

Thanks to CData connectivity solutions, working with your Workday data has never been easier, whether you are working in on-premise BI, reporting, ETL or custom applications through&nbsp;[Workday drivers and connectors](https://www.cdata.com/drivers/workday), replicating Workday data to a database, data lake or data warehouse using&nbsp;[CData Sync](https://www.cdata.com/sync), or connecting cloud platforms and applications to Workday through&nbsp;[CData Connect Cloud](https://www.cdata.com/cloud). Download a&nbsp;[free, 30-day trial](https://www.cdata.com/drivers/workday/download/)&nbsp;of any of our solutions (or start a&nbsp;[free trial](https://cloud.cdata.com/)&nbsp;of CData Connect Cloud) and start getting more out of your Workday data today.