CData Drivers

The CData Salesforce connectivity solutions make it easy to synchronize data with Salesforce by enabling seamless UPSERT operations using External IDs. An External ID allows you to match records from your source system with corresponding Salesforce records ensuring accurate updates, preventing duplicates, and simplifying data integration workflows.In this article, you’ll learn how to: Create and configure an External ID field in Salesforce Connect to Salesforce using the CData Salesforce Driver Perform an UPSERT operation using the External ID for record matching To learn more, read: How to Use an External ID to Perform an UPSERT Operation against Salesforce

API limits in Microsoft Dynamics 365 and Dataverse directly affect integration performance, throughput, and reliability. To help teams plan and optimize usage, we published a clear breakdown of daily request allocations, service-protection throttling, and how these limits impact the CData Dynamics 365 / Dataverse Driver. Highlights: Daily request allocations for licensed and application users Per-request limits: 5,000-record pages and 1,000-operation batch caps Service Protection Limits (request count, execution time, concurrency) How the CData Driver translates SQL queries into multiple Web API calls How to monitor API usage and avoid 429 throttling  Read the full article here:https://www.cdata.com/kb/a

Hey CData Community!Struggling with SharePoint’s 5,000-item limit? Our latest article shows how to easily bypass this threshold using CData SharePoint Drivers. Discover simple steps to access larger datasets smoothly and efficiently.Explore the full guide: www.cdata.com/kb/articles/sharepoint-5000-limit.rst

Hey CData Community!Accessing your Shopify data just got simpler!Our latest guide walks you through generating a custom Admin API token and connecting seamlessly with CData Shopify JDBC Driver, enabling smooth, SQL-style access to your Shopify store data.Explore the steps here: Shopify API Access Token Guide

Hey CData community,If you’re working with live data in Salesforce and want to harness the full power of Excel to update records — you’re going to like this. With the CData Excel Add-In for Salesforce, the article shows how to use the CDATAUPDATE function to push changes from Excel back into Salesforce. (See the KB article here: How to Update Salesforce Records from Excel with CDATAUPDATE.)

Hey CData Community!Ever found yourself wrestling with attachments in Kintone and thought, “there’s gotta be an easier way”?Good news: we just dropped a guide on how to bulk upload/delete/manage multiple files in Kintone using the CData Kintone JDBC driver.Check it out here: https://www.cdata.com/kb/articles/kintone-uploadfile.rst

The CData Tableau Connector for Salesforce enables you to access, visualize, and analyze live Salesforce data directly within Tableau without complex setup or manual exports. Using the connector’s dynamic capabilities, you can bring in not just standard Salesforce objects, but also computed Formula Fields, empowering deeper insights and more accurate reporting.In this article, you’ll learn how to: Connect Tableau to Salesforce using the CData Connector Retrieve and display Salesforce Formula Fields alongside standard data Build visualizations that reflect live, calculated Salesforce metrics Refresh data in real time without reloading or reconfiguring your dashboards To learn more, read:How to Retrieve Salesf

Hey CData Community 👋If you are managing lots of tasks in Microsoft Planner and find the manual entry process cumbersome, you will definitely want to check out this workflow. With the CData Excel Add-In for Microsoft Planner, you can bulk-import, update and manage Planner tasks right from Excel — no exports, no manual copy/paste, no complex flows. Check the link below to get a quick overview of what’s possible and how to get started.Link: https://www.cdata.com/kb/articles/planner-exceladdin-bulk-import.rst

I am test driving the ADO.NET provider for Snowflake to connect to data in Snowflake from Analysis Services in Multidimensional Mode. I follow the descriptions in the article.https://www.cdata.com/kb/tech/snowflake-ado-ssas.rstConnection to Snowflake succeeds but when I try to add tables to the Data Source View there are no tables/views shown. The dialog is completely empty. Compare section “Creating a Data Source View” point 4 in the article where tables are visible.(Remark: I am also sure that tables are available in my Snowflake database) I have set logging level to 5 and inspected the logs. The connection requests seem to work fine. But when calling ADOConnectionImpl.GetDataSourceInformation() it seems not to find the system table sys_sqlinfo. What am I doing wrong? What is the root cause for not seeing

