CData Drivers

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 

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 

Need secure, programmatic access to Google Calendar data for your apps or workflows?Our latest article shows you how to use the CData JDBC Driver to: Authenticate with a Google service account Share calendars and build connection strings Query, update, and manage live Calendar data — all through SQL No manual calendar imports, no browser-based OAuth flow. Just direct, secure access.👉 Read the full setup guide →

Hey CData Community!Trying to get OAuth working in Salesforce? This easy guide shows you how to set it up step by step, so you can securely connect your applications without any confusion.Check out the article: How to Easily Set Up OAuth Authentication in Salesforce   

Hey CData Community!If you're working with the Zoom API and need a secure way to test endpoints, this quick guide is for you. It covers setting up OAuth credentials, making API calls in Postman, and connecting via CData API Drivers using OAuth 2.0.To know more, refer to this article: Authenticate and Access Zoom API with OAuth and Postman

import cdata.dynamics365 as modconn_str = (    'OrganizationUrl=https://dddddd.crm4.dynamics.com;'    "OAuthSettingsLocation=/home/ddddddv.txt;"    'InitiateOAuth=REFRESH;'    'Edition=Sales;'    'IncludeLookUpLogicalName = true;')conn = mod.connect(conn_str)try:    cursor = conn.cursor()    cursor.execute("""       UPDATE table1         SET colum1 = 'sdsdds0299e3'         WHERE A = 110 AND B = 0    """)    # Get column names from description    columns = [col[0] for col in cursor.description]    print("Columns in gfwi_projects:")    for col in columns:        print(col)finally:    cursor.close()    conn.close()column 1 is a lookup column which refers to column 2 of table 2. when i run the python query. there is an error : column1 could not be updated. This column is read-only. please help

As of Version: 24.0.9190 of the CData Adobe Analytics Drivers, the following new report views have been added to the data model:UniversalReport: A universal report that includes every available dimension and metric. Predefined Report Views: A variety of common reports with predefined dimensions and metrics.This feature for the CData Adobe Analytics Drivers was added in the July 2025 driver release and allows Adobe Analytics users to dynamically query prebuilt reports of their Adobe Analytics data.Read more about the new report views and how to use them here:New Adobe Analytics Views

Hey CData Community!If you've installed the CData Excel Add-In but don’t see the CData tab, this quick guide will help you bring it back. From enabling the add-in and retrieving the necessary tables from your preferred data source, it’s all covered.To know more, refer to this article: How to Resolve the Issue of a Missing CData Tab in Excel.

Action Required: This update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted.SummaryWe are notifying CData customers of critical changes to NetSuite SuiteQL Schema due to NetSuite's migration from netsuite.com to netsuite2.com. Multiple objects have been deprecated, potentially affecting your data connectivity operations.Impact Level: High Affected Schema: SuiteQL only Unaffected Schema: SuiteTalkRead more here: https://www.cdata.com/kb/entries/netsuite-suiteql-schema-changes.rst