| |
| Date | Build
Number | Change
Type | Description |
| 10/06/2025 | 9410 | General | Added
- Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 09/26/2025 | 9400 | Workday | Added
- Added support for manually toggling response groups on and off when the ConnectionType connection property is set to "SOAP". Each table's applicable response groups are represented by new boolean columns with the suffix "_RespGroup". A "WHERE X_RespGroup = true" filter on any response group column includes the response group, and "WHERE X_RespGroup - false" excludes the response group.
|
| 09/12/2025 | 9386 | General | Added
- Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 09/10/2025 | 9384 | General | Changed
- All columns in statically defined Views are now reported as read-only.
|
| 09/03/2025 | 9377 | General | Changed
- Corrected the behavior when IN criteria with NULL values are used in the projection part. It now returns NULL instead of 0. For example, "NULL IN (1,2)" returns "NULL".
|
| 09/01/2025 | 9375 | General | Added
- Added support for using the CAST function with infinity values. This function can cast "inf" and "-inf" to DOUBLE, FLOAT, or REAL.
|
| 08/22/2025 | 9365 | Workday | Added
- Added support for AuthScheme=Basic user/password authentication with ConnectionType=Reports.
|
| 08/21/2025 | 9364 | General | Changed
- Report behavior change:
- Fixed inconsistent string value comparisons in non-table queries.
- For example, "SELECT 'A' = 'a'" previously returned false, but it now returns true.
|
| 08/13/2025 | 9356 | General | Changed
- Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 07/07/2025 | 9319 | Python | Removed
- Removed the 32-bit version of Windows Python.
|
| 07/02/2025 | 9314 | Python | Removed
- Removed support for Python 3.9.
|
| 06/30/2025 | 9312 | Workday | Added
- Fields with the RichText data type are now exposed as columns. This change added about 300 new text columns to the data model.
|
| 06/25/2025 | 9307 | General | Removed
- Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 06/25/2025 | 9307 | Python | Added
- Added support for Python 3.13 in Windows, Linux, and Mac editions.
Removed
- Removed support for Python 3.8 as it is no longer supported.
|
| 06/20/2025 | 9302 | General | Added
- Created the following functions:
- TEXT_ENCODE: encodes a string into a different charset (UTF8 → UTF7 and returns a binary array as the result).
- TEXT_DECODE: takes a binary array and decodes it back into a string when provided the charset.
- BASE64_ENCODE: takes a binary array and encodes it as a base64 string (varchar).
- BASE64_DECODE: takes a base 64-encoded string and decodes it into a binary array.
|
| 06/18/2025 | 9300 | General | Changed
- The internal code for exception handling has been refactored. Exception messages returned during certain error conditions may now have different wording or formatting.
|
| 06/03/2025 | 9285 | Workday | Changed
- The data model for ConnectionType=REST now includes multiple schemas. Each schema represents an API service and contains the tables that access the service's data. The table names have not been changed.
|
| 05/28/2025 | 9279 | Workday | Changed
- The default SOAP API version (WSDLVersion) was updated from v42.2 to v44.1. The old version remains accessible by manually changing the property back to v42.2. Here are the key points summarizing the differences between version 44.1 and version 42.2: Many tables have been converted into single-entry collections. If you discover that the tables you rely on have been removed in version 44.1, try updating the SingleEntryTables to include the affected tables. If you use the following schemas, CData recommends you check the Workday SOAP service changelog for updates on deprecated SOAP operations. It is important to confirm that any operations still in use are available in the new version. Also, opting into API services that are not available by default can provide more flexibility.
- Payroll
- Revenue_Management
- Inventory
- Compensation
- Scheduling
- Student_Finance
|
| 05/27/2025 | 9278 | General | Removed
- Removed the "Proprietary" enum option from ProxyAuthscheme.
|
| 05/12/2025 | 9263 | Python | Changed
- Updated embedded JRE to jre-17.0.15+6 (Linux x64 / MacOS x64) and jre-17.0.15+6 (MacOS aarch64).
|
| 02/15/2025 | 9177 | General | Added
- Added support for converting unsigned integer types to the nearest signed data type that has enough precision to hold the unsigned value.This is done for JDBC only because it does not have support for unsigned data types.
|
| 11/27/2024 | 9097 | General | Added
- Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
|
| 11/01/2024 | 9071 | Workday | Removed
- Removed support for the AuditLogs table. This table has been deprecated by Workday and is no longer supported.
- Removed all tables and procedures related to the Application Attributes API.
|
| 09/10/2024 | 9019 | Workday | Changed
- Updated the default SOAP API version in the WSDLVersion connection property to v42.2.
- Updated the REST API schema to reflect version 20240907 of the API.
Added
- Added several tables and views to the REST schema.
|
| 08/29/2024 | 9007 | Workday | Removed
- Removed support for the AuthScheme=Auto setting. The default AuthScheme is now set to OAuth. If using SOAP, set AuthScheme=Basic to maintain the previous behavior. No changes are required for other services.
|
| 08/05/2024 | 8983 | Workday | Added
- Added a new stored procedure, CreateWQLSchema, which enables users to create tables in the driver that execute specific WQL in Workday. The new stored procedure can be used with the Workday Convert Report to WQL task to get the same data as the report, but with better performance than the Reports service.
|
| 07/23/2024 | 8970 | Workday | Added
- Added support for setting effective dates in the SOAP API using the new As_Of_Effective_Date_RespFilter prompt column.
|
| 06/28/2024 | 8945 | Workday | Added
- Added the connection property IncludeRESTTenantFields, which enables the driver to fetch and merge tenant-specific schemas with the shared schema. This exposes additional fields unique to your Workday tenants. Note that due to API limintations, tenant-specific schema merges with the shared schema is only supported for top-level tables and their children. It is not supported for tables requiring an owner ID to access schemas.
|
| 06/14/2024 | 8931 | Workday | Added
- Added support for complex multi-value prompt values in the SOAP API. See "Aggregate Prompts" in the Data Model page for an example of a new prompt and how to use it.
|
| 06/05/2024 | 8922 | Python | Added
- Added support for Python 3.12.
|
| 05/20/2024 | 8906 | Workday | Changed
- Workday previously reported time values as text when using the WQL service. Now the driver parses them internally and reports them as actual time values.
Added
- Added support in the WQL service for time functions like HOUR().
|
| 05/15/2024 | 8901 | Workday | Changed
- The driver now defaults to using Workday API v42.1 for the SOAP service. To use a previous version of the API, set the WSDLVersion property to the desired version. For Workday's list of API updates or deprecations, see https://community.workday.com/current/wsrelnotes.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 05/02/2024 | 8888 | Workday | Added
- Updated REST API schemas to the 20240427 version of the API.
|
| 03/27/2024 | 8852 | Workday | Deprecated
- The APIURL connection property for SOAP.
Replacements
- If the APIURL points to the base of the SOAP API (https://impl.workday.com/ccx/service/mytenant), set the Tenant and BaseURL to access all SOAP services.
- Otherwise, if the APIURL points to a specific SOAP service (https://impl.workday.com/ccx/service/mytenant/Human_Resources), set the Tenant, BaseURL, and Service to restrict what services are available on the connection.
|
| 03/15/2024 | 8840 | General | Added
- Created a new SQL function called STRING_COMPARE that provides java's String.compare() ability to SQL queries. Returns a number representative of the compared value of two strings
|
| 02/27/2024 | 8823 | Workday | Added
- Added support for the SingleEntryTables property. This property can be used to change how the driver handles collection tables in the SOAP API. Please refer to the documentation of the property for more information and examples.
|
| 02/16/2024 | 8812 | Workday | Added
- Added support for general REST stored procedures. Before the only stored procedures were BeginXXXChange and SubmitXXXChange for managing bulk changes. Now every REST endpoint that accepts POST and is not associated with an existing table is available as its own stored procedure.
|
| 01/03/2024 | 8768 | Workday | Added
- Added support for SupportNativeDataType. Java-based editions can enable this property with ConnectionType=WQL to see native WQL type names in column metadata.
|
| 11/29/2023 | 8733 | General | Changed
- The ROUND function doesn't accept the negative precision values anymore.
Changed
- The returning types of the FDMonth, FDQuarter, FDWeek, LDMonth, LDQuarter, LDWeek functions are changed from Timestamp to Date.
- The return type of the ABS function will be consistent with the parameter value type.
|
| 11/28/2023 | 8732 | General | Added
- Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 11/28/2023 | 8732 | Workday | Added
- Updated REST API schemas to the 20231111 version of the API, with the following updates for specific components.
- Person API: Move from v3 to v4
- Staffing API: Move from v5 to v6
|
| 10/04/2023 | 8677 | Workday | Added
- Added support for REST change processes: Organization Assignment Changes, Job Changes, Work Contact Information Changes, and Home Contact Information Changes. Each of these change processes has Begin/Submit stored procedures as well as associated tables for changing the process's inputs.
- Added support for navigating hierarchical categories within REST values tables. These tables now expose a collection token which can be used to read the subcategories of the current category.
|
| 09/13/2023 | 8656 | Workday | Added
- Added the WQLDataSourceFilters property. This allows overriding the driver's choice of data source filter for WQL views.
|
| 08/29/2023 | 8641 | Python | Added
- Added support for SQLAlchemy 2.0.
|
| 08/22/2023 | 8634 | Workday | Changed
- Updated REST API schemas to the 20230819 version of the API, with the following updates for specific components.
- Person API: Move from v2 to v3
- Staffing API: Move from v4 to v5
- Updated the DataSourcesFields API to support multiple optional and required parameters. Earlier definitions of this table reported flattened optional and require parameters fields, while in current versions they are aggregates.
|
| 07/27/2023 | 8608 | Workday | Added
- Added the SplitSingleValuePrompts property for all connection types. This allows the driver to split queries that provide multiple values for single value prompts. Each combination of split prompt values is executed separately and combined within the driver.
|
| 07/10/2023 | 8591 | Workday | Added
- Added the IncludeIDInDescriptor property for WQL. When enabled, the driver will report descriptor columns as containing the description and the ID, instead of just the ID.
Changed
- WQL descriptors are reported as combined ID and description values, as per the IncludeIDInDescriptor property.
|
| 07/07/2023 | 8588 | Workday | Added
- Added support for reporting more child tables when the parent table is an inner collection, like StudentGradingSchemes_Student_Grade_Data.
- Added the IncludeChildTableAggregates property to control whether child tables appear only as child tables, or as child tables and aggregates on their parent table. By default aggregates are exposed in addition to child tables.
|
| 07/05/2023 | 8586 | Workday | Added
- Added the BaseURL property. This has the same function as the Host property.
Deprecated
- The Host property. Existing connections using it will still work, but new connections should use the BaseURL property instead.
|
| 06/29/2023 | 8580 | Workday | Added
- Added support for the REST API.
Removed
- The UseWQL connection property.
Replacements
- The ConnectionType connection property replaces the UseWQL property. Each service (WQL, Reports, REST, SOAP) has its own ConnectionType and only one can be used per connection. This means that WQL and RaaS can no longer be used together as separate schemas on the same connection.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 05/19/2023 | 8539 | Python | Added
- Added support for Python 3.11 on Windows, Linux and Mac.
|
| 05/16/2023 | 8536 | Python | Removed
- Removed support for Python 3.7 on Windows and Linux
|
| 05/12/2023 | 8532 | Workday | Added
- Added support for simple SOAP filter criteria. These are given using _Prompt columns as in WQL and RaaS.
|
| 05/09/2023 | 8529 | Workday | Added
- Added support for AzureAD authentication.
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 02/07/2023 | 8438 | Workday | Added
- Added support for OAuth JWT authentication, and enhanced the documentation around the process of creating ISUs and configuring their authentication. The driver supports both OAuthJWT for ISUs using a normal API Client as well as OAuth with an API Client for Integrations.
- Added support for OAuth authentication (both authorization code and JWT) to SOAP. SOAP now supports every authentication method that WQL/RaaS do as well as Basic authentication. Basic authentication remains the default for SOAP.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 12/05/2022 | 8374 | Workday | Added
- Added support for ExpandMultiValues. When enabled, multi-instance ID values are expanded into multiple rows so that individual IDs can be read without parsing JSON or XML aggregates. This also applies to single-instance ID values when using Reports as a Service without ExpandIDTypes.
|
| 11/15/2022 | 8354 | Python | Changed
- Updated embedded JRE to jre8u345-b01(Linux x64 / MacOS x64) and jre-17.0.5+8(MacOS aarch64).
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 08/31/2022 | 8278 | Workday | Added
- Added support for ExpandIDTypes. When enabled, ID values in reports are reported as multiple columns (one per ID type) instead of one XML aggregate column.
|
| 08/03/2022 | 8250 | Workday | Added
- Improved performance around WQL metadata fetching. The driver can fetch table and field listings in parallel which is significantly faster for larger data sources like workers.
- Added support for WQL prompts and data source filters. Prompt support works the same way as reports. Data source filters currently have limited support, they are only used when required and the driver will automatically pick one to use.
|
| 05/18/2022 | 8173 | Python | Added
- Added support for Python 3.10 on Windows, Linux, and Mac
- Added support for Python 3.9 on Mac
- Added support for Mac M1
Removed
- Removed support for Python 3.6 on Windows and Linux
|
| 05/17/2022 | 8172 | Workday | Added
- Added support for accessing Reports as a Service (RaaS). RaaS reports can be queried by setting the UseWQL connection property to true (default), and providing the driver with a report that lists out all RaaS-accessible reports via the CustomReportURL connection property. The driver has support for setting prompt values as well as flattening complex report values.
|
| 05/03/2022 | 8158 | Workday | Added
- Added support for the WQL API. The WQL API is newer than the SOAP API from Workday, and has far better support for metadata, limiting service results, filtering, and server side operations such as aggregation and grouping.
Changed
- Changed the default API from SOAP to WQL. This can be configured via the UseWQL connection property.
|
| 09/21/2021 | 7934 | Workday | Changed
- Changed the default primary key column for the Learning.LearningLessons table. Removed the Learning_Lesson_Reference_WID column as it does not appear to actually come back.
|
| 09/10/2021 | 7923 | Workday | Changed
- Changed the default primary key column for the Learning.LearningPrograms and LearningPrograms child tables. Removed the Learning_Program_Reference_WID column as it does not appear to actually come back.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 08/27/2021 | 7909 | Workday | Changed
- Changed the default primary key column for the Learning.LearningDigitalCourses and LearningDigitalCourses child tables. Removed the Learning_Digital_Course_Reference_WID column as it does not appear to actually come back.
|
| 08/07/2021 | 7889 | General | Changed
- Added the KeySeq column to the sys_foreignkeys table.
|
| 08/06/2021 | 7888 | General | Changed
- Added the new sys_primarykeys system table.
|
| 07/23/2021 | 7874 | General | Changed
- Updated the Literal Function Names for relative date/datetime functions. Previously, relative date/datetime functions resolved to a different value when used in the projection as opposed to the predicate. For example: SELECT LAST_MONTH() AS lm, Col FROM Table WHERE Col > LAST_MONTH(). Formerly, the two LAST_MONTH() methods would resolve to different datetimes. Now, they will match.
- As a replacement for the previous behavior, the relative date/datetime functions in the criteria may have an 'L' appended to them. For example: WHERE col > L_LAST_MONTH(). This will continue to resolve to the same values that were previously calculated in the criteria. Note that the "L_" prefix will only work in the predicate - it not available for the projection.
|
| 05/26/2021 | 7816 | Workday | Changed
- The default WSDLVersion has been updated to v36.1.
|
| 04/23/2021 | 7783 | General | Changed
- Updated how display sizes are determined for varchar primary key and foreign key columns so they will match the reported length of the column.
|
| 04/16/2021 | 7776 | General | Changed
- Reduced the length to 255 for varchar primary key and foreign key columns.
Changed
- Updated index naming convention to avoid duplicates.
|
| 04/16/2021 | 7776 | General | Changed
- Updated implicit and metadata caching to improve performance and support for multiple connections. Old metadata caches are not compatible - you need to generate new metadata caches if you are currently using CacheMetadata.
|
| 03/02/2021 | 7731 | Workday | Changed
- Made a significant performance improvement. Retrieval for multiple pages of data is now ~4-5x faster.
|