Live Connectivity

Skip the custom connector. The CData API Driver pulls REST API data directly into Power BI in a few steps.For more information, refer to: How to Connect API Data Sources to Power BI Using CData API Driver

ジャパンシステム株式会社 真砂と申します。弊社は国内総代理店であるNTTドコモビジネスX社の代理店としてお客様へTDVを購入していただいております。TDVではいくつかのドライバをサポートしている旨、ガイドなどに記載されていますが、一般的なjdbcドライバなどは製品元へ問い合わせするものであり、ドライバの使用についてはユーザ(お客様)の都合によるためお客様より各ドライバのベンダー様へ問い合わせるものと認識しております。CData製ドライバにおいても下記記載があったため「NOTE: CData offers standard, email-based technical support for the TIBCO DV Adapters listed below. Priority email and phone support is available for an additional fee.」ご利用においても、利用ユーザ様ご自身でダウンロードされ、使用されておりましたので、標準のサポートであれば利用ユーザの会社よりお問合せいただければと思っておりました。今回、お客様よりお問合せいただいた件についてCData Software Japanの出村様より、お客様からは弊社へ問い合わせするようにと案内されたとのことなのですが、その際有償サポートの内容が記載されていました。代理店から購入したTDVへの質問に際してお客様から弊社へ問い合わせは理解できるのですが、CDataのドライバについてはお客様が必要に応じて利用されるものであり、今回弊社ではTDVのご購入はあるものの、お客様の環境を管理しているわけではありません。とりあえず、TDVの購入経路について、代理店経由であれば、CDataのドライバに関してもお客様->弊社へご質問いただくとして、その後の二次サポート先として、弊社->CDataへ問い合わせするということはNGでしょうか？上記文面の「標準サポート」とはどの範囲のものになるのでしょうか？

Hey CData Community!We recently put together a step-by-step guide for deploying CData API Server V25 in a production-grade high-availability setup on AWS, covering the full stack: dual EC2 instances sharing an RDS configuration store, an Application Load Balancer handling HTTPS termination, TLS via ACM, and DNS through Route 53.Each step includes the why, not just the how — so you understand the architecture decisions before you commit to them.If you're planning a serious API Server deployment or want to harden an existing one, this is a solid starting point.Read the full article here: https://www.cdata.com/kb/articles/apiserver-v25-aws-high-availability.rst

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 

Microsoft is retiring the built-in Salesforce connector in Access, which may disrupt existing workflows and break live connections to Salesforce data.To maintain connectivity, teams can switch to ODBC-based solutions like CData, allowing them to continue using their existing Access queries, reports, and applications with minimal changes.In this article, you’ll learn how to:Understand the impact of the connector discontinuation Maintain Access workflows without disruption Replace the built-in connector with a CData solution Restore live Salesforce connectivityTo learn more, read:How to Keep Microsoft Access Working After the Salesforce Connector Discontinuation

Migrating to cloud ERPs like Acumatica, NetSuite, or Business Central often removes direct SQL access, disrupting Microsoft Access-based workflows many finance teams rely on.Since SaaS ERPs use API-only architectures, traditional database connections no longer work. CData ODBC Drivers bridge this gap by enabling seamless connectivity from Access to cloud ERP data without major changes to your existing files or queries.In this article, you’ll learn how to:Navigate the shift from SQL to API-based ERP systems Maintain Access workflows after cloud migration Connect Access to cloud ERP data using CData ODBC Drivers Continue using existing queries with minimal modificationsTo learn more, read:How to Keep Microsoft Access Working After an ERP Cloud Migration

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

Tired of broken NetSuite schema replication in Microsoft Fabric?Learn how the CData JDBC Driver solves connector limitations and ensures accurate, complete data replication.Read the full guide: Resolving NetSuite Schema Replication Failures in Microsoft Fabric using CData

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