The CData Excel Add-in empowers you to access, query, and manipulate live data directly from Excel without complex scripting or manual imports. Using CData Excel Functions, you can dynamically retrieve data from any supported source based on cell values, enabling real-time analytics and data-driven decisions right within your spreadsheets.In this article, you’ll learn how to:Use CData Excel Functions to query live data dynamically Reference cell values to filter and update your results in real time Combine multiple data sources for unified analysis Automate data refreshes and streamline reporting with no-code configurationsTo learn more, read:Dynamically Retrieve Data Based on Cell Values with the CData Excel Add-in: CData Excel Formulas

Hey CData Community,You can now stop juggling “.accdb” files between desktops, emails, and USB drives! The CData Access Drivers & Connectors (v24.3+) now let you connect directly to Access databases stored in Google Drive, S3, OneDrive, Box, SharePoint, and more.Query and analyze Access data straight from the cloud with secure authentication and zero manual downloads. It’s fast, easy, and collaboration-friendly.Learn more: https://www.cdata.com/kb/articles/microsoft-access-cloud-storage.rst

CData Drivers now include a ThreadID in their log output, making it easier to trace operations across multiple threads in complex or concurrent workloads. Each log line includes a fixed-width ThreadID, helping you identify which thread generated each event for clearer, faster debugging. Learn how to read and interpret ThreadID values to isolate issues, track concurrent activity, and gain deeper insight into driver behavior in our latest KB article:👉 Using ThreadID in CData Driver Logs to Debug Multi-Threaded Operations

