| |
| Date | Build
Number | Change
Type | Description |
| 09/10/2024 | 9019 | Workday | Changed
- WSDLVersion 接続プロパティのSOAP API バージョンのデフォルトがv42.2に更新されました。
- API バージョン20240907 に対応するため、REST API スキーマが更新されました。
Added
- REST スキーマに複数のテーブルとビューが追加されました。
|
| 08/29/2024 | 9007 | Workday | Removed
- AuthScheme=Auto 設定のサポートが削除されました。デフォルトのAuthScheme は現在OAuth に設定されています。SOAP を使用する場合、従来の動作を維持するためにAuthScheme=Basic を設定します。その他のサービスについては変更の必要はありません。
|
| 08/05/2024 | 8983 | Workday | Added
- 新規ストアドプロシージャ、CreateWQLSchema が追加され、Workday の特定のWQL を実行するテーブルをドライバーに作成できるようになりました。この新しいストアドプロシージャをWorkday Convert Report to WQL タスクで使用すると、レポートと同じデータを、Reports サービスよりも優れたパフォーマンスで取得できます。
|
| 07/23/2024 | 8970 | Workday | Added
- 新しいAs_Of_Effective_Date_RespFilter プロンプトカラムを使用する、SOAP API での有効日設定のサポートが追加されました。
|
| 06/28/2024 | 8945 | Workday | Added
- 接続プロパティIncludeRESTTenantFields が追加され、ドライバーがテナント固有のスキーマをフェッチして共有スキーマにマージできるようになりました。これにより、Workday のテナントに固有の追加フィールドが公開されます。API の制限により、共有スキーマとのテナント固有のスキーマのマージは、トップレベルのテーブルとその子テーブルに対してのみサポートされることに注意してください。スキーマにアクセスするために所有者ID を必要とするテーブルではサポートされていません。
|
| 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.
|
| 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
- 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
|
| 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
- Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
|
| 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.
|
| 12/31/2023 | 8765 | Excel | Added
- Added support for dialect SELECT queries in UI, VBA, and UDF =CDATAQUERY function.
|
| 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/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/12/2023 | 8532 | Workday | Added
- Added support for simple SOAP filter criteria. These are given using _Prompt columns as in WQL and RaaS.
|
| 05/10/2023 | 8530 | Excel | Added
- Added the ability to cancel an in-progress test connection in the Connection Dialog Box.
|
| 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.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 09/28/2022 | 8306 | Excel | Added
- Added a config file option STATUSBAR_UPDATE=TRUE. This indicates whether the Excel Add-In will update the Excel Status Bar with progress status on completed tasks. The default value is TRUE. This way, there is the option to NOT update the Status Bar by setting it to FALSE.
|
| 09/14/2022 | 8292 | Excel | Changed
- Improved the User Experience of the Connection Editor by introducing a Basic tab for the most imporant connection properties.
|
| 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/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.
|
| 03/17/2022 | 8111 | Excel | Changed
- Changed the behavior so that auto-refreshing continues even if the worksheet is not active anymore or loses focus.
|
| 03/05/2022 | 8099 | Excel | Added
- Added support for inserting rows on tables when no primary key is defined on a given table.
|
| 02/19/2022 | 8085 | Excel | Added
- The button "Get Data -> From ProviderX" now displays a submenu with existing connections buttons and a separator, with the "New ProviderX Connection" button, if a connection exists. If no connections exist, then clicking "Get Data -> From ProviderX" will prompt the user to create a new connection before selecting the data.
Removed
- In the "Table Selection" form, the "Source", "New Connection", "Connection", and "Edit Connection" fields are removed as they are out of the scope of the "Table Selection" form.
|
| 12/31/2021 | 8035 | Excel | Added
- Added batch support for CDATAINSERT, CDATAUPDATE, and CDATADELETE user-defined functions.
|
| 11/11/2021 | 7985 | Excel | Added
- Added a config file option called RETRIEVE_DATA_ROWS_PERCOUNT. When getting data, this indicates how many rows will be populated into the sheet at a time. The default value is 1000.
Changed
- Improved performance when loading data from Get Data/Refresh and the CDATAQUERY function.
|
| 11/03/2021 | 7977 | Excel | Added
- Added new VBA functions: GetLastErrorCode and GetLastError.
|
| 10/29/2021 | 7972 | Excel | Added
- Added new VBA functions: GetUpSertedRows, UpSertRows, UpSertAll and UpSert.
Changed
- The "Update Rows" button will now update changes made to existing rows or insert newly created rows.
Removed
- The "Add Rows" button has been removed.
|
| 09/28/2021 | 7941 | Excel | Added
- When loading data, table columns are auto-fitted to display all cells' content. In cases when cells have large amounts of text and the table has many rows, this operation might be slow.
- Added a config file option DISABLE_AUTOFIT_COLUMN. Setting DISABLE_AUTOFIT_COLUMN==TRUE will speed up the process in those cases. The default value is FALSE.
Changed
- Changed the maximum characters that a cell can retreive from the data source from 8,192 to 32,767.
|
| 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/26/2021 | 7877 | Excel | Added
- You can sort and reorder columns on the "CData Query" form to alter the sort order.
|
| 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.
|
| 07/21/2021 | 7872 | Excel | Removed
- Removed support for .NET 3.5. Before upgrade/downgrade, a clean uninstall and then the same product versions install should be performed. So, if you want to downgrade, all the downgrade build versions must support .NET 3.5. If you want to upgrade, all the upgrade build versions will drop .NET 3.5 support.
|
| 07/06/2021 | 7857 | Excel | Added
- Added a config file option REPLACE_SYSTEM_LOCALE=TRUE. This indicates whether Office culture replaces system locale. The default value is TRUE. This way, there is the option to disable overriding system locale by setting it to FALSE.
|
| 06/26/2021 | 7847 | Excel | Added
- Added the ability to move the columns up and down on the "CData Query" form grid view and change their order via the UI.
|
| 06/24/2021 | 7845 | Excel | Added
- Added the default parameter "showPopups" so the user may decide whether to show popups when calling VBA functions.
|
| 05/26/2021 | 7816 | Workday | Changed
- The default WSDLVersion has been updated to v36.1.
|
| 05/21/2021 | 7811 | Excel | Added
- A new UI implementation is added for "in" and "not in" filter options on the "CData Query" form. The user is able to select via an interface from a list of distinct column values.
|
| 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.
|
| 03/02/2021 | 7731 | Workday | Changed
- Made a significant performance improvement. Retrieval for multiple pages of data is now ~4-5x faster.
|
| 12/30/2020 | 7669 | Excel | Added
- Implemented user awareness during the upgrade process from 2019 to 2020 or 2021 editions.
|
| 12/18/2020 | 7657 | Excel | Added
- Added the "is null" and "is not null" filters on the "CData Query" form.
|