CData Drivers

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 📖 Walkthrough Guide → How to Analyze YouTube Audience Retention 🔗 Free Trial → Download the Add-InLet us know what insights you uncover — or if you need help getting started!

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 walkthrough → How to Import Gmail Data into Excel 🔗 Try the Add-In free for 30 days: Download the Add-In Let us know how you're using it, or if you have questions!

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.

Hello everyone,I recently purchased the CData QuickBooks ODBC Driver (Desktop version, $499/year) for one desktop and one data source (QuickBooks), as shown in the attached image.When trying to use it in Navicat Premium to query data, I get the following error: 1003 - The feature is only available with an Enterprise server license of CData Provider for QuickBooks 2024.I’m attaching screenshots of both the purchase and the error.My questions are: Why is it asking for an Enterprise Server License if I bought the Desktop version? Is there any configuration I need to change for it to work in my current setup? My final goal, after successfully testing with Navicat, is to connect to QuickBooks from a Laravel application.Thanks in advance for any guidance.

Hello everyone,I recently purchased the CData QuickBooks ODBC Driver (Desktop version, $499/year) for one desktop and one data source (QuickBooks), as shown in the attached image.When trying to use it in Navicat Premium to query data, I get the following error: pgsqlCopiarEditar1003 - The feature is only available with an Enterprise server license of CData Provider for QuickBooks 2024. I’m attaching screenshots of both the purchase and the error.My questions are: Why is it asking for an Enterprise Server License if I bought the Desktop version? Is there any configuration I need to change for it to work in my current setup? My final goal, after successfully testing with Navicat, is to connect to QuickBooks from a Laravel application.Thanks in advance for any guidance.

Hey CData Community!Starting with CData HubSpot Driver v24, you can access the Leads object just like any other table. No complex API calls or custom workarounds needed.Whether you're using CData Connect Spreadsheets, CData Sync, or CData Arc, managing and syncing your HubSpot leads is now simpler and faster!Read our latest article to know more: https://www.cdata.com/kb/articles/hubspot-driver-leads-object.rst

You can now use the CData MySQL Connector to connect to Apache Doris, enabling live access from BI, ETL, and custom apps that support MySQL connectivity.This approach leverages the compatibility between Doris’s MySQL wire protocol and the CData MySQL Connector, letting you integrate Doris data into your existing workflows with minimal setup.Read the full article here:Connect to Apache Doris with the CData MySQL Connector

Hey CData Community!Want to generate Balance Sheet Detail reports from QuickBooks Online without diving into API complexity? With CData’s new CreateBalanceSheetDetailReport stored procedure, you can do just that using a few SQL commands in DBeaver or a bit of Java in VS Code if you prefer to code.In our latest article, we demonstrate how to connect to QBO with the CData JDBC driver and run the procedure to get clean and custom reports in no time.Read here: https://www.cdata.com/kb/articles/quickbooks-online-createbalancesheetdetailreport.rst

Hey CData Community!We are excited to announce that you can now write external data directly into Salesforce Data Cloud using the CData Salesforce Data Cloud JDBC Driver!From databases to SaaS apps, ingesting data into SFDC is faster and easier than ever. No complex pipelines, no extra tools—just simple, live connectivity.Check out how to make it happen with the CData Salesforce Data Cloud JDBC Driver (v25) in our latest article: https://www.cdata.com/kb/articles/salesforce-data-cloud-ingestion-api.rst

With Shopify’s REST Admin API now marked as “legacy,” many are preparing to shift to the GraphQL Admin API.The good news? CData Drivers handle the transition for you.Whether you’re using Power BI, Tableau, or any BI tool — our latest article shows how you can: Connect to Shopify’s GraphQL API with no code changes Continue using SQL to query data like SELECT * FROM Orders Avoid query cost headaches with built-in Bulk API optimization 👉 Read the full migration guide →

Het CData Community!We just supercharged our Amazon Athena JDBC driver with Streaming API support, and the results are wild. We're talking up to 4x performance boosts for your queries. Less waiting, more doing.Whether you're working with large datasets or handling high-concurrency workloads, this update significantly reduces latency and memory usage for smoother performance.Check out the benchmarks and see why the Streaming API is the secret sauce your Athena setup has been waiting for, in our latest article: https://www.cdata.com/kb/articles/amazon-athena-streaming-api-performance.rst

Hey CData Community!Tired of juggling data between Google Sheets and Microsoft Access?With CData Drivers and Connectors, you can read and update your Google Sheets directly from Microsoft Access. No exports, no copy paste. Just connect.Check out our latest guide to simplify your workflow: Read and Modify Google Sheets Directly from Microsoft Access

Hey CData Community!Feeling lost in a sea of Facebook Ads charts, clicks, and conversions?Well, running campaigns is just the first step. Making sense of the data is where the real impact begins.With CData Facebook Ads drivers and connectors, you can plug your ad data straight into tools like Power BI, Tableau, or Excel and turn all that noise into clear, actionable insights.Curious how it works? Explore our latest guide on creating interactive dashboards that truly enhance your understanding of your performance.Read our latest post here: https://www.cdata.com/kb/articles/facebook-ads-performance-visualization.rst

'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"cause":"Validation failed : DISCRETE_PAGINATION_LIMIT_EXCEEDED => You can only get the first 2000 records without using page_token param [ 2000 ] ","conditions":"","connection_type":"Zohocrm","entity_type":"Accounts"}}],"message":"Unable to list entities.","status":"FAILED_PRECONDITION"}}'

We would like to inquire if there are any specific restrictions or limitations when fetching records for "campaigns" specifically from Salesforce Marketing Cloud (SFMC) using CData connectors/drivers.

We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Campaigns entity.However, when attempting to list or retrieve data for the Campaigns entity, we are consistently encountering the following error response:{  "error": {    "code": 400,    "details": [      {        "@type": "type.googleapis.com/google.rpc.ErrorInfo",        "metadata": {          "cause": "[10000] \"A general error occurred while trying to retrieve campaigns\". A general error occurred while trying to retrieve campaigns. ",          "conditions": "",          "connection_type": "SFMarketingCloud",          "entity_type": "Campaigns"        },        "message": "Unable to list entities.",        "status": "FAILED_PRECONDITION"      }    ]  }} 

We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Journeys entity.However, when attempting to list or retrieve data for the Journeys entity, we are consistently encountering the following error response: Execution timeout, cancelled graph execution. Note any variable contains large data was failed to upload to GCS. Please try again. error/code: 'common_error_code: SYNC_EVENTBUS_EXECUTION_TIMEOUT''View logs for error details. Check the troubleshooting guide  for possible ways to resolve your error.

Hey CData Community!Looking for a simple and safe way to test Salesforce APIs?Our latest article shows you how to connect with OAuth 2.0, set up Postman, and make REST calls to view or update Salesforce data quickly and securely.Check out our step-by-step guide: Authenticate and Call Salesforce REST APIs with Postman