Recently active topics

In CData Sync API connector with Bearer token authentication, currently it's not possible to provide and configure an endpoint from which a new token can be acquired. What are the other possible ways then to update the token dynamically then? This thread discusses a solution in CData Arc but I am not sure if that will be applicable here in CData Sync.This another thread discusses adding a manual bearer token in custom header for CData Sync, but how can the token value be updated dynamically?Is it possible to acquire the token in the Pre-Job event and then set it as an environment variable? Are environment variables (set up in the Pre-Job event) accessible in the Connection configuration?

Connecting LibreOffice to a CData JDBC connector is a relatively smooth process that can be done in just a few steps. In this walkthrough I will be using the WooCommerce JDBC connector.  First, launch LibreOffice and in the top left, navigate from Tools -> Options -> LibreOffice -> Advanced, and ensure Libre has access to your 64 bit java run time environment installed on your machine.   Click “Add” in the top right, and navigate to JRE’s installed directory, which defaults to C:\Program Files\Java\jre<jre version here>    Next, we must let Libre know where the CData JDBC driver is by adding a Class Path on that same advanced settings page.  Click “Add Archive…” and navigate to the driver’s jar file. The driver installer defaults to something like C:\Program Files\CData\CData JDBC Driver for WooCommerce 2025\lib\cdata.jdbc.woocommerce.jar Click “Ok” on the Class Path window, apply the Advanced Settings changes we made and then click “Ok” again.      The next step is defi

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