Hey CData Community!Microsoft Access has announced the retiring of its built-in Salesforce ODBC driver in October 2025 (https://techcommunity.microsoft.com/blog/AccessBlog/access-announces-removal-of-salesforce-odbc-driver-in-october-2025/4408815), but organizations can maintain seamless access to Salesforce data with the CData Salesforce ODBC Driver. This driver enables users to connect Access with Salesforce securely and reliably, ensuring business processes and reporting workflows remain uninterrupted. It’s a simple way to keep your Access applications connected without disruption.Read the full article & learn how to migrate to the CData Salesforce ODBC driver to ensure a seamless transition here:

Accessing PostgreSQL databases hosted in the cloud (like Amazon RDS or Azure) often requires routing through an SSH server, which can be tricky with manual port forwarding and tools like PuTTY.With the CData PostgreSQL ODBC Driver, you can set up a secure connection in just minutes — no extra SSH tools required. 🚀Key Highlights: 🔒 Built-in SSH tunneling — no PuTTY, no manual port configs. ⚡ Quick setup — configure a DSN once and connect instantly. 🌐 Works with Amazon RDS for PostgreSQL + AWS EC2 jump servers (and other cloud setups). 🔎 Query live PostgreSQL data from your favorite BI, analytics, or ETL tools.   👉 Full step-by-step guide with screenshots: 

Hey CData Community!If you're a fan of Go (Golang) and you’ve been wishing your apps could tap into real-time data without building complex connectors or wrestling with custom drivers, your wish just came true.We've just released a guide on how to use Go’s net/http and encoding/json packages to connect to a data source table exposed via CData API Server - but that’s just the beginning. This pattern works for any of the 300+ sources we support.Refer to learn more: https://www.cdata.com/kb/articles/golang-http-apiserver.rst

CData Microsoft Teams Drivers make it easy to integrate Microsoft Teams data into your applications without heavy coding. By exposing Teams APIs through familiar SQL interfaces (ODBC, JDBC, ADO.NET), you can query Teams data, send messages, and even automate channel interactions directly from your existing tools.In this article, you’ll learn how to:Use the SendMessage stored procedure to post messages to a specific Teams channel Retrieve Team IDs and Channel IDs from Teams or driver queries Send rich content including HTML messages, high-importance alerts, and @mentions Leverage the driver to manage Teams data for deeper automationTo learn more, read: Send Messages to a Specified Microsoft Teams Channel with CData Drivers

Hey CData Community!CData Sage Intacct drivers support write operations using embedded Web Services credentials with Basic authentication. That means you can create, update, or delete Intacct objects—like vendors, engagements, or custom fields—without managing separate SenderID credentials.• Simplifies setup: no need to procure or configure additional credentials• Enables full read/write access with familiar authentication flow• Works across CData Intacct drivers and integration tools that support embedded credentialsCheck out the full article here: https://www.cdata.com/kb/articles/intacct-write-embedded.rst

Hi all, I kindly need help on this one. While checking the documentation CData JDBC Driver for Google Analytics - GoogleAnalytics4 Data Model , I noticed that there are no metrics or dimension related to TAX, DISCOUNT, SHIPPING ,REFUND. These informations were present in the universal model.From the documentation say this in the EcommPurchaseItemIdReport (see boxed part of screenshot) , but the Column names and the description do not match. and after querying the data, it proved that they indeed do not match .   

Hey CData Community!Need to transfer files between a Google Cloud Platform VM and your SQL tools or ETL workflows? Check out one of our latest articles, which walks you through how to securely connect to GCP VMs via SFTP - whether you're using WinSCP, FileZilla, or the CData SFTP JDBC Driver.Check out the full article here: https://www.cdata.com/kb/articles/jdbc-sftp-gcp.rst

Want to dive into YouTube retention metrics without writing code? With the CData Excel Add-In for YouTube Analytics, you can connect directly to your YouTube channel and analyze key engagement KPIs like:🎯 audienceWatchRatio📉 relativeRetentionPerformance⏱️ elapsedVideoTimeRatio...all inside Microsoft Excel. ✅ Why this matters: No scripts or API knowledge needed Pull data directly from YouTube Analytics Build real-time dashboards & visuals Filter by audience type, device, and more  🛠️ Steps: Connect your YouTube account via OAuth Select the AudienceRetention view Filter by video ID and date range Visualize drop-offs and retention patterns in Excel 📖

Need to analyze Gmail data in Excel? With the CData Excel Add-In for Gmail, you can connect directly to your inbox, sent items, or labels — and query your emails just like a database using SQL. No coding required. 🔍 Use cases: Filter & search emails by subject, sender, or date Build charts, dashboards, and pivot tables Analyze communication patterns or volume over time ✅ Key Benefits: Real-time connectivity via Gmail API Full SQL support inside Excel Secure OAuth-based authentication Easy setup with no code required 🛠️ Steps: Configure Gmail API in Google Cloud Console Authenticate using the CData Excel Add-In Query & analyze your Gmail data — instantly 📖 Read the full

Hey CData Community!The CData Driver for Databricks now offers an optional setting to disable the automatic execution of SELECT version() during connection initialization. By default, the driver runs this query to confirm the SQL Warehouse is responsive—but in high-throughput or multi-threaded environments, that check can introduce unwanted overhead. This new toggle lets you skip that step and boost connection performance - faster startup times, improved throughput, and reduced load on your warehouse. Just make sure your application handles connectivity errors if the check is turned off.Check out the full article here: https://www.cdata.com/kb/articles/databricks-select-version.rst

Hey CData Community!If you’ve ever run into the dreaded “invalid_grant: Token has been expired or revoked.” error when using OAuth 2.0 refresh tokens with Google Cloud Platform, this article is for you. It explains why that error occurs—ranging from revoked access and expired tokens to testing-mode limitations—and shows how CData's GCP-connected drivers help you avoid these pitfalls. This means more reliable, uninterrupted access to Google APIs.• Understand the key reasons behind the invalid_grant error• See how CData drivers simplify handling of refresh tokens• Discover trial options for seamless Google API connectivityCheck out the full article here: https://www.cdata.com/kb/articles/gcp-oauth-refresh-token.rst 

Hey CData Community!Are you tired of wrestling CSV files into Airtable? The new CData SyncCSV stored procedure is here to save the day to insert those files straight in with just a T-SQL command! Check out our latest guide and grab a free 30-day trial to unleash the magic. Let’s automate the fun.Full article here👈🏼Drop your questions below!

Need to update one column with values from another? You can do it directly with CData Drivers using standard SQL.We show how to run an UPDATE statement against live SaaS and database sources—no exports, no workarounds. The example uses our ODBC Driver for Salesforce, but the same approach works across all drivers that support UPDATE.This is useful for data cleanup, migration, or quick edits—especially in SaaS environments where this kind of operation is often difficult.📖 Full blog here Got a question or want to share how you’re using SQL with CData Drivers? Drop it below.