ODBC Driver for SAP SuccessFactors

Build 24.0.9062

変更履歴

General Changes

DateBuild
Number
Change
Type
Description
10/21/20249060SAP SuccessFactorsAdded
  • Added a connection property: UserType. This is valid only when using LMS microservices.
  • The allowed values are Auto (Default), Admin, and User. Auto keeps the existing behavior. Admin is the value used when the user authenticates with an admin role account. User is the value used when the user authenticates with a user role account.
09/17/20249026SAP SuccessFactorsAdded
  • One column (ColumnType) is added to the sys_tablecolumns table. The column indicates whether the field is a standard column (SYSTEM), a navigation property (LINKEDCOLUMN), a navigation key (NAVIGATIONKEY), a reference column (REFERENCECOLUMN), or a navigation parent key (NAVIGATIONPARENTCOLUMN).
06/13/20248930SAP SuccessFactorsAdded
  • Added the UseEffectiveDate connection property.
06/08/20248925SAP SuccessFactorsRemoved
  • Removed the Auto AuthScheme option. The default value for the AuthScheme connection property is now Basic.
05/25/20248911SAP SuccessFactorsChanged
  • The default value for the AuthScheme connection property has changed to OAuthSAML2.
  • Hid the connection properties IncludeDerivedColumns, IncludeLinkedColumns, IncludeNavigationKeys, and IncludeNavigationParentColumns. These properties are no longer listed by default.
05/09/20248895GeneralChanged
  • The ROUND function previously did not accept negative precision values. That feature has now been restored.
03/15/20248840GeneralAdded
  • 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
11/29/20238733GeneralChanged
  • 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/20238732GeneralAdded
  • Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
10/24/20238697SAP SuccessFactorsChanged
  • The default value for the hidden connection property IncludeReferenceColumn has changed to false and the ParentReference columns are no longer listed by default.
10/19/20238692SAP SuccessFactorsAdded
  • Added the UsePicklistDisplayNames connection property. If set to true, the labels that are configured for the picklist options are pushed in a separate column.
09/26/20238669SAP SuccessFactorsAdded
  • Added support for AuthScheme=AzureAD with Single Sign-On (SSO).
09/01/20238644SAP SuccessFactorsAdded
  • Added IsUpsertable, IsCreatable, and IsDeletable information on the sys_tables table.
06/20/20238571GeneralAdded
  • Added the new sys_lastresultinfo system table.
06/09/20238560SAP SuccessFactorsRemoved
  • The IncludeNavigationProperties connection property has been removed.
04/25/20238515GeneralRemoved
  • Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
12/14/20228383GeneralChanged
  • Added the Default column to the sys_procedureparameters table.
11/11/20228350ODBCChanged
  • Updated embedded JRE to jre8u345-b01 (Linux x64 / MacOS x64) and jre-17.0.5+8 (MacOS aarch64).
09/30/20228308GeneralChanged
  • Added the IsPath column to the sys_procedureparameters table.
05/17/20228172ODBCChanged
  • Updated VC++ redistributable Libraries to Microsoft Visual C++ 2015-2022 Redistributable 14.32
05/17/20228172SAP SuccessFactorsRemoved
  • The OAuthGrantType connection property has been removed.

Replacements
  • There are two new AuthScheme options that will be used as replacements for OAuthGrantType. OAuthClient replaces OAuthGrantType=CLIENT while OAuthSAML2 replaces OAuthGrantType=SAML.
04/27/20228152ODBCChanged
  • The installer now installs .NET 4.0 instead of .NET 2.0 during default installation when both are present.
04/11/20228136SAP SuccessFactorsAdded
  • Added support for the PrivateKeyType connection property.
12/22/20218026ODBCAdded
  • Added support for transactions.
09/02/20217915GeneralAdded
  • Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
08/07/20217889GeneralChanged
  • Added the KeySeq column to the sys_foreignkeys table.
08/06/20217888GeneralChanged
  • Added the new sys_primarykeys system table.
07/29/20217880ODBCAdded
  • Added support for the Array data type for the input parameters in stored procedures.
07/23/20217874GeneralChanged
  • 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/29/20217819ODBCAdded
  • Exposed the InitiateOAuth connection property.
05/26/20217816ODBCAdded
  • Added support for the JAVA_HOME setting in the configuration file.
04/29/20217789ODBCAdded
  • Added the SqlMaxColumnNameLen connection property.
04/25/20217785GeneralAdded
  • Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
04/23/20217783GeneralChanged
  • 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/20217776GeneralAdded
  • Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
04/16/20217776GeneralChanged
  • Reduced the length to 255 for varchar primary key and foreign key columns.

Changed
  • Updated index naming convention to avoid duplicates.
04/16/20217776GeneralChanged
  • 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.
04/16/20217776ODBCChanged
  • ODBC Drivers on Linux and Mac now depend on the JRE, which brings improved stability and performance.
11/19/20207628SAP SuccessFactorsAdded
  • Added CreateAssociation, ListAssociations, RemoveAssociation, and ListNavigationProperties stored procedures.
  • Added the IncludeNavigationProperties connection property. Setting IncludeNavigationProperties=true is required when working with the above stored procedures.
11/18/20207627SAP SuccessFactorsAdded
  • Added support for UPSERT and Batch UPSERT operation.

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