Live Connectivity

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

Hey CData Community! We’re excited to share that CData Connect Cloud is now CData Connect AI 🎉. This update brings a new name and fresh AI capabilities, while keeping everything you already rely on exactly the same. Here’s the quick breakdown: ✨ What’s New: 🤖 AI-ready out of the box 🔗 Support for Model Context Protocol (MCP) ⚡ Seamless integration with tools like ChatGPT, Claude, Copilot & Crew AI ✅ What Stays the Same: 🔒 Your connectors, credentials & datasets ⚙️ Your configurations & pricing 🛠️ The same trusted platform experience So it’s business as usual — only now smarter, faster, and ready for the AI era. Check out the full announcement here: https://www.cdata.com/blog/connect-cloud-is-connect-ai  

We’re extremely excited at CData to announce the launch of our newest product today, Connect AI! As a data connector company, it has always been our mission to provide the best available connectivity wherever it’s needed. Over the past year, the introduction of Model Context Protocol (MCP) for AI has created a wave of demand for AI data connectivity we are excited to meet. Connect AI is a first-of-its-kind managed Model Context Protocol (MCP) platform to build, manage, and scale data connections for AI. Generate responses from AI that:  Are more accurate  Grounded in real business data  Turn AI from cool demo to critical business copilot.  The platform provides all the governance and security controls that businesses need to feel safe connecting AI to actual data. Getting set up is easy – most sources only need a login. Querying real data from AI can take a matter of minutes. Lea

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

CData Connect Cloud makes it simple to manage your subscription through self-service directly in the platform. If you have signed up for a trial and wish to cancel, you can complete the process from your own account. Follow the steps below to complete the cancellation process. Step 1: Log in to your account  Go to https://cloud.cdata.com/.  Enter your registered email and password to sign in.    Step 2: Open the settings page  From the left-hand navigation panel, click on Settings.  Under Settings, select Billing. 

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

CData Connect AI provides a unified, secure platform for accessing real-time data across hundreds of sources. With features like Derived Views, Saved Queries, and Custom Reports, you can shape, reuse, and present data seamlessly without complex coding or manual exports.In Connect AI, you can:Build Derived Views to create new perspectives on existing data. Save frequently used queries with Saved Queries for efficiency and consistency. Generate Custom Reports that transform complex datasets into actionable insights.To learn more, read: How to Create Derived Views, Saved Queries, and Custom Reports in CData Connect AI

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.

After wrestling with this issue to download / refresh over 140k rows of data daily I believe the problem is pivot tables embedded in the same workbook.  After downloading data and creating pivot tables the data would time out on any overwrite or refresh.  But…. if I use Queries then the issue does not seem to occur.  

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

Are you looking to connect to your Tesla data? Our latest article covers how to connect to the Tesla Fleet API with the CData Connect AI API Connector, including environment setup, authentication, and retrieving data like location, charge status, and more.Read the full article: https://www.cdata.com/kb/articles/tesla-api.rst  Let us know if you’re building something cool with Tesla data!

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