| Date | Build
Number | Change
Type | Description |
| 09/27/2024 | 9036 | Salesforce Pardot | Added
- Added a new connection property, ServerTimeZone. This property is used to parse and display datetime values based on the authenticated user's timezone. Its default value is AUTO but can be set to a specific timezone in IANA format.
|
| 08/12/2024 | 8990 | Salesforce Pardot | Added
- Added the HTMLContent column to the Emails view in the V3 & V4 schemas.
|
| 05/23/2024 | 8909 | Salesforce Pardot | Removed
- Removed the "UpdatedAt" and "UpdatedById" columns from the FormHandlersFields table in the V5 Schema.
|
| 05/13/2024 | 8899 | Salesforce Pardot | Added
- Added the EngagementStudioProgram view. Query EngagementStudioProgram to retrieve data related to the programs.
- Added the CreateStudioProgram stored procedure. Executing this stored procedure will create an engagement studio program. Name and the engagement studio program structure which can be specified in the Base64Data or read from FilePath/FileStream are required.
- Added the DownloadStudioProgram stored procedure. Executing this stored procedure will download the specified engagement studio program structure. Id of the engagement studio program is required.
|
| 05/09/2024 | 8895 | General | Changed
- The ROUND function previously did not accept negative precision values. That feature has now been restored.
|
| 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
|
| 01/29/2024 | 8794 | Salesforce Pardot | Added
- Added FolderContents view.
- Added AddBatchToImport, CreateBulkAction, CreateExport, CreateImport, DownloadExport, ReadBulkAction, ReadBulkActionErrors, ReadExport, ReadImport, ReadImportErrors, UpdateImportStatus stored procedures.
- Added support for bulk UPDATE / UPSERT / INSERT / DELETE.
- Added 3 connection properties to control bulk behavior: BulkMode, ImportBatchSize, BulkActionsBatchSize.
|
| 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/23/2023 | 8727 | Salesforce Pardot | Added
- Added the hidden connection property IgnoreColumnDataType, which exposes the specified columns as strings instead of their usual datatype. Provide a list of columns as a semicolon-separated list of tables, each containing a comma-separated lists of columns. For example: Table1=Col1,Col2;Table2=Col3,Col4;. This property only affects custom fields in the SalesforcePardotV3 and SalesforcePardotV4 schemas.
|
| 11/09/2023 | 8713 | cis | Changed
- Salesforce with SSO Adapter reports the Double type as Doule type instead of Decimial type
- Salesforce with SSO Adapter supports create a table with Clob type column. The Clob type is mapped to Salesforce LongTextArea field.
|
| 09/07/2023 | 8650 | Salesforce Pardot | Added
- Added the ValueDelimiter connection property to define the delimiter used for multi-select fields values.
|
| 08/02/2023 | 8614 | Salesforce Pardot | Removed
- Removed the Name field from ReplyToOptions view.
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 05/29/2023 | 8549 | Salesforce Pardot | Changed
- The default value for the Schema coonection property has been updated to "SalesforcePardotV5".
|
| 04/25/2023 | 8515 | General | Removed
- Removed support for the SELECT INTO CSV statement. The core code doesn't support it anymore.
|
| 02/28/2023 | 8459 | Salesforce Pardot | Changed
- The Name and CampaignId field for ListEmailRecipients and EmailSuppressionList changed to ListEmailName and ListEmailCampaignId. They reference the name and campaignId of the ListEmail.
Added
- Added a new Name field for ListEmailRecipients and EmailSuppressionList referencing the name of the ListEmailRecipients or EmailSuppressionList
|
| 01/31/2023 | 8431 | Salesforce Pardot | Added
- Added the SalesforceId column to the Campaigns view of the SalesforcePardotV5 schema.
|
| 01/23/2023 | 8423 | Salesforce Pardot | Added
- Added support for ListEmailRecipients view.
|
| 01/12/2023 | 8412 | Salesforce Pardot | Changed
- Datatype for all primary keys and foreign keys is now changed across the board from int to int64. Changes affect all schemas,tables and views.
|
| 12/14/2022 | 8383 | General | Changed
- Added the Default column to the sys_procedureparameters table.
|
| 10/27/2022 | 8335 | Salesforce Pardot | Added
- Added the tables Account, LifecycleHistories to the SalesforcePardotV5 schema.
|
| 09/30/2022 | 8308 | General | Changed
- Added the IsPath column to the sys_procedureparameters table.
|
| 09/07/2022 | 8285 | Salesforce Pardot | Added
- Added the tables DynamicContent, DynamicContentVariations, FormHandlers,FormHandlerFields,LandingPages,LifecycleStages,ListMemberships,Opportunities to the SalesforcePardotV5 schema.
|
| 05/19/2022 | 8174 | Salesforce Pardot | Deprecated
- The OAuthGrantType connection property has been deprecated.
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.
|
| 04/15/2022 | 8140 | Salesforce Pardot | Added
- Added the SenderOptions and ReplyToOptions tables.
|
| 04/08/2022 | 8133 | Salesforce Pardot | Added
- Added support for creating, updating, deleting Prospects in the SalesforcePardotV5 schema.
|
| 02/23/2022 | 8089 | Salesforce Pardot | Added
- Added the tables Emails, EmailTemplates, ListEmail to the SalesforcePardotV5 schema.
|
| 02/15/2022 | 8081 | Salesforce Pardot | Changed
- Changed the ResponseMode connection property default value to "simple".
|
| 01/17/2022 | 8052 | Salesforce Pardot | Added
- Added support for connecting with the driver's embedded credentials.
|
| 01/11/2022 | 8046 | Salesforce Pardot | Added
- Added support for the new Salesforce Pardot V5 API. Set the Schema connection property to SalesforcePardotV5 to switch to using this API.
|
| 12/22/2021 | 8026 | Salesforce Pardot | Removed
- Removed the ApiVersion connection property as it is no longer supported by the driver. To switch between versions, use the Schema connection property.
|
| 10/07/2021 | 7950 | Salesforce Pardot | Added
- Added support for the VisitorsPageViews view.
|
| 09/02/2021 | 7915 | General | Added
- Added support for the STRING_SPLIT table-valued function in the CROSS APPLY clause.
|
| 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.
|
| 06/25/2021 | 7846 | Salesforce Pardot | Added
- Added support for OAuthJWT via Salesforce.
|
| 06/17/2021 | 7838 | Salesforce Pardot | Removed
- Removed Basic Authentication with an API Key as a possible method to authenticate. It is no longer supported by Pardot.
|
| 04/25/2021 | 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%'
|
| 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 | Added
- Non-conditional updates between two columns is now available to all drivers. For example: UPDATE Table SET Col1=Col2
|
| 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.
|