| Date | Version | Source | Category | Type | Description |
| 2026-05-27 | 26.0.9643 | General | Connection | Removed | - Removed the deprecated ReplaceInvalidTypesWithNull connection property. Use the ReplaceInvalidValuesWithNull property instead.
|
| 2026-05-07 | 26.0.9623 | General | Data Model | Added | - Added the ColumnCapabilities column to the sys_tablecolumns system table. This column is a bit mask denoting the column's write capabilities.
|
| 2026-04-21 | 26.0.9607 | FinancialForce with SSO | Data Model | Added | - Added the ConvertLeads aggregate input to the ConvertLead stored procedure for batch lead conversions using a JSON array or temp table.
- Added the LinkedObjectId input to the UploadContentDocument stored procedure. If specified, this input links the uploaded file to a Salesforce object.
- The UploadAttachment, UploadDocument, UploadContentDocument, and ConvertLead stored procedures now return error details in the output when individual operations fail.
|
| 2026-04-21 | 26.0.9607 | FinancialForce with SSO | Data Model | Changed | - In the UploadAttachment stored procedure, renamed the AttachmentTempTable input to Attachments.
- In the UploadDocument stored procedure, renamed the DocumentTempTable input to Documents.
- In the UploadContentDocument stored procedure, renamed the ContentDocumentTempTable input to ContentDocuments.
|
| 2026-04-21 | 26.0.9607 | FinancialForce with SSO | Data Model | Removed | - The indexed parameter convention (for example, ObjectId#0, FileName#1) has been removed from stored procedures. Use a JSON aggregate or temp table input instead.
- Removed the LightningMode input from the UploadAttachment stored procedure. To upload an attachment in Lightning mode, use the UploadContentDocument stored procedure.
|
| 2026-04-15 | 26.0.9601 | General | Query Exec | Changed | - String comparisons using GREATER, LESS, and CONTAINS operators are now case-insensitive by default.
|
| 2026-01-13 | 25.0.9509 | General | | Added | - Added support for the REGEXP_REPLACE() string function.
|
| 2025-12-05 | 25.0.9470 | General | | Added | - Added support for the INSERT INTO SELECT statement, with driver-side execution for providers that do not support the operation natively.
|
| 2025-10-24 | 25.0.9428 | FinancialForce with SSO | | Changed | - Changed queries such as: SELECT TableA.a, TableB.a FROM TableA INNER JOIN TableB where multiple columns have the same name, so that the columns now retain the same name in the result set. They can be differentiated by using their positional index. We recommend setting aliases for the columns for differentiation at a glance.
|
| 2025-10-06 | 25.0.9410 | General | | Added | - Support for parsing datetime formats using ".S" and ",S" for milliseconds and nanoseconds.
|
| 2025-09-12 | 25.0.9386 | General | | Added | - Added the IsInsertable, IsUpdateable, and IsDeleteable columns to the sys_tables table.
|
| 2025-09-11 | 25.0.9385 | FinancialForce with SSO | | Added | - Added the following columns to sys_tablecolumns: IsTimeCheckColumn, CanOrderTimeCheckColumn, DefaultedOnCreate, and IsCalculated.
- Added a new output parameter, ErrorMessage, in the GetJobInfoV2 stored procedure.
- Added a new output parameter, PKCEVerifier, in both the GetOAuthAccessToken and GetAuthorizationUrl stored procedures.
- Added a new column, Error, to the JobRecordResultsV2 view.
- Added the following new connection properties:
- BulkQueryTimeout
- BulkUploadLimit
- IncludeItemURL
- NullBooleanBehaviour
- RemovePrivateChar
- ReportExactPicklistLength
- Added two new stored procedures: QueryParallelResultsV2 and GetBatchRecords.
|
| 2025-09-10 | 25.0.9384 | General | | Changed | - All columns in statically defined Views are now reported as read-only.
|
| 2025-09-03 | 25.0.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".
|
| 2025-09-01 | 25.0.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.
|
| 2025-08-21 | 25.0.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.
|
| 2025-08-15 | 25.0.9358 | FinancialForce with SSO | | Added | - Added the Scope connection property.
|
| 2025-08-13 | 25.0.9356 | General | | Changed | - Changed the maximum number of pages held in memory from 15 to 5 for the page providers to decrease heap usage.
|
| 2025-07-18 | 25.0.9330 | FinancialForce with SSO | | Removed | - Removed the OAuthGrantType property. The grant type is now set implicitly through the 'AuthScheme' property. For example, you can use the 'OAuthPassword' AuthScheme instead of AuthScheme=OAuth with OAuthGrantType=Password.
|
| 2025-06-25 | 25.0.9307 | General | | Removed | - Removed the "ADLS Gen 1" value from the ConnectionType property.
|
| 2025-06-20 | 25.0.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.
|
| 2025-06-18 | 25.0.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.
|
| 2025-05-27 | 25.0.9278 | General | | Removed | - Removed the "Proprietary" enum option from ProxyAuthscheme.
|
| 2025-02-15 | 24.0.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.
|
| 2024-12-12 | 24.0.9112 | FinancialForce with SSO | | Added | - Added the BulkAPIVersion connection property. This property controls the version of the Bulk API used by the driver. The default is v1.
- Added support for the Ingest API v2. To use this API, set BulkAPIVersion to v2.
|
| 2024-12-12 | 24.0.9112 | FinancialForce with SSO | | Changed | - The default version of the FinancialForce API used by the driver (set in the APIVersion connection property) has changed from 61.0 to 62.0.
|
| 2024-11-27 | 24.0.9097 | General | | Added | - Added ThreadId to LogModule output. Logfile lines now include the Thread ID associated with the action being performed.
|
| 2024-09-06 | 24.0.9015 | FinancialForce with SSO | | Changed | - Changed the default API version to 61.
|
| 2024-05-09 | 24.0.8895 | General | | Changed | - The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 2024-03-28 | 23.0.8853 | FinancialForce with SSO | | Added | - Added a new stored procedure, CreateCustomField, which enables the creation of new custom field components within an organization.
|
| 2024-03-20 | 23.0.8845 | FinancialForce with SSO | | Added | - Added two new stored procedures GetJobInfoV2 and QueryResultsV2.
|
| 2024-03-15 | 23.0.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
|
| 2024-02-29 | 23.0.8825 | FinancialForce with SSO | | Added | - FileStream input was added for the DownloadAttachment and DownloadDocument stored procedures, it can be used to download the content into an input stream.
- Content was added for UploadAttachment, UploadContentDocument and UploadDocument stored procedures, it can be used to upload the content from a stream.
|
| 2024-02-15 | 23.0.8811 | FinancialForce with SSO | | Added | - Added support for the 'QueryMode' input in the QueryBatch stored procedure. This feature enables users to execute either a SQL or SOQL query using this stored procedure.
|
| 2024-01-24 | 23.0.8789 | FinancialForce with SSO | | Added | - Added support for OAuthPKCE (Authorization Code Flow with Proof Key for Code Exchange).
- Added the IsUpdateable, IsCreateable columns in sys_tablecolumns table which indicate whether the fields can be edited/created.
- Added support for IncludeReports property, which indicates if salesforce reports should be exposed as views.
- Added support for IsReport column in sys_tables table which indicates if a view is a Salesforce report.
- Added the InLineHelpText column in sys_tablecolumns table which outputs the user-defined help text information for each of the fields.
- Added support for FileId, Success, and FailureMessage outputs in the download stored procedures. These outputs are helpful in showing the status of each download in multi-file downloads.
- Added support for the 'EmptyValueBehavior' hidden connection property which takes two values: 'ConvertEmptyStringsToNull' and 'IgnoreEmptyValue'. The property impacts CUD statements when UseBulkAPI = true.'ConvertEmptyStringsToNull' is the default behavior which updates/creates a field value to NULL if the user has specified an empty string or NULL value, while 'IgnoreEmptyValue' will consider empty string values and NULL as no change made to the field's value.
- Added support for RemoveBOMCharacter hidden connection property which if set to true, is used to remove the BOM character from the content.
- Added the IsQueryable column in sys_tables table which is useful to differentiate queryable objects when the ExposeNonQueryable connection property is set to true.
|
| 2024-01-24 | 23.0.8789 | FinancialForce with SSO | | Removed | - The 'CreateReportSchema' and 'GetCustomReport' stored procedures have been removed and cannot longer be used.
- Removed the ContentType input of the GetBatchResults stored procedure. The driver automatically resolves the content type.
- Removed the SOQL input of the CreateSchema stored procedure. Instead, for running SOQL queries directly, the QueryPassthrough connection property should be set to true.
|
| 2024-01-24 | 23.0.8789 | FinancialForce with SSO | | Replacements | - We have changed and improved support for querying Salesforce reports. The 'CreateReportSchema' and 'GetCustomReport' stored procedures have been removed and cannot longer be used. To query Salesforce reports set the IncludeReports property to true and query the reports as normal tables. The new feature supports additional report types such as SUMMARY, MATRIX reports.
|
| 2024-01-24 | 23.0.8789 | FinancialForce with SSO | | Changed | - Changed the default Salesforce API Version to 58.
- The BulkPageSize connection property has been marked as hidden. To continue using this property, you should append it to the Other connection property
|
| 2024-01-22 | 23.0.8787 | FinancialForce with SSO | | Added | - Added the 'QueryBatchId' and 'QueryJobId' outputs in the QueryBatch stored procedure.
|
| 2024-01-22 | 23.0.8787 | FinancialForce with SSO | | Removed | - The 'Id' output corresponding to the batch ID in the QueryBatch stored procedure has been removed. To get the id of the batch use the new 'QueryBatchId' output instead.
- Removed the SOQL input of the CreateSchema stored procedure. Instead, for running SOQL queries directly, the QueryPassthrough connection property should be set to true.
- Removed the ContentType input of the GetBatchResults stored procedure. The driver automatically resolves the content type.
|
| 2023-11-29 | 23.0.8733 | General | | Changed | - The ROUND function doesn't accept the negative precision values anymore.
|
| 2023-11-29 | 23.0.8733 | General | | 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.
|
| 2023-11-28 | 23.0.8732 | General | | Added | - Added the HMACSHA256 formatter to allow for secrets to be decoded if it is in base64 format
|
| 2023-11-09 | 23.0.8713 | cis | | Changed | - Salesforce with SSO Adapter reports the Double type as Doule type instead of Decimal type
- Salesforce with SSO Adapter supports create a table with Clob type column. The Clob type is mapped to Salesforce LongTextArea field.
|
| 2023-06-20 | 23.0.8571 | General | | Added | - Added the new sys_lastresultinfo system table.
|
| 2023-04-25 | 23.0.8515 | General | | Removed | - Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 2022-12-14 | 22.0.8383 | General | | Changed | - Added the Default column to the sys_procedureparameters table.
|
| 2022-12-09 | 22.0.8378 | FinancialForce with SSO | | Removed | - Removed the OutputFolder parameter for the CreateReportSchema stored procedure. The Location connection property must be used to set the output directory for writing schemas to a file.
|
| 2022-12-09 | 22.0.8378 | FinancialForce with SSO | | Added | - Added the WriteToFile parameter for the CreateReportSchema and CreateSchema stored procedures. It defaults to true and specifies whether to write the contents of the generated schema to a file or not. Set it to false to write the schema to FileStream or FileData.
|
| 2022-09-30 | 22.0.8308 | General | | Changed | - Added the IsPath column to the sys_procedureparameters table.
|
| 2022-05-19 | 22.0.8174 | FinancialForce with SSO | | Deprecated | - The OAuthGrantType connection property has been deprecated.
|
| 2022-05-19 | 22.0.8174 | FinancialForce with SSO | | Replacements | - The AuthScheme connection property will be used as a replacement for OAuthGrantType. Its new option OAuthPassword replaces OAuthGrantType=PASSWORD while OAuth replaces OAuthGrantType=CODE.
|
| 2021-09-02 | 21.0.7915 | General | | Added | - Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 2021-08-07 | 21.0.7889 | General | | Changed | - Added the KeySeq column to the sys_foreignkeys table.
|
| 2021-08-06 | 21.0.7888 | General | | Changed | - Added the new sys_primarykeys system table.
|
| 2021-04-25 | 21.0.7785 | General | | Added | - Added support for handling client side formulas during insert / update. For example: UPDATE Table SET Col1 = CONCAT(Col1, " - ", Col2) WHERE Col2 LIKE 'A%'
|
| 2021-04-23 | 21.0.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.
|
| 2021-04-16 | 21.0.7776 | General | | Added | - Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 2021-04-16 | 21.0.7776 | General | | Changed | - Reduced the length to 255 for varchar primary key and foreign key columns.
|
| 2021-04-16 | 21.0.7776 | General | | Changed | - Updated index naming convention to avoid duplicates.
|
| 2021-04-13 | 21.0.7773 | FinancialForce with SSO | | Changed | - The OneLogin method we used previously has been deprecated by OneLogin. We have updated our design to use the latest version of the OneLogin API, which now requires a separate OAuthClientId and OAuthClientSecret associated with your OneLogin app to be passed in through SSOProperties. The APIKey that was formerly passed in through SSOProperties for OneLogin is removed.
- OneLogin also no longer uses SSOLoginURL. Instead, Subdomain and AppId should be specified inside the SSOProperties.
|
| 2021-03-31 | 21.0.7760 | FinancialForce with SSO | | Deprecated | - IdpURL, AppEmbedLink, OktaAppEmbedLink, OktaDomain, IdpSystemPassword, SSOUser, SSOPassword, IdPPassword, IdpSystemUserName, IdpUser, OneLoginAPIKey, OktaApiToken, IdpSystemScheme, IdPSystemSSLClientCert, IdPSystemSSLClientCertType, IdPSystemSSLClientCertSubject, IdPSystemSSLClientCertPassword, and SSOTokenURL are deprecated.
|
| 2021-03-31 | 21.0.7760 | FinancialForce with SSO | | Replacements | - Deprecated the SSOTokenURL connection property. Instead SSOExchangeTokenURL should be used to specify the endpoint for exchanging SAML token with an oauth token.
- IdpURL is replaced by SSOLoginURL.
- The OktaDomain longer needs to be specified for any SSO connections as it can be extracted from SSOLoginURL.
- SSOLoginURL replaces OktaAppEmbedLink and AppEmbedLink as it is more generic and applicable to other SSO providers.
- SSOUser, SSOPassword, IdpUser, IdpPassword, IdpSystemUserName, IdpSystemPassword are replaced with the User / Password connection properties.
- OneLoginAPIKey and OktaApiToken are replaced by APIToken.
- IdPSystemSSLClientCert, IdPSystemSSLClientCertType, IdPSystemSSLClientCertSubject, IdPSystemSSLClientCertPassword are replaced with the standard SSL cert connection properties.
|