変更履歴：ドライバーアップデート 2024.14

2024.1 CData ドライバーリリースにおけるドライバー固有の変更点をご確認ください。

Date Entered: 11/20/2024    Last Updated: 11/20/2024

Download the CSV here: 2024-q4-driver-changelog.csv

Date Build Number Provider Change Type Description Breaking Change
10/21/2024 9060 ProviderSAPSuccessFactors Added
  • 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.
No
10/21/2024 9060 ProviderSlack Added
  • Added a Stored Procedure: GetTeamBillableInfo.
  • Added a Stored Procedure: SetReadCursor.
No
10/18/2024 9057 ProviderMonday Added
  • Added BoardDocs and BoardDocBlocks as Information tables.
No
10/18/2024 9057 ProviderOracleERP Added
  • Added a new property, rowscandepth, to support additional columns in the AccountCombinationsLOV view.
  • Added 3 new views, ValueSets, ValueSetsValues, and ValueSetsvalidationTable, to both the Financials and Procurement schemas.
No
10/18/2024 9057 ProviderSlack Added
  • Added two new stored procedures: RemoveProfilePhoto and SendEphemeralMessage.
  • Added the GetPermaLink stored procedure.
No
10/17/2024 9056 ProviderTrello Changed
  • CardAttachments, Boards, Lists, CardChecklists and Memberships have changed from views to tables.
  • In the Memberships table, the OrganizationID column is no longer treated as a primary key. To retrieve members of an organization, use the OrganizationMembers view.
Yes
10/17/2024 9056 ProviderTrello Changed
  • CardAttachments, Boards, Lists, CardChecklists and Memberships have changed from views to tables.
  • In the Memberships table, the OrganizationID column is no longer treated as a primary key. To retrieve members of an organization, use the OrganizationMembers view.
No
10/17/2024 9056 ProviderTrello Added
  • Added the CreateBoards and CreateLists stored procedures.
  • Added support for UPDATE queries to the Lists table.
  • Added support for DELETE queries to the CardAttachments, Boards, and Memberships tables.
  • Added support for INSERT and DELETE queries to the CardChecklists table.
  • Added the Description, Subscribed, DateLastActivity, CreationMethod, and EnterpriseOwned columns to the Boards table.
  • Added the Subscribed column to the Lists table.
  • Added the Name and Position columns to the CardChecklists table.
No
10/16/2024 9055 ProviderQBOnline Added
  • Added access to a standard QuickBooks Online report, BalanceSheetDetail.
No
10/15/2024 9054 ProviderAvro Replaced
  • In the ListFiles stored procedure, replaced the AbsolutePath input with the Path input. This path is relative to the path provided in the URI connection property.
Yes
10/15/2024 9054 ProviderCSV Replaced
  • In the ListFiles stored procedure, replaced the AbsolutePath input with the Path input. This path is relative to the path provided in the URI connection property.
Yes
10/15/2024 9054 ProviderJSON Replaced
  • In the ListFiles stored procedure, replaced the AbsolutePath input with the Path input. This path is relative to the path provided in the URI connection property.
Yes
10/15/2024 9054 ProviderParquet Replaced
  • In the ListFiles stored procedure, replaced the AbsolutePath input with the Path input. This path is relative to the path provided in the URI connection property.
Yes
10/15/2024 9054 ProviderSplunk Added
  • Added stored procedure: ReadJobResults.
No
10/15/2024 9054 ProviderXML Replaced
  • In the ListFiles stored procedure, replaced the AbsolutePath input with the Path input. This path is relative to the path provided in the URI connection property.
Yes
10/14/2024 9053 ProviderGoogleAds Added
  • Added a new view, ShoppingProduct.
No
10/14/2024 9053 ProviderGoogleAds Removed
  • In the AdGroup, Campaign, Custom, and KeywordView views, removed 6 columns:
    • AuctionInsightSearchAbsoluteTopImpressionPercentage
    • AuctionInsightSearchImpressionShare
    • AuctionInsightSearchOutrankingShare
    • AuctionInsightSearchOverlapRate
    • AuctionInsightSearchPositionAboveRate
    • AuctionInsightSearchTopImpressionPercentage
Yes
10/11/2024 9050 ProviderHubSpot Added
  • Added UI URLs to four tables: Contacts, Companies, Deals, and Tickets.
No
10/11/2024 9050 ProviderLinkedIn Added
  • Added the Mentions column to the Comments table.
No
10/11/2024 9050 ProviderOracleSalesCloud Added
  • Added the Finder column and other supporting columns to several tables and views.
No
10/11/2024 9050 ProviderSAPConcur Added
  • Added support for filtering on the ReportId and EntryId columns in the Itemizations table.
No
10/10/2024 9049 ProviderAirtable Changed
  • Changed column data type handling for Airtable Rollup and Formula columns. Single-value columns now correctly reflect their data types instead of being reported as a string.
Yes
10/10/2024 9049 ProviderSharePoint Added
  • Added a new connection property, GetColumnsMetadata, to control how column metadata is retrieved in the REST schema.
No
10/09/2024 9048 ProviderOffice365 Added
  • Added the AddAttachments and DeleteAttachment stored procedures.
No
10/09/2024 9048 ProviderOracleSalesCloud Added
  • Added PartyNumber as a key column in the Resources view.
  • Added deprecation note in EmployeeResources view description.
No
10/09/2024 9048 ProviderSlack Added
  • Added a new view: UsersPresence.
No
10/09/2024 9048 ProviderTrello Added
  • Added the OrganizationMembers view which retrieves all members of a specific organization.
No
10/09/2024 9048 SyncAmazonS3 Added
  • Added a connection property: CustomURL.
No
10/08/2024 9047 ProviderSAPConcur Added
  • The driver now validates INSERT and UPDATE queries to ensure that all required columns are included. If a required column is missing, the driver displays an error message.
Yes
10/07/2024 9046 ProviderShopify Removed
  • Removed the AverageOrderAmountV2Amount and AverageOrderAmountV2CurrencyCode columns from the GraphQL-2023-04.Customers and GraphQL-2023-07.Customers tables.
  • Removed the ResourceLimitsSkuResourceLimitsAvailable, ResourceLimitsSkuResourceLimitsQuantityAvailable, ResourceLimitsSkuResourceLimitsQuantityLimit, and ResourceLimitsSkuResourceLimitsQuantityUsed columns from the GraphQL-2023-04.Shop and GraphQL-2023-07.Shop views.
