CData Connect AI

Hi everyone, I’m Soumitra Dutta, an Oxford-based entrepreneur and photographer. Glad to be here! I’m running into some syntax issues while working with CData drivers and was hoping to get your advice.Some of my queries are either throwing errors or not behaving as expected, especially when using things like JOINs, filters, or ORDER BY clauses.Would really appreciate any suggestions or examples from your experience.RegardsSoumitra Dutta 

Just discovered CData Connect Spreadsheets when searching for a way to get Google Calendar information into Excel. Looks very good.However, when test-driving the software, I run into an issue.I have a primary calendar under my Google Workspace account [removed by moderator] . In addition, I have created multiple secondry calendars for various purposes.I've successfully connected the addin to my account, including successful authentication. When I start the Import process, I can select the configured connection, and the Table list populates with all available tables, including all calendars. When I select one of the secondary calendars, such as 'Placeholders' or 'Flags', the column list is loaded, the generated query is created, and the Execute/Reset buttons become available (see 2nd screenshot). When I hit Execute, the Excel list is populated with data from the selected calendar. All as expected.But when I select my primary calendar [removed b

Hi Everyone, I am Dheeraj Sudan , a UK-based software developer. I’m running into OAuth token authentication errors when trying to connect GA4 and a few APIs through CData. I’ve double-checked my client ID, secret, and redirect URIs, but the connection still fails. Has anyone experienced this before? Any tips or steps to troubleshoot and fix these authentication issues would be greatly appreciated! RegardsDheeraj Sudan and Meenu Hinduja 

You can now build custom MCP tools directly in Connect AI for agentic workflows.With Custom Tools, each operation is pre-defined with scoped inputs, validated logic, and structured output. This means your AI takes action on your terms — consistently, across every team that uses it. 

Connect Supabase to CData Connect AI to give AI tools secure, live access to your data—no SQL, no pipelines.What you can do:Query Supabase using natural language (ChatGPT, Claude, Copilot, MCP agents) Write back to your database without direct SQL access Query across 350+ connected data sources in a single request Maintain governed, real-time access to your dataRead the full guide: https://www.cdata.com/kb/articles/cloud-supabase.rst

ChatGPT encompasses multiple OpenAI model families including GPT-5, GPT-4.1, and o-series reasoning models designed to support natural language queries and tool-based data access. Integrated with CData Connect AI, ChatGPT enables secure, real-time enterprise data connectivity while maintaining compliance and governance standards.In this article, you'll learn how to:Understand ChatGPT's model families and enterprise capabilities Leverage native tool calling for seamless data access workflows Integrate ChatGPT with CData Connect AI for secure connectivity Navigate authentication, rate limits, and compliance requirements Implement multi-step analytics workflows with automated SQL generationTo learn more, read:Know Your LLM (Series): ChatGPT

Hi, CData team,  we found that the following query text stops works from 2025/1/26.SELECT [[char\]] FROM [SQL_KrewTestDB].[krewtestdb].[bug2149] LIMIT 500My table as following, the data source is My SQL. You can see that the column name is [char], it has the special char “[”, “]”, before it works well, but from 2025/1/26, it stop working. 

Choosing the right LLM for your enterprise data workflows just got easier.We've published a new Know Your LLMs series in our Knowledge Base—comprehensive technical evaluations of the leading AI models for integration with CData Connect AI. Each article covers architecture, API specifications, function calling capabilities, security posture, and deployment guidance.The series includes:Mistral AI — EU-hosted, open-weight models with native Le Chat MCP support ChatGPT (OpenAI) — GPT-4o and the industry's largest ecosystem Claude (Anthropic) — Ex

AI-driven analytics can be slow and costly when LLMs repeatedly rebuild schemas and relationships across multiple data sources. Derived Views with CData Connect AI eliminate that overhead, reducing token usage while making multi-source analytics faster and more reliable at scale.Read the full article here: https://www.cdata.com/kb/articles/connect-ai-derived-views-performance.rst

Hey CData Community!Tired of Claude guessing your schema wrong?Give it a brain upgrade with Claude Projects + CData Connect AI.We put together a quick guide on teaching Claude your database layout so it stops hallucinating columns and starts writing clean, accurate queries. It’s simple, it’s powerful, and honestly… it feels like giving Claude glasses. 🤓Check it out here: https://www.cdata.com/kb/articles/claude-projects.rst

Want to build intelligent agents that can query live enterprise data — no replication, no ETL, just governed, real-time access?CData Connect AI and IBM watsonx Orchestrate make it possible in minutes.What you can do Connect watsonx Orchestrate directly to 350+ data sources through CData’s MCP server. Use secure, governed SQL access — your data never leaves its source. Build agents that query, summarize, and act on real-time data. How it works Add your data connection in CData Connect AI. Link it in IBM watsonx Orchestrate using a secure Key-Value connection. Import CData MCP toolkits via the ADK CLI and start building workflows.   Try the tutorial for your platform

Learn how to bring live, conversational data insights directly into Microsoft Teams using Microsoft Copilot Studio and CData Connect AI. This guide walks through deploying Copilot Studio agents to Teams and connecting them securely to enterprise data via the Connect AI Remote MCP Server. With CData Connect AI, you can query and act on live data for smarter business interactions; no replication required.Read the full article here: https://www.cdata.com/kb/articles/cloud-copilot-teams.rst

We’re excited to announce our first-ever CData Connect AI Hackathon! 🎉 This is your chance to show off the coolest, most impactful AI use cases using CData Connect AI and MCP-enabled AI tools to connect live enterprise data to your agents, assistants, and copilots. Anyone can enter and win – Connect AI only takes minutes to set up.  Kickoff: September 24, 2025  Submission Deadline: October 31, 2025  How it works  Build your solution  Use CData Connect AI to connect at least one live enterprise data source.  Integrate with any MCP-enabled AI agent, assistant, or copilot.  Create something that’s innovative, practical, or just plain fun!  Submit your entry below  Post in thi

https://www.cdata.com/cloud/   Try it free, but it gives Error 500, please take a look.

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 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. 

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

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.  

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!

Hello CData Community! Are you looking to connect to your Tesla vehicle data? Our latest article shows you how to connect using the Tesla Fleet API, 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!

Since this morning at 08.00 we have problems with the Cdata Driver Connector for Power BI. This error is from Power BI Desktop I tried to recreate the connection, but without success.  

I am trying to setup Connect Spreadsheets to Sage One (renamed to Sage Business Cloud Accounting) but when I want to setup the authentication via the basic setup I don’t get South Africa as a region and can therefor not authenticate to our company in Sage. Any assistance would be appreciated.