ODBC Driver for Workday

Build 23.0.8839

UseSplitTables

Whether to split WQL data sources into multiple tables.

Data Type

bool

Default Value

false

Remarks

Workday data sources will often have several hundred fields, with some data sources like allWorkers having thousands of fields. Many database and reporting tools do not support tables with this many columns. By default the driver exposes the data sources the same way Workday does, so tools with these limitations cannot use larger data sources.

Enabling this option allows the driver to be used with these tools. When split tables are enabled, the driver creates multiple tables for complex Workday data sources. Each split table contains between 50-100 columns, along with the primary key, last modified timestamp and effective and entry inputs.

JOINs can be used if data is required from columns that are part of different split tables.

SELECT a.academicDegree, b.yearsExperience
FROM allWorkers_1 a INNER JOIN allWorkers_60 b
ON a.workdayID = b.workdayID

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