The CData ADO.NET Provider for Workday models Workday data as an easy-to-use SQL database with tables, views, and stored procedures.

The provider exposes four data models, which you select in ConnectionType:

• WQL exposes Workday data sources as read-only views using the Workday Query Language (WQL) service.
• Reports exposes Workday reports as views using Reports as a Service (RaaS). When ConnectionType is set to Reports, the provider also grants access to reports that are exposed using Reports as a Service (RaaS). These reports are exposed as views within the Reports schema. Accessing these reports requires extra connection setup beyond the basic settings for WQL access. For details on what is required, see Fine-Tuning Data Access.
• REST exposes Workday data as tables and views using the REST API.
• SOAP exposes Workday data as views using the SOAP API. The data models listed in Service are only available in the SOAP API.

Note: For performance reasons, you should use WQL instead of SOAP in most situations. WQL generally is much more performant because it supports server-side filtering and aggregation.

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, and can be used to manage job changes, events, and projects in Workday.