ODBC Driver for Workday

Build 23.0.8839

Data Model

WQL APIs

When ConnectionType is set to WQL, the driver models Workday data sources as views. You can get a complete list of these data sources using the Data Sources standard report in Workday. The driver exposes each data source using its WQL Alias which is shown on the View Data Source page.

The driver exposes two kinds of data sources: Prism data sources and Core data sources. All Prism data sources start with the prefix cds_.

  1. Prism data sources provide access to published tables and dataset defined within Prism Analytics. These data sources are easy to consume because they do not require providing values for prompts. They are also the most performant because they are served from dedicated Prism services. However, they must be created explicitly within the Prism Data Catalog and are only updated when they are refreshed within Prism.
  2. Core data sources provide access to built-in Workday data sources like Workers and Journals. Workday does not recommend using these sources directly, as they are both more difficult to query and slower than data sources from Prism. They use the same resources as the rest of your Workday tenant and complex queries (or queries returning many rows) can slow down your tenant for other users. The main behefit of these data sources is that they always contain live data instead of needing to be refreshed.

The driver does not list all the data sources defined within Workday:

  1. The driver only exposes data sources that are accessible to the user you have authenticated as. For example, a user with only HR roles is able to view data sources containing employee records but not data sources about financial assets.
  2. The driver only supports one data source filter per data source. The driver uses the unfiltered version of the data source when it is available, and picks the first filter when a filter is required. See WQLDataSourceFilters for more information.

You can use UseSplitTables to work around this limtiation by splitting each data source into multiple views with fewer columns.

Reports

When ConnectionType is set to Reports, the driver 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. See Fine-Tuning Data Access for details on what is required.

REST APIs

The data model included in the REST section is only available when ConnectionType is set to REST.

SOAP APIs

The data models listed in Service are only available in the SOAP API. ConnectionType must be set to SOAP in order to use them.

Prompts

Many WQL data sources, reports, REST endpoints, and SOAP services have prompts that affect what rows Workday reports. The driver exposes these prompts as input columns that have the _Prompt suffix. Most prompts accept only a single value, but prompts that accept multiple values can be set with IN or equals:

SELECT * FROM [Account Balance Data]
WHERE Company_Prompt IN ('1234567890abcdef', 'f1234567890abcde')
AND Region_Prompt = 'ef1234567890abcd'
AND Include_Managers_Prompt = TRUE
AND Start_Date_Prompt = '2022-01-01'

Other filters may be included with prompts. These do not affect the way Workday generates the report, but the driver removes non-matching rows from the response:

SELECT * FROM [Account Balance Data]

/* Prompts */
WHERE Company_Prompt IN ('1234567890abcdef', 'f1234567890abcde')
AND Region_Prompt = 'ef1234567890abcd'
AND Include_Managers_Prompt = TRUE
AND Start_Date_Prompt = '2022-01-01'

/* Other filters */
AND Department = 'Sales and Marketing'
AND Account_Type = 'LIABILITY'

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839