Yes
10/04/2024 9043 ProviderHubSpot Added
  • Added the ItemURL column to the Contacts, Companies, Deals, and Tickets tables in the HubSpot V3 and V4 schemas. This column constructs URLs for direct access to HubSpot UI elements using uiDomain, portalId, and object ID values.
No
10/04/2024 9043 ProviderOracleSalesCloud Changed
  • Changed the handling of custom entities to be reported as views if they only support GET requests.
No
10/04/2024 9043 ProviderQBOnline Added
  • Added the DownloadNote stored procedure.
No
10/03/2024 9042 ProviderCommonDataService Changed
  • Changed the default value for the ApiVersion connection property from 9.0 to 9.2.
No
10/03/2024 9042 ProviderDynamics365 Changed
  • Changed the default value for the ApiVersion connection property from 9.0 to 9.2.
No
10/03/2024 9042 ProviderExchange Added
  • Added the FetchAdditionalUserFields stored procedure to the MSGraph schema.
No
10/03/2024 9042 ProviderSharePoint Added
  • Added a new connection property, IncludeLookupDisplayValueColumns, which is only applicable for the REST schema.
No
10/03/2024 9042 ProviderSlack Changed
  • The ConversationMembers table now supports removing users from conversations via the DELETE operation.
No
10/03/2024 9042 ProviderSlack Added
  • Added the ShareMeMessage stored procedure. This procedure shares a "me message" into a channel.
No
10/02/2024 9041 ProviderAirtable Removed
  • Removed the state output parameter from the RefreshOAuthAccessToken stored procedure.
Yes
10/02/2024 9041 ProviderAsana Added
  • Added 8 columns to the Teams table: Visibility, TeamContentManagementAccessLevel, EditTeamNameOrDescriptionAccessLevel, EditTeamVisibilityOrTrashTeamAccessLevel, MemberInviteManagementAccessLevel, GuestInviteManagementAccessLevel, JoinRequestManagementAccessLevel, and TeamMemberRemovalAccessLevel.
No
10/02/2024 9041 ProviderBlackBaudRaiserEdgeNXT Changed
  • Changed the datatype of the Date column from datetime to date in the Gifts view.
  • Changed the datatype of the EndDate column from datetime to date in the Events view.
Yes
10/02/2024 9041 ProviderGitHub Added
  • Added the following views to the Repository schema: CommitCompare, CommitCompareFiles, and CommitFiles.
  • Added the following stored procedure to the Repository schema: CommitCompare.
No
10/01/2024 9040 ProviderCommonDataService Changed
  • In the Entities schema, fixed an issue where some columns were not properly detected as readonly.
  • In the Entities schema, fixed an issue where some available columns weren't listed.
  • In the Entities schema, fixed an issue where some columns were not properly detected as primary keys.
No
10/01/2024 9040 ProviderMonday Added
  • Added the ItemURL column to the Workspaces table in the Information schema.
No
10/01/2024 9040 ProviderMYOB Changed
  • Changed the following tables to gather all items of all types available within the "types" category specified in the API: - SaleInvoiceItems - SaleQuoteItems - SaleOrderItems - PurchaseOrderItems - PurchaseBillItems Previously, unless a "type" filter was explicitly applied in the query, the above tables only returned a subset of all items available.
Yes
09/30/2024 9039 ProviderAvro Added
  • Added the ListFiles stored procedure. By default, this procedure lists all Avro files in the directory specified by the URI connection property. If an alternative directory is supplied in the AbsolutePath input, this procedure will instead list all Avro files in the supplied directory.
No
09/30/2024 9039 ProviderCSV Added
  • Added the AbsolutePath input to the ListFiles stored procedure. By default, ListFiles lists all CSV files in the directory specified by the URI connection property. If an alternative directory is supplied in the AbsolutePath input, this procedure will instead list all CSV files in the supplied directory.
No
09/30/2024 9039 ProviderJSON Added
  • Added the AbsolutePath input to the ListFiles stored procedure. By default, ListFiles lists all JSON files in the directory specified by the URI connection property. If an alternative directory is supplied in the AbsolutePath input, this procedure will instead list all JSON files in the supplied directory.
No
09/30/2024 9039 ProviderParquet Added
  • Added the ListFiles stored procedure. By default, this procedure lists all Parquet files in the directory specified by the URI connection property. If an alternative directory is supplied in the AbsolutePath input, this procedure will instead list all Parquet files in the supplied directory.
No
09/30/2024 9039 ProviderXML Added
  • Added the AbsolutePath input to the ListFiles stored procedure. By default, ListFiles lists all XML files in the directory specified by the URI connection property. If an alternative directory is supplied in the AbsolutePath input, this procedure will instead list all XML files in the supplied directory.
No
09/28/2024 9037 ProviderAsana Added
  • Added the ItemURL column to the Workspaces table.
No
09/27/2024 9036 ProviderJira Added
  • Added the FiltersUsers and IssueSecurityLevelMembers views. These views are only available for cloud instances.
No
09/27/2024 9036 ProviderSalesforcePardot 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.
No
09/27/2024 9036 ProviderSAPHanaXSA Added
  • A new auth scheme, "None," was added to support connecting to services that require no authorization.
No
09/27/2024 9036 ProviderWordpress Added
  • Added support for the Members table.
No
09/26/2024 9035 ProviderApacheImpala Added
  • Added support for JWT authentication: a new AuthScheme option (JWTToken) and a new property (JWTToken).
No
09/26/2024 9035 ProviderDatabricks Added
  • Added a new AuthScheme OAuthU2M to support user-to-machine authentication.
  • Added a new AuthScheme OAuthM2M to support machine-to-machine authentication.
  • Added a new connection property OAuthLevel, which specifies the valid range of the generated access token. Allowed entries are WorkspaceLevel and AccountLevel.
  • Added a new connection property DatabricksAccountId, which specifies the Databricks account ID and is only required when OAuthU2MLevel is AccountLevel.
