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:
Azure AD Azure Data Lake Storage Bing Ads Exchange FHIR
| Planner Teams Office 365 OneDrive OneNote
| Power BI XMLA MySQL PostgreSQL
|
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
Explore CData Drivers and Connectors
Get blazing-fast access to live data with seamless connectivity from your data sources to the tools you use every day. Our standards-based connectors make data integration effortless—just point, click, and go.
