Explore the 2024.3 Update for CData Drivers and Connectors

The latest CData Driver and Connector update (2024.3) continues CData's mission to add connectivity the best and broadest connectivity solutions in the market. While this release doesn't see any new data sources, there is a notable change in our Shopify integration (due to Shopify's pending deprecation of their REST API) and many feature enhancements.

Breaking change: Shopify connectors use GraphQL by default

The supported API version for CData’s Shopify drivers has been updated to API 2024-07, covering both GraphQL 2024-07 and REST 2024-07. By default, the schema now uses Shopify GraphQL 2024-07, as Shopify designated their REST API as "legacy" as of October 1, 2024. Users can continue to access the Shopify REST API by setting the Schema connection property to "REST-2024-07." Shopify has not yet announced an official deprecation date.

To streamline Shopify analytics and integration workflows, CData models GraphQL data as tables and views.

Key enhancements

Seamless access to documentation from the ODBC and Power BI DSN configuration window

Starting with release 2024.3, users can now access the CData documentation directly from the DSN configuration window in ODBC drivers and Power BI connectors. Each connection property includes a direct link to the corresponding documentation page, allowing users to quickly access details such as possible values and default settings. While previous versions provided brief property descriptions within the DSN configuration window, this enhancement streamlines troubleshooting and setup by enabling instant access to comprehensive documentation.

Tableau-integrated Azure AD (OAuth) for Microsoft services

Accessing Microsoft services from Tableau is now more seamless than ever! CData Tableau Connectors now support Tableau-integrated Azure AD for multiple Microsoft data sources, eliminating the need for users to create an OAuth application manually. Instead, users can simply log in with their Microsoft account through a browser and grant access from Tableau.

This feature is particularly beneficial for organizations using both Tableau Server and Tableau Desktop, as it enables credential sharing between the two. Tableau-integrated Azure AD is now supported for the following data sources:

Salesforce drivers now support parallel download with Bulk API 2.0

CData Drivers for Salesforce can now leverage parallel downloads when Bulk API 2.0 is enabled. Salesforce’s Bulk API 2.0 is designed for asynchronous processing of large query results (2,000 records or more), optimizing performance for high-volume data operations.

With Salesforce’s Winter '25 release, the parallel download feature is now generally available. By distributing the download process across multiple streams, this enhancement significantly reduces the time required to retrieve large datasets, improving overall efficiency.

Other enhancements

• All sources: CData Drivers now support loading SSL server certificates from Amazon S3 buckets
• Adobe Commerce: Added CanDeleteCustomer, CanDeletecustomerGroup stored procedures
• Azure AD: Added support to list all users' direct membership details
• Azure DevOps: Added support for create, update, delete operations to the WorkItems table; added Environments table; added CreatePullRequestAttacement and DeletePullRequestAttachemtn stored procedures; added support for adding and deleting Build Tags
• Box: Added the SearchRootId column to Folders, Files, & Bookmarks table for performance improvement
• Exact Online: Added support for eight new Sync API endpoints (set UseSyncAPI=True)
• FacebookAds: Added support for Standard Enhancements in the CreateAdPreview stored procedure
• Jira: Added support for OAuth authentication for Confluence Data Center
• kintone: Added support for UPSERT
• Microsoft Access: Added support for querying Access files on remote storage (S3, SharePoint, Box, etc.)
• Microsoft CDS: Added connection properties related to Lookup columns
• Microsoft Office365: Added MessageAttachments and EventAttachments views
• Okta: Added write functions for Users Groups. Custom Roles, Applications, and additional stored procedures; added support for user suspend and unsuspend operations
• Oracle ERP: Create, update, delete support added for multiple end points
• Pinterest: Added Audience, TargetingtypeKEYWORD, TargetingtypeAUDIENCE_INCLUDE, and TargetingtypeAUDIENCE_EXCLUDE views
• Pinterest: Added support for retrieving individual items from AdAccounts, Campaigns, AdGroup, Ads
• Snowflake: Added ConvertDateTimeToGMT and DateTimeStringFormat connection properties
• Splunk: Added functionality to modify "earliest_time" and "latest_time"
• Twilio: Added support for API Key authentication
• Veeva Vault: Added support for all versions; added support for Okta SSO
• WordPress: Added support for Client Credentials grant type
• Zendesk: Added stored procedures for uploading/downloading ticket attachment

If you are working with any of the data sources mentioned above using CData Drivers and Connectors, download the latest release to take advantage of the latest features and update