No
09/26/2024 9035 ProviderJira Added
  • Added the AssignPermissionScheme stored procedure.
  • Added the following views: PermissionGrants, PermissionSchemes, and ProjectsPermissionScheme.
No
09/25/2024 9034 ProviderJira Changed
  • In the Users table, deprecated four fields: GroupName, GroupId, IssueKey, and ProjectKey. These fields will be removed in the next release.
Yes
09/24/2024 9033 ProviderConfluence Added
  • Added the SpacePermissions view.
No
09/24/2024 9033 ProviderMonday Added
  • Added the Columns table to the Information schema.
  • Added the ChangeColumnMetadata, DeleteColumn, and CreateColumn stored procedures to Workspace schemas.
No
09/24/2024 9033 ProviderWooCommerce Added
  • Added the Options column to the SettingOptions table.
  • Added the SubGroups column to the SettingGroups view.
  • Added the ApiRestock pseudo-column to the OrderRefunds table.
  • Added the RefundTotal pseudo-column to the OrderRefundLineItems view.
  • Added the SettingsInstructionsId column to the PaymentGateways table.
  • Added the Metadata column to the Coupons, Orders, and OrderRefunds tables.
  • Added numerous columns, including the SettingsTaxStatusOptions, SettingsTypeOptions, SettingsClassCostsId, and others to the ShippingZoneMethods table.
No
09/24/2024 9033 ProviderZohoCRM Added
  • Added support for custom fields in the Users view.
  • Added the IncludeCustomFields connection property.
No
09/23/2024 9032 ProviderAcumatica Added
  • Added support for ODataV4 using the Schema connection property. The V4 schema exposes Data Access Class (DAC) objects, while the existing V3 schema continues to expose generic inquiries.
No
09/23/2024 9032 ProviderAzureDevOps Changed
  • Changed the data model structure to use catalogs and schemas for organizing tables and views by project and repository. Each project now has its own catalog, and a new CData catalog was added for non-project-specific information, containing an Information schema. Each project catalog includes a Project schema for general project information, an Analytics schema for data from the Analytics API, and a Repository schema for each repository.
Yes
09/23/2024 9032 ProviderGitHub Added
  • Added INSERT/UPDATE/DELETE support for the OrganizationTeams view in the Information Data Model.
No
09/23/2024 9032 ProviderMonday Added
  • Added support for batch INSERT and DELETE operations to the BoardTeams and WorkspaceTeams tables.
No
09/23/2024 9032 ProviderSnowflake Added
  • Added support for External OAuth by including the OAuthClient authentication option in the AuthScheme connection property and the Other option in the OAuthAuthenticator connection property.
No
09/19/2024 9028 ProviderGoogleAnalytics Added
  • Added the IncludeEmptyRows connection property. When this property is set to True, the driver includes rows for which all retrieved metrics are equal to zero. If set to False, these rows are not included.
No
09/19/2024 9028 ProviderJiraServiceDesk Added
  • Added the RequestCommentAttachments, RequestFeedback, RequestSubscriptionStatus views.
No
09/18/2024 9027 ProviderAsana Added
  • Added the ItemURL column to the Projects, Portfolios, and Teams tables.
No
09/17/2024 9026 ProviderDynamics365 Added
  • 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).
No
09/17/2024 9026 ProviderDynamics365BusinessCentral Added
  • 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).
No
09/17/2024 9026 ProviderDynamicsNAV Added
  • 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).
No
09/17/2024 9026 ProviderEpicorERP Added
  • 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).
No
09/17/2024 9026 ProviderSAPBusinessOne Added
  • 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).
No
09/17/2024 9026 ProviderSAPByDesign Added
  • 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).
No
09/17/2024 9026 ProviderSAPHybrisC4C Added
  • 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).
No
09/17/2024 9026 ProviderSAPSuccessFactors Added
  • 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).
No
09/17/2024 9026 ProviderSlack Added
  • Added support for the ConversationMembers view.
No
09/13/2024 9022 ProviderTrello Changed
  • In the Cards table, the CardId, Name, BoardID, ListID, Description, Closed, LastActivityDate, AttachmentCount, Location, URL, and ShortURL columns no longer accept empty values.
  • In the Comments table, the CommentId, Type, Date, BoardId, CardId, CardName, CardShortLink, and Comment no longer accept empty values.
Yes
09/11/2024 9020 ProviderOData Added
  • Added the ExcludeControlInformationRootType connection property.
No
09/10/2024 9019 ProviderSage300 Added
  • Added 1 new column in sys_tableColumns named ColumnType. ColumnType indicates whether the field is a standard column, a navigation property, a navigation key, a reference column, or a navigation parent key.
No
09/10/2024 9019 ProviderSAPByDesign Added
  • Added the AuthScheme connection property to support Single Sign-On (SSO) with Azure Active Directory.
No
09/10/2024 9019 ProviderWorkday Changed
  • Updated the default SOAP API version in the WSDLVersion connection property to v42.2.
  • Updated the REST API schema to reflect version 20240907 of the API.
Yes
09/10/2024 9019 ProviderWorkday Added
  • Added several tables and views to the REST schema.
No
09/09/2024 9018 ProviderGoogleAdsManager Changed
  • Updated the default value of the Version connection property to "v202405".
Yes
09/09/2024 9018 ProviderMonday Added
  • Added support for batch INSERT and DELETE operations to the BoardUsers, TeamUsers, and WorkspaceUsers tables.
No
09/06/2024 9015 ProviderAnzoGraph Added
  • 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).
No
09/06/2024 9015 ProviderAnzoSmartDataLake Added
  • 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).
No
09/06/2024 9015 ProviderDBAmpSalesforce Changed
  • Changed the default API version to 61.
No
09/06/2024 9015 ProviderFinancialForce Changed
  • Changed the default API version to 61.
No
09/06/2024 9015 ProviderGoogleAnalytics Added
  • Added the DefaultStartDate and DefaultEndDate connection properties, which specify default start and end dates for all queries.
No
09/06/2024 9015 ProviderLinkedInAds Added
  • In the Posts view, added the ContentLandingPage, IsDirectSponsoredContent, DirectSponsoredContentAdAccount, DirectSponsoredContentAdType, DirectSponsoredContentName, and DirectSponsoredContentStatus columns.
