| |
| Date | Build
Number | Change
Type | Description |
| 09/27/2024 | 9036 | Salesforce Marketing Cloud Account Engagement | Added
- 新しい接続プロパティServerTimeZone が追加されました。このプロパティは、 認証されたユーザーのタイムゾーンに基づいてdatetime 値をパースして表示するために使用されます。デフォルト値はAUTO ですが、IANA 形式で特定のタイムゾーンに設定することが可能です。
|
| 08/12/2024 | 8990 | Salesforce Marketing Cloud Account Engagement | Added
- V3 およびV4 スキーマのEmails ビューにHTMLContent カラムが追加されました。
|
| 05/23/2024 | 8909 | Salesforce Marketing Cloud Account Engagement | Removed
- V5 スキーマのFormHandlersFields テーブルから、"UpdatedAt" および"UpdatedById" カラムが削除されました。
|
| 05/13/2024 | 8899 | Salesforce Marketing Cloud Account Engagement | Added
- EngagementStudioProgram ビューが追加されました。EngagementStudioProgram にクエリを実行すると、プログラムに関連するデータを取得できます。
- CreateStudioProgram ストアドプロシージャが追加されました。このストアドプロシージャを実行すると、Engagement Studio プログラムが作成されます。名前と、Base64Data で指定されるかFilePath/FileStream から読み込まれるEngagement Studio のプログラム構造が必要です。
- DownloadStudioProgram ストアドプロシージャが追加されました。このストアドプロシージャを実行すると、指定されたEngagement Studio のプログラム構造がダウンロードされます。Engagement Studio プログラムのId が必要です。
|
| 05/09/2024 | 8895 | General | Changed
- 以前はROUND 関数は負の値を受け取りませんでした。その機能は復元されました。
|
| 03/15/2024 | 8840 | General | Added
- Java のString.compare() 機能をSQL クエリに提供するSTRING_COMPARE という新しいSQL 関数が作成されました。2つの文字列の比較値を表す数値を返します。
|
| 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, 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.
|
| 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/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.
|
| 10/12/2022 | 8320 | Tableau | Added
- Added support for additional localizations in the Windows and Mac packages. Both setups now support all the languages that Tableau supports as of their 2022.2 release.
|
| 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.
|
| 08/12/2022 | 8259 | Tableau | Changed
- Updated connection dialogs to use advanced configuration information provided by drivers. This makes use of the same information as the new dialogs in other editions (like ODBC) to display only the most relevant connection properties.
- Legacy connectors have been simplified to look more like Tableau JDBC dialogs. Legacy connectors target older Tableau versions which do not support rich connection dialogs like the modern connectors do. Most connectors cannot fit within these limitations.
|
| 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 | Tableau | Changed
- Improved the connection dialog configuration experience.
|