Live Connectivity

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

AWS RDS for SQL Server simplifies backups, patching, and high availability, but its managed model restricts certain administrative actions — including creating linked servers through the SSMS UI.If you see errors like “The requested dialog cannot be displayed” or “You must be a member of the sysadmin role”, this is expected. AWS RDS does not provide full sysadmin access, so linked servers must be created using supported system stored procedures.This article shows how to create linked servers in AWS RDS, query and update remote data, and extend linked servers to SaaS and cloud sources using CData.👉 Read the full article:https://www.cdata.com/kb/articles/aws-rds-linked-server.rst

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

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

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

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

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

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

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

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

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

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

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

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: