TDV Adapter for Workday

Build 22.0.8462

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 adapter exposes the data sources the same way Workday does, so tools with these limitations cannot use larger data sources.

Enabling this option allows the adapter to be used with these tools. When split tables are enabled, the adapter 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) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462