Recently active topics

Single Sign-On (SSO) with Azure Active Directory (Azure AD) improves security, simplifies access management, and enhances the login experience for CData API Server users. By integrating Azure AD using the OpenID Connect (OIDC) standard, users can authenticate using corporate credentials while API Server securely validates identity tokens issued by Azure AD.  Overview  CData API Server supports Single Sign-On (SSO) via the OpenID Connect (OIDC) standard. Identity providers that implement OpenID, such as Azure Active Directory, can be configured as the SSO platform for API Server.  Once SSO is configured: - Users are redirected to Azure AD for authentication - Azure AD issues a signed JWT token - API Server validates the token signature and issuer - Users are authenticated using a Federation ID mapping  Note: Currently, API Server supports only individual users, not groups of users. If an SSO platform provides access for a group of users, each individual user within that group must be ad

A common challenge that can be encountered in mapping projects occurs when a data source contains element that can be grouped into multiple transactions, but the format of the data is in a flatten data model. A simple example of this can be seen in many CSV files: OrderNumber Customer Date Item Qty 12345 James Blasingame 3/17/23 Corned Beef 1 12345 James Blasingame 3/17/23 Colcannon 1 12346 Teddy Blasingame 3/17/23 Peanut Butter 1 12346 Teddy Blasingame 3/17/23 Apples 2   With the human eye, it is easy to tell that this table represents two separate transactions, each of which contains 2 line items (Orders 12345 and 12346) - but there is nothing in the CSV itself that indicates that this relationship is in place, and this information is understood by the user that is managing the file.  The CSV Connector in CData Arc can convert this into an XML structure for mapping. When doing this, it is best to configure the CSV connector so that the Con

Hello,My department uses the CData API Server for OData connections. We’re currently on software version  23.0.8844.0, and it appears the current release is 25.3.9411. Is there a changelog available to show the differences, so we can assess when to upgrade?Additionally, I am unable to find the installation package for the API Server on the website. https://www.cdata.com/download/ does not appear to list it.Ideally it would be in a location our deployment scripting could pull from with wget.Thanks!-John Horton

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

A new year brings new capabilities! We’re excited to kick off 2026 with one of our largest CData Sync releases yet, this Q1 roll out is packed with enhancements designed to give you more flexibility, control, and power across your data pipelines. Here’s what’s new in Sync Q1 2026: ❄️ Apache Iceberg Destination Support CData Sync now supports the Iceberg file format and catalog, enabling modern lakehouse architectures with open, reliable table formats. Iceberg destinations are now available for:  Amazon S3  Azure Blob Storage  Azure Data Lake Storage  Google Cloud Storage  🚦 Visual Pipelines in the UI We’re excited to preview Pipelines, an upcoming point-and-click UI experience for managing job and event dependencies in Sync. Pipelines will make it easier than ever to orchestrate and visualize Sync workflows.🔄 CDC Catalog Enhancements: SAP HANA We’ve expanded our CDC catalog with Enhanced CDC (ECDC) support for SAP HANA, making it easier to capture and replicate changes from one of

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) — Extended context windows and strong reasoning Gemini (Google) — Deep Google Workspace integration Grok (xAI) — Real-time data and unique training approachEach evaluation includes verified benchmark data, integration patterns, compliance frameworks, and model selection guidance to help you match the right LLM to your use case.Have questions or want to share your experience with a specific model? Drop a comment below!

Do you have some step-by-step instructions for creating & using a data cache with Embedded Cloud’s Job API?  

I want to improve the performance of some queries I am running to the Query API. What are some suggestions on when to use the Job API to cache data in CData Embedded Cloud?

Hi,I’m trying to use Sync to replicate data from Salesforce into a Postgres database.  I have a full load working, and every night it truncates then reloads the tables.I’m having a lot of problems setting up another job that then runs an incremental update periodically.  It seems straightforward to set up.  My jobs incremental settings are:Start Date:  2026-01-06 Replication Interval : 1 dayWhen I run the job, I consistently get the same error, regardless of which Salesforce object I try to incrementally update.  In this case my source is Building__c, and the destination is the Postgres table salesforce.building. The error I get is:  [0] Updating Row is failed. ERROR: Server error [SQL state: 42P01]: relation "salesforce_building__r_1329269084" does not exist (Character 13) , AffectedCount: 0I can’t find any mention of this type problem in the documentation, and have followed all the steps in the docs to set this up.Has anyone else encountered something like this, or perhaps have an id

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