| |
| Date | Build
Number | Change
Type | Description
|
| 05/23/2024 | 8909 | Salesforce Marketing Cloud Account Engagement | Removed
- Removed the "UpdatedAt" and "UpdatedById" columns from the FormHandlersFields table in the V5 Schema.
|
| 05/13/2024 | 8899 | Salesforce Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | Added
- Added the hidden connection property IgnoreColumnDataType, by specifing a delimited list Tablename=Columname; the datatype reported by the API will be ignored for the specified fields.
|
| 09/07/2023 | 8650 | Salesforce Marketing Cloud Account Engagement | Added
- Added the ValueDelimiter connection property to define the delimiter used for multi-select fields values.
|
| 08/02/2023 | 8614 | Salesforce Marketing Cloud Account Engagement | Removed
- Removed the Name field from ReplyToOptions view.
|
| 06/29/2023 | 8580 | PowerShell Cmdlets | Removed
- Removed support for .NET 2.0
|
| 06/20/2023 | 8571 | General | Added
- Added the new sys_lastresultinfo system table.
|
| 05/29/2023 | 8549 | Salesforce Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | Added
- Added the SalesforceId column to the Campaigns view of the SalesforcePardotV5 schema.
|
| 01/23/2023 | 8423 | Salesforce Marketing Cloud Account Engagement | Added
- Added support for ListEmailRecipients view.
|
| 01/12/2023 | 8412 | Salesforce Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | Added
- Added the tables DynamicContent, DynamicContentVariations, FormHandlers,FormHandlerFields,LandingPages,LifecycleStages,ListMemberships,Opportunities to the SalesforcePardotV5 schema.
|
| 05/19/2022 | 8174 | Salesforce Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | Added
- Added the SenderOptions and ReplyToOptions tables.
|
| 04/08/2022 | 8133 | Salesforce Marketing Cloud Account Engagement | Added
- Added support for creating, updating, deleting Prospects in the SalesforcePardotV5 schema.
|
| 02/23/2022 | 8089 | Salesforce Marketing Cloud Account Engagement | Added
- Added the tables Emails, EmailTemplates, ListEmail to the SalesforcePardotV5 schema.
|
| 02/15/2022 | 8081 | Salesforce Marketing Cloud Account Engagement | Changed
- Changed the ResponseMode connection property default value to "simple".
|
| 01/17/2022 | 8052 | Salesforce Marketing Cloud Account Engagement | Added
- Added support for connecting with the driver's embedded credentials.
|
| 01/11/2022 | 8046 | Salesforce Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | 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 Marketing Cloud Account Engagement | 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.
|
| 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.
|
| 06/25/2021 | 7846 | Salesforce Marketing Cloud Account Engagement | Added
- Added support for OAuthJWT via Salesforce.
|
| 06/17/2021 | 7838 | Salesforce Marketing Cloud Account Engagement | 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.
|
| 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.
|
| 04/16/2021 | 7776 | PowerShell Cmdlets | Added
- Added support for PowerShell 7.
|