Recently active topics

CData ODBC drivers connect your data to any database management tool that supports Open Database Connectivity (ODBC). This includes many of the most popular productivity tools, adding new capabilities for document sharing and collaboration. Using the CData ODBC driver for Google Calendar, you can update live Google data in Microsoft Access; for example, you can make updates to a calendar that can instantly be seen by other users.Create a Google DSNIf you have not already, you will need to save Google connection properties in a data source name (DSN). Microsoft Access will use the DSN to connect. You can create and configure a DSN in the Microsoft ODBC Data Source Administrator. For a guide to set the required properties in the ODBC Data Source Administrator, see the "Getting Started" section in the help documentation.Create a Linked Table to Google Calendar EventsFollow the steps below to create a linked table to Google Calendar Events.In Access, click New Data Source > From Other S

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. 

I am looking for a person/company to help me setup the ODBC for Rest driver for a specific site.  Any recommendations?

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

We are experiencing inconsistent delete replication behavior when syncing a very small and stable ServiceNow table (≈10 rows) into SQL Server using CData Sync v26.Despite following all recommended configurations and upgrading both Sync and the ServiceNow driver, record deletions in ServiceNow are occasionally not detected by CData Sync, resulting in extra rows remaining in the SQL destination.This has caused incorrect data to appear in executive-level dashboards, impacting trust in reporting. Observed BehaviorRecords are deleted in ServiceNow No incremental sync runs successfully with no errors The deleted records remain in SQL Server Dashboard shows more rows than exist in ServiceNow Manual SQL cleanup is required to restore accuracyExample:Source (ServiceNow): 8 rows Target (SQL): 10 rows The extra 2 records no longer exist in ServiceNowExpected BehaviorDeleted records in ServiceNow should be reliably removed in SQL Sync behavior should be consistent regardless of table sizeWhat We H

After upgrading to the latest version of CPQ in salesforce the DBAMP software started sending tens of thousands of API calls to the platform.There are no sync jobs running, there are no daemon sessions in task manager.I cant figure out what is consuming all fo these API calls.

A common form of authentication used in SFTP transfers is Public Key authentication. In this form of authentication, the SFTP client creates a public and private key pair, and shares the public key with the SFTP Server admin. When authenticating, the SFTP client sends a small message signed with its private key that is verified by the server. This form of authentication is generally considered stronger than password authentication.  One of the most common tools for creating the key pair is through a free tool called PuTTYgen, which allows the user to create a new key pair:   Solution: Yes, key pairs generated via PuTTYgen can be used for both public key authentication from the client perspective in the SFTP connector and to authenticate inbound clients using the SFTP Server connector in CData Arc.  Public Key Authentication in client-side connections (SFTP connector)  To use a private key generated in PuTTYgen as your Client Certificate for public key authentication in an SFTP client, 

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

Hi Everyone, I'm Soumitra Dutta – Entrepreneur & Photographer Based in Oxford. I’m trying to connect my database to CData, but I’m not sure of the best approach. Could anyone share their tips, recommended connectors, or best practices for setting up a connection efficiently? I’d really appreciate your advice! RegardsSoumitra Dutta 

Hello,I just recently migrated my Arc instance to a new server.  I had been running v2023 with the old UI and I’m trying to figure out how I can ‘move’ my EDI connections (which are currently spread out across multiple workspaces) to the new Trading Partner Console.  Any help is appreciated.Thanks!