No
09/06/2024 9015 ProviderMSProject Added
  • 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).
No
09/06/2024 9015 ProviderMYOB Changed
  • When the CompanyFileId connection property is not specified, the driver will now sort the IDs alphabetically and use the first company file ID in the list.
No
09/06/2024 9015 ProviderSalesforce Changed
  • Changed the default API version to 61.
No
09/06/2024 9015 ProviderServiceNow Changed
  • Fields corresponding to "Journal" type fields in the ServiceNow UI are now marked as read-only since the ServiceNow API does not allow insert or update operations for these fields.
No
09/06/2024 9015 ProviderUMSaaSCloud Changed
  • Changed the default API version to 61.
No
09/05/2024 9014 ProviderLinkedIn Added
  • Added support for the Video Analytics API. The following new views have been added to allow access to video analytics data: VideoViewStatistics, VideoViewerStatistics, VideoTimeWatchedStatistics, and VideoTimeWatchedForVideoViewsStatistics.
No
09/04/2024 9013 ProviderAzureActiveDirectory Added
  • Added the ProfileCardProperties view.
  • Added the AddProfileCardProperty and RemoveProfileCardProperty stored procedures.
No
09/04/2024 9013 ProviderGoogleBigQuery Added
  • Added the DelegatedServiceAccounts connection property. When used in combination with the AuthScheme GCPInstanceAccounts, this property allows you to specify a space-delimited list of delegated service accounts. The default service account email assigned to the project will act as the requesting service account.
No
09/03/2024 9012 ProviderFacebookAds Added
  • Added the PixelAddToCart and PixelPurchase columns to the AdInsights view. These columns expose the offsite_conversion.fb_pixel_add_to_cart and offsite_conversion.fb_pixel_purchase action types.
No
08/30/2024 9008 ProviderMongoDB Added
  • Added the ServiceKind connection property. When connecting to a DocumentDB instance, set ServiceKind=DocumentDB to handle queries correctly.
No
08/30/2024 9008 ProviderOData Added
  • Added support for the OAuthClient and OAuthPassword authentication schemes.
No
08/30/2024 9008 ProviderOData Deprecated
  • Deprecated the OAuthGrantType authentication scheme.
Yes
08/30/2024 9008 ProviderOracleSalesCloud Changed
  • Converted the following Tables into Views: ActivityFunctionLookups, CatalogProductGroups, EmployeeResourceAttachments, EmployeeResources, OpportunityDeals, OpportunityRevenueProductGroups, OpportunityRevenueProducts, Partners, ProgramEnrollments, Resources, and ServiceDetails.
Yes
08/30/2024 9008 ProviderStripe Added
  • Added support for the ReportTypes view.
No
08/29/2024 9007 ProviderDocuSign Added
  • Added the DocumentFileExtension input to the CreateAndSendEnvelope stored procedure.
No
08/29/2024 9007 ProviderSAPGateway Added
  • Added the ComplexTypeName column to the sys_tablecolumns system table.
No
08/29/2024 9007 ProviderWorkday Removed
  • Removed support for the AuthScheme=Auto setting. The default AuthScheme is now set to OAuth. If using SOAP, set AuthScheme=Basic to maintain the previous behavior. No changes are required for other services.
Yes
08/28/2024 9006 ProviderExcelOnline Added
  • Added the OAuthRefreshToken output column to the RefreshOAuthAccessToken stored procedure.
No
08/28/2024 9006 ProviderGoogleSheets Removed
  • Removed the IncludeValuesInResponse connection property.
Yes
08/28/2024 9006 ProviderGraphQL Removed
  • Removed the ExposeRootObjects connection property.
Yes
08/28/2024 9006 ProviderGraphQL Added
  • Added the ExposeObjectTables connection property. This property exposes GraphQL objects that meet certain conditions as tables. See its connection property page for more information.
  • Added support for pagination for arguments nested in input objects.
No
08/28/2024 9006 ProviderGraphQL Changed
  • Changed the names of arguments that the driver expects when customizing the other:Pagination attribute of the rsb:info element in schema files (.rsd). "cursorName" is now "cursorPath", "offsetArgumentName" is now "offsetArgumentPath", and "pageSizeArrgumentName" is now "pageSizeArgumentPath".
Yes
08/28/2024 9006 ProviderLinkedInAds Added
  • Added the QualifiedLeads, CostPerQualifiedLead, MessagingAdvertSendCount, and MessagingAdvertOpenCount metrics to the Analytics view.
No
08/28/2024 9006 ProviderSAP Added
  • Added support for connecting to SAP S/4 HANA Cloud.
  • Added the SAPEdition connection property, which specifies whether the driver connects to SAP S/4 HANA Cloud or SAP S/4 HANA OnPremise.
  • Added the CloudServerPort connection property, which specifies the port the driver uses when connecting to an SAP S/4 HANA Cloud server.
No
08/27/2024 9005 ProviderZohoCRM Added
  • Added ID column in CustomViews.
No
08/26/2024 9004 ProviderBlackBaudRaiserEdgeNXT Added
  • Added GiftFundraisers view.
  • In the Relationships view, added the FirstName, LastName, IsSpouseHeadOfHousehold, and IsConstituentHeadOfHousehold columns.
No
08/23/2024 9001 ProviderAmazonS3 Added
  • Added the GeneratePresignedURL stored procedure.
No
08/23/2024 9001 ProviderAvro Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderCSV Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderDocuSign Changed
  • Changed the Documents view by making the Id and DocumentId columns a composite key to create unique key combinations. This change resolves issues where duplicate keys were incorrectly removed during query execution.
Yes
08/23/2024 9001 ProviderHubSpot Added
  • Added support for INSERT, UPDATE, and DELETE operations on the Leads and LeadAssociations tables in the HubSpot V3 and V4 schemas.
  • Added support for batch INSERT, UPDATE, and DELETE operations on the Leads table in the HubSpot V3 and V4 schemas.
  • Added support for INSERT, UPDATE, and DELETE operations on the LeadProperties, LeadPropertyGroups, and LeadPipelineStages tables in the HubSpot V3 schema.
No
08/23/2024 9001 ProviderJSON Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderParquet Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderREST Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderSASDataSets Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderSASXpt Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/23/2024 9001 ProviderXML Added
  • Added OAuthPKCE as an authentication option when ConnectionType is set to Google Cloud Storage and Google Drive.
  • Added OAuthClient as an authentication option when ConnectionType is set to Box.
No
08/21/2024 8999 ProviderBusinessbridge Added
  • Added the BatchSize connection property, which limits the size of each batch operation during batch processing.
No
08/20/2024 8998 ProviderAmazonAthena Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderAmazonDynamoDB Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderAmazonMarketplace Added
  • Added support for the CatalogItemClassifications view.
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderAmazonS3 Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderAvro Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderCSV Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderDatabricks Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderElasticsearch Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderExcel Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderFHIR Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderGoogleAds Added
  • Added support for V17 of the Google Ads API. This is now the default value for the APIVersion connection property.
  • Added the Ad, CampaignAggregateAssetView, ChannelAggregateAssetView, OfflineConversionUploadConversionActionSummary, and UserListCustomerType views.
  • For all views with a ClickType column, the value AD_IMAGE has been added to them.
  • In the AdGroup view, added the AdGroupFixedCpmMicros, AdGroupTargetCpvMicros, and AdFormatType columns.
  • In the AdGroupAd view, added the column AdFormatType.
  • In the AdGroupAdAssetView view, added the AdFormatType column.
  • In the AdGroupCriterion view, added the AdGroupCriterionPrimaryStatus and AdGroupCriterionPrimaryStatusReasons columns.
  • In the BiddingDataExclusion view's BiddingDataExclusionAdvertisingChannelTypes column, added the value DEMAND_GEN.
  • In the BiddingSeasonalityAdjustment view's BiddingSeasonalityAdjustmentAdvertisingChannelTypes column, added the value DEMAND_GEN.
  • In the Campaign view, added the CampaignFixedCpmGoal, CampaignFixedCpmTargetFrequencyInfoTargetCount, CampaignFixedCpmTargetFrequencyInfoTimeUnit, CampaignKeywordMatchType, CampaignTargetCpv, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowInFeed, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowInStream, CampaignVideoCampaignSettingsVideoAdInventoryControlAllowShorts, AdFormatType, SkAdNetworkRedistributedFineConversionValue and SkAdNetworkVersion columns.
  • In the Campaign view's CampaignAdvertisingChannelType column, added the value DEMAND_GEN.
  • In the ChangeStatus view, added the ChangeStatusAssetGroup column.
  • In the Customer view, added the AdFormatType, SkAdNetworkRedistributedFineConversionValue, and SkAdNetworkVersion columns.
  • In the CustomerClientLink view, added the CustomerId column.
  • In the CustomerNegativeCriterion's CustomerNegativeCriterionContentLabelType column, added the BRAND_SUITABILITY_CONTENT_FOR_FAMILIES,BRAND_SUITABILITY_GAMES_FIGHTING,BRAND_SUITABILITY_GAMES_MATURE,BRAND_SUITABILITY_HEALTH_SENSITIVE,BRAND_SUITABILITY_HEALTH_SOURCE_UNDETERMINED,BRAND_SUITABILITY_NEWS_RECENT,BRAND_SUITABILITY_NEWS_SENSITIVE,BRAND_SUITABILITY_NEWS_SOURCE_NOT_FEATURED,BRAND_SUITABILITY_POLITICS, and BRAND_SUITABILITY_RELIGION values.
  • In the GenderView view, added the SearchImpressionShare column.
  • In the KeywordView view, added the PhoneCalls column.
  • In the LocalServicesLeadConversation view's LocalServicesLeadConversationConversationChannel column, added the WHATSAPP value.
  • In the LocalServicesVerificationArtifact view, added the LocalServicesVerificationArtifactLicenseVerificationArtifactExpirationDateTime and LocalServicesVerificationArtifactInsuranceVerificationArtifactExpirationDateTime columns.
  • In the OfflineConversionUploadClientSummary view, added the OfflineConversionUploadClientSummaryPendingEventCount and OfflineConversionUploadClientSummaryPendingRate columns.
  • In the PerStoreView view, added the Date and Period columns.
  • In the Video view, added the AdFormatType column.
No
08/20/2024 8998 ProviderGoogleAds Removed
  • In the AdGroupAd view's AdGroupAdAdType column, removed the DISCOVERY_CAROUSEL_AD value.
  • In the BiddingDataExclusion view's BiddingDataExclusionAdvertisingChannelTypes column, removed the value DISCOVERY.
  • In the BiddingSeasonalityAdjustment view's BiddingSeasonalityAdjustmentAdvertisingChannelTypes column, removed the value DISCOVERY.
  • In the Campaign view's CampaignAdvertisingChannelType column, removed the value DISCOVERY.
  • Removed the CustomerClientLink view's LinkedManagerId column and CustomerId pseudocolumn.
  • Removed the CustomerLifecycleGoal's CustomerLifecycleGoalLifecycleGoalCustomerDefinitionSettingsExistingUserLists and CustomerLifecycleGoalLifecycleGoalCustomerDefinitionSettingsHighLifetimeValueUserLists columns.
Yes
08/20/2024 8998 ProviderGoogleAds Changed
  • In the AdGroup view's AdGroupExcludedParentAssetFieldTypes column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdBusinessName column to AdGroupAdAdDemandGenCarouselAdBusinessName.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdCallToActionText column to AdGroupAdAdDemandGenCarouselAdCallToActionText.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdCarouselCards column to AdGroupAdAdDemandGenCarouselAdCarouselCards.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdDescription column to AdGroupAdAdDemandGenCarouselAdDescription.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdHeadline column to AdGroupAdAdDemandGenCarouselAdHeadline.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryCarouselAdLogoImage column to AdGroupAdAdDemandGenCarouselAdLogoImage.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdBusinessName column to AdGroupAdAdDemandGenMultiAssetAdBusinessName.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdCallToActionText column to AdGroupAdAdDemandGenMultiAssetAdCallToActionText.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdDescriptions column to AdGroupAdAdDemandGenMultiAssetAdDescriptions.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdHeadlines column to AdGroupAdAdDemandGenMultiAssetAdHeadlines.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdLeadFormOnly column to AdGroupAdAdDemandGenMultiAssetAdLeadFormOnly.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdLogoImages column to AdGroupAdAdDemandGenMultiAssetAdLogoImages.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdMarketingImages.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdPortraitMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdPortraitMarketingImages.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryMultiAssetAdSquareMarketingImages column to AdGroupAdAdDemandGenMultiAssetAdSquareMarketingImages.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb1 column to AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb1.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBreadcrumb2 column to AdGroupAdAdDemandGenVideoResponsiveAdBreadcrumb2.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdBusinessName column to AdGroupAdAdDemandGenVideoResponsiveAdBusinessName.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdCallToActions column to AdGroupAdAdDemandGenVideoResponsiveAdCallToActions.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdDescriptions column to AdGroupAdAdDemandGenVideoResponsiveAdDescriptions.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdHeadlines column to AdGroupAdAdDemandGenVideoResponsiveAdHeadlines.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdLogoImages column to AdGroupAdAdDemandGenVideoResponsiveAdLogoImages.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdLongHeadlines column to AdGroupAdAdDemandGenVideoResponsiveAdLongHeadlines.
  • Renamed the AdGroupAd view's AdGroupAdAdDiscoveryVideoResponsiveAdVideos column to AdGroupAdAdDemandGenVideoResponsiveAdVideos.
  • In the AdGroupAd view's AdGroupAdAdType column, renamed the value DISCOVERY_MULTI_ASSET_AD to DEMAND_GEN_MULTI_ASSET_AD.
  • In the AdGroupAd view's AdGroupAdAdType column, renamed the value DISCOVERY_VIDEO_RESPONSIVE_AD to DEMAND_GEN_VIDEO_RESPONSIVE_AD.
  • Renamed the Asset view's AssetDiscoveryCarouselCardAssetCallToActionText column to AssetDemandGenCarouselCardAssetCallToActionText.
  • Renamed the Asset view's AssetDiscoveryCarouselCardAssetHeadline column to AssetDemandGenCarouselCardAssetHeadline.
  • Renamed the Asset view's AssetDiscoveryCarouselCardAssetMarketingImageAsset column to AssetDemandGenCarouselCardAssetMarketingImageAsset.
  • Renamed the Asset view's AssetDiscoveryCarouselCardAssetPortraitMarketingImageAsset column to AssetDemandGenCarouselCardAssetPortraitMarketingImageAsset.
  • Renamed the Asset view's AssetDiscoveryCarouselCardAssetSquareMarketingImageAsset column to AssetDemandGenCarouselCardAssetSquareMarketingImageAsset.
  • In the AssetGroupAsset view's AssetGroupAssetFieldType column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD.
  • Renamed the Campaign view's CampaignDiscoveryCampaignSettingsUpgradedTargeting column to CampaignDemandGenCampaignSettingsUpgradedTargeting.
  • Renamed the Campaign view's SkAdNetworkConversionValue column to SkAdNetworkFineConversionValue.
  • In the Campaign view's CampaignExcludedParentAssetFieldTypes column, renamed the value DISCOVERY_CAROUSEL_CARD to DEMAND_GEN_CAROUSEL_CARD.
  • Renamed the Customer view's SkAdNetworkConversionValue column to SkAdNetworkFineConversionValue.
  • Renamed the CustomerClientLink view's ClientCustomerId column to CustomerClientLinkClientCustomer.
  • Renamed the CustomerClientLink view's Hidden column to CustomerClientLinkHidden.
  • Renamed the CustomerClientLink view's ManagerLinkId column to CustomerClientLinkManagerLinkId.
  • Renamed the CustomerClientLink view's ResourceName column to CustomerClientLinkResourceName.
  • Renamed the CustomerClientLink view's Status column to CustomerClientLinkStatus.
Yes
08/20/2024 8998 ProviderJSON Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderKeyVaults Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderParquet Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderRedshift Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderREST Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderS3Destination Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderSASDataSets Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderSASXpt Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 ProviderXML Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/20/2024 8998 SyncAmazonS3 Added
  • Added support for the following AWS regions: HYDERABAD, MELBOURNE, CALGARY, SPAIN, ISOLATEDUSEAST, ISOLATEDUSEASTB, and ISOLATEDUSWEST.
No
08/19/2024 8997 ProviderOracleSalesCloud Removed
  • Removed default Finder support. Users must now specify the FinderName in the Finder pseudo-column when querying Finder columns.
Yes
08/19/2024 8997 ProviderOracleSalesCloud Added
  • Added pseudo-columns for Finder fields in Opportunities and related tables.
No
08/19/2024 8997 ProviderSAPConcur Removed
  • Removed support for the UseNewOAuthVersion connection property.
Yes
08/19/2024 8997 ProviderSAPConcur Changed
  • Changed the Invoice, ListsV4, and ListItemsV4 entities from views to tables, enabling support for update and delete operations.
No
08/19/2024 8997 ProviderSAPConcur Added
  • Added support for the ReportsV4 API.
  • Added create, read, update, and delete support for the UsersV4 table.
  • Added support for the following tables: FiscalYears, FiscalPeriods, BudgetCategories, BudgetCategoriesExpenseTypes, BudgetItems, and BudgetTrackingFields.
No
08/19/2024 8997 ProviderSharePoint Changed
  • In the Roles table (SOAP schema), changed the datatype of the Permissions field from LONG to STRING.
Yes
08/16/2024 8994 ProviderShopify Added
  • Added 34 new views related to Segments, OrderAgreements, OrderEditAgreements, and OrderRefundAgreements to all GRAPHQL schemas.
  • Added the Segments table to all GRAPHQL schemas.
No
08/15/2024 8993 ProviderFHIR Added
  • Added support for the Basic AuthScheme.
No
08/14/2024 8992 ProviderSlack Added
  • Added support for the UserProfile table.
  • Added support for the EndCall stored procedure.
  • Added support for the TeamProfileFields and TeamProfileSections views.
  • Added the following columns to the Team view: IsVerified, LobSalesHomeEnabled, Url, and AvatarBaseUrl.
No
08/14/2024 8992 ProviderSlack Removed
  • Removed the DELETE operation for the Calls table.
Yes
08/13/2024 8991 ProviderAlloyDB Added
  • Added support for IAM authentication allowing users to authenticate using OAuth through Google Cloud IAM.
No
08/13/2024 8991 ProviderGoogleCampaignManager Changed
  • In the Files and Reports views, updated the datatype of the LastModifiedTime column to DateTime.
Yes
08/13/2024 8991 ProviderJira Added
  • In the Watchers view, added a new column, IssueID, as part of the primary key. (Jira Cloud only)
No
08/13/2024 8991 ProviderMonday Changed
  • Updated the supported API version to 2024-07.
No
08/13/2024 8991 ProviderMonday Added
  • Added 1 column, Url, to the Boards table and custom boards.
  • Added 1 column, IsDefaultWorkspace, to the Workspaces table.
  • In the Groups table, added support for INSERT queries that include the Color column.
  • For custom boards, added support for server-side date filtering.
No
08/13/2024 8991 ProviderSAP Added
  • Added the SupportServerSideCount connection property.
No
08/13/2024 8991 ProviderSnapchatAds Added
  • Added the AccountId pseudo-column to the AdStats view.
No
08/12/2024 8990 ProviderFacebookAds Added
  • Added the AutoDetectPageTokens connection property. By default, the driver continues to automatically gather page access tokens for mapping when necessary. This new property allows users to disable the automatic retrieval of page access tokens when executing queries that target specific Facebook pages.
No
08/12/2024 8990 ProviderGoogleCalendar Added
  • Added support for the OAuthJWTDelegatedServiceAccounts connection property.
No
08/12/2024 8990 ProviderGoogleDrive Added
  • Added support for the OAuthJWTDelegatedServiceAccounts connection property.
No
08/12/2024 8990 ProviderSalesforcePardot Added
  • Added the HTMLContent column to the Emails view in the V3 & V4 schemas.
No
08/12/2024 8990 ProviderSharePoint Added
  • Added the following stored procedures to the REST schema: AddRoleAssignment, BreakRoleInheritance, and RemoveRoleAssingment.
No
08/12/2024 8990 ProviderTableauCRM Changed
  • The default API version has been updated to version 61.0.
No
08/08/2024 8986 ProviderOracleSalesCloud Added
  • ActivityId and AssigneeId in the ActivityAssignees table are now key columns.
  • ActivityId and ContactId in the ActivityContacts table are now key columns.
No
08/08/2024 8986 ProviderZohoCRM Added
  • Added the APIType connection property to facilitate switching between the REST API and Bulk API. This property takes effect when the UseCOQL property is set to True.
No
08/07/2024 8985 ProviderDRDA Added
  • Added the connection property IgnoreCase to specify whether to send SQL identifiers in the same case as in the provided query or to convert them to uppercase when querying DB2.
No
08/07/2024 8985 ProviderGoogleCloudStorage Added
  • Added support for the OAuthJWTDelegatedServiceAccounts connection property.
No
08/06/2024 8984 ProviderGoogleSpanner Added
  • Added support for the DelegatedServiceAccounts connection property.
No
08/05/2024 8983 ProviderCouchbase Added
  • Added a new authscheme, JWT, to support JWT authentication.
  • Added 10 new connection properties to support JWT authentication: - JWTToken - JWTSubject - JWTIssuer - JWTAlgorithm - JWTExpiration - JWTKey - JWTKeyType - JWTClaims - JWTHeaders - CredentialsFileLocation
No
08/05/2024 8983 ProviderDynamics365 Added
  • Added the UseEntityDefinitions connection property.
No
08/05/2024 8983 ProviderWorkday Added
  • Added a new stored procedure, CreateWQLSchema, which enables users to create tables in the driver that execute specific WQL in Workday. The new stored procedure can be used with the Workday Convert Report to WQL task to get the same data as the report, but with better performance than the Reports service.
No
08/02/2024 8980 ProviderCIS Added
  • Added support for the SQL query function JSON_TABLE.
No
08/02/2024 8980 ProviderCISCData Added
  • Added support for the SQL query function JSON_TABLE.
No
08/02/2024 8980 ProviderCISODBC Added
  • Added support for the SQL query function JSON_TABLE.
No
08/02/2024 8980 ProviderCISV2 Added
  • Added support for the SQL query function JSON_TABLE.
No
08/02/2024 8980 ProviderDatabricks Added
  • Added a new connection property ServerTimezone to allow users to specify the time zone ID of the current platform. Options are UTC (default), LOCAL, or a user-specified time zone.
No
08/02/2024 8980 ProviderGitHub Added
  • Added the PullRequestReviewRequests table.
  • Added the Permission column to the Collaborators view.
  • Added UPDATE/DELETE support for the Organizations table.
  • Added INSERT/UPDATE/DELETE support for the IssueComments table.
No
07/30/2024 8977 ProviderApacheHive Added
  • Added a new connection property UseJGSS to support using the native Java Kerberos Authentication (JGSS).
No
07/30/2024 8977 ProviderApacheImpala Added
  • Added a new connection property (UseJGSS) to support the use of native Java Kerberos Authentication (JGSS).
No
07/30/2024 8977 ProviderGoogleAnalytics Added
  • Added the UINames attribute to the CreateCustomSchema stored procedure.
No
07/30/2024 8977 ProviderMSTeams Added
  • Added the following stored procedures: CreateChat, UpdateChat, DeleteChat, UpdateMessage, DeleteMessage, UpdateChatMessage, and DeleteChatMessage.
No
07/29/2024 8976 ProviderAmazonS3 Added
  • Added the Buckets connection property. When the Buckets property is active, the Buckets table displays null for every column except the primary key Bucket.
No
07/29/2024 8976 ProviderLinkedInAds Added
  • Added 3 new columns in the Analytics view: PostClickRegistrations, PostViewRegistrations, and DownloadClicks.
No
07/29/2024 8976 ProviderSlack Added
  • Added support for 4 stored procedures: EndDnd, EndSnooze, Set Snooze, and SendScheduledMessage.
  • Added one new view: TeamInfo.
No
07/26/2024 8973 ProviderLinkedInAds Added
  • Added 3 new columns in the Creatives view: CallToActionLabel, CallToActionFormId, and RejectionReasons.
No
07/25/2024 8972 ProviderPresto Added
  • Added support for the Basic AuthScheme, for use with a Starburst Galaxy instance (cloud-based Trino).
No
07/24/2024 8971 ProviderAmazonAthena Added
  • Added 'Description' as a custom column for sys_schemas. 'Description' returns a description of the schema.
No
07/24/2024 8971 ProviderMailChimp Removed
  • The ListId column in the AutomationEmailQueues table is no longer a key column.
  • The ListId column in the AutomationsRemovedSubscribers view is no longer a key column.
  • The ParentId and BlockId columns in the CampaignFeedback table are no longer key columns.
  • The ProductId and ProductVariantId columns in the EcommerceCartLines table are no longer key columns.
  • The CampaignId column in the EcommerceCarts table is no longer a key column.
  • The ProductId and ProductVariantId columns in the EcommerceOrderLines table are no longer key columns.
  • The FolderId column in the FileManagerFiles table is no longer a key column.
  • The CampaignId column in the ReportAdvice view is no longer a key column.
  • The CampaignId column in the ReportDomainPerformance view is no longer a key column.
  • The FolderId column in the Templates table is no longer a key column.
Yes
07/24/2024 8971 ProviderMailChimp Added
  • Added Region as a key column in the ReportLocations view.
No
07/24/2024 8971 ProviderSAPGateway Added
  • A new column, ColumnType, is added to sys_tablecolumns. Legal values for this column include:
    • System -- use for default columns for the entity.
    • Linkedcolumn -- use when pushing navigation properties as columns; see IncludeLinkedColumns.
    • Navigationkey -- use when pushing navigation keys on the parent entity; see IncludeNavigationKeys.
    • Referencecolumn -- use when pushing reference columns; see IncludeReferenceColumn.
    • Navigationparentcolumn -- use when pushing parent keys on navigations properties that are listed as views; see IncludeNavigationparentCoumns.
No
07/24/2024 8971 ProviderSlack Removed
  • Removed support for CompleteReminder Stored Procedure.
Yes
07/24/2024 8971 ProviderSlack Added
  • Added support for EnableUserGroup and DisableUserGroup Stored Procedures.
No
07/23/2024 8970 ProviderAvro Removed
  • Removed 2 connection properties: DeleteDownloadedFiles and TemporaryLocalFolder.
Yes
07/23/2024 8970 ProviderExcel Changed
  • The URI property can now be set to a local folder.
No
07/23/2024 8970 ProviderGitHub Added
  • Added OrganizationTeamMembers, OrganizationTeamProjects, and OrganizationTeamRepositories as new views in the Information Data Model.
  • Added MinPermissionLevel as a new column in Information.Projects.
No
07/23/2024 8970 ProviderSlack Added
  • Added support for UploadFile Stored Procedure.
No
07/23/2024 8970 ProviderWorkday Added
  • Added support for setting effective dates in the SOAP API using the new As_Of_Effective_Date_RespFilter prompt column.
No
07/19/2024 8966 ProviderSquare Added
  • Added support for the Shifts endpoint. This includes the creation of pseudo columns that can be used with search shifts endpoint: DataRange_End_Date, DateRange_Start_Date, Start_End_At, Start_Start_At, End_End-At, and End_Start_At.
No
07/18/2024 8965 ProviderDynamicsNAV Added
  • Added the SupportsFilter connection property that gives users the ability to define if the filters will be handeled server-side or client-side.
No
07/18/2024 8965 ProviderGoogleAnalytics Removed
  • Removed the DefaultFilter property.
Yes
07/18/2024 8965 ProviderOData Added
  • Added the ColumnType column to the sys_tablecolumns system table. This column identifies whether the columns of a table/view in your schema are standard columns, navigation properties, navigation keys, reference columns, or navigation parent keys.
No
07/17/2024 8964 ProviderBlackBaudRaiserEdgeNXT Changed
  • Changed the datatype of the FileSize column from integer to long in the ActionAttachments, AppealAttachments, CampaignAttachments, ConstituentAttachments, GiftAttachments and OpportunityAttachments views.
  • Changed the datatype of the Date column from date to datetime in the Actions and Gifts views.
  • Changed the datatype of the Start column from date to datetime in the FundraiserAssignments view.
  • Changed the datatype of the ActualAmount column from integer to double in the GiftBatches view.
  • Changed the datatype of the CheckDateD, CheckDateM, CheckDateY, ReferenceDateD, ReferenceDateM and ReferenceDateY columns from string to integer in the GiftPayments view.
  • Changed the datatype of the AmountValue column from integer to double in the GiftReceipts view.
  • Changed the datatype of the DuesValue column from integer to double in the Memberships view.
  • Changed the datatype of the AskDate column from date to datetime in the Opportunities view.
  • Changed the datatype of the AppliedAmount column from integer to double in the ParticipantFeePayments view.
  • Changed the datatype of the EventFeeContributionAmount and TaxReceiptableAmount columns from integer to double in the ParticipantFees view.
Yes
07/17/2024 8964 ProviderFacebookAds Added
  • Added the AsyncTimeout connection property, which specifies how long the driver should wait for results when submitting an asynchronous request for insights. If insights are not returned by the time specified in AsyncTimeout, an error message is returned.
No
07/16/2024 8963 ProviderSharePoint Changed
  • The RoleDefinitionBindings view now has a composite key consisting of both Id and PrincipleID. Formerly it had a primary key.
Yes
07/15/2024 8962 ProviderGoogleAnalytics Removed
  • Removed the UniversalAnalytics schema and its associated tables, views, and stored procedures.
  • Removed the Profile, ApiVersion, IncludeEmptyRows, UseResourceQuotas, and SamplingLevel connection properties.
Yes
07/15/2024 8962 ProviderPCASales Added
  • Added the ShireZeikomiKubun, UriageZeiSyubetsu, ShireZeiSyubetsu, and ZeiSyubetsuKirikae columns to the MasterSms table.
  • Added the InputSYKH_SeikyusakiMei1 and InputSYKH_SeikyusakiMei2 columns to the InputSYK table.
  • Added the ShireZeiSyubetsu column to the InputHACD table.
No
07/15/2024 8962 ProviderQBOnline Added
  • Added the 'Columns' input to the CreateTransactionListWithSplitsReport stored procedure.
No

We appreciate your feedback.  If you have any questions, comments, or suggestions about this entry, please contact our support team at support@cdata.co.jp.