# CData Sync **URL:** https://community.cdata.com/c/data-integration/cdata-sync/36.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the CData Sync category](https://community.cdata.com/t/about-the-cdata-sync-category/1466)
**Author:** [@system](https://community.cdata.com/u/system)\ **Replies:** 0\ **Last updated:** [October 21, 2026, 3:35pm UTC](https://community.cdata.com/t/about-the-cdata-sync-category/1466 "2026-10-21T15:35:18Z")
Share product questions and get support for CData Sync --- ## [Cdata Sync Alter Schema enabled but allow user to set target data type](https://community.cdata.com/t/cdata-sync-alter-schema-enabled-but-allow-user-to-set-target-data-type/1330)
**Author:** [@MarchPhone35](https://community.cdata.com/u/MarchPhone35)\ **Replies:** 1\ **Last updated:** [September 29, 2026, 9:01pm UTC](https://community.cdata.com/t/cdata-sync-alter-schema-enabled-but-allow-user-to-set-target-data-type/1330 "2026-09-29T21:01:10Z")
Hey All, I’d like to enable cdata sync’s alter schema feature. However, I want to set any newly discovered columns in the source table to a string data type in the target table. I’d also like to Alter schema to not ch… --- ## [CDC/CT required for Sync All or Alter Schema?](https://community.cdata.com/t/cdc-ct-required-for-sync-all-or-alter-schema/1324)
**Author:** [@josncmar](https://community.cdata.com/u/josncmar)\ **Replies:** 1\ **Last updated:** [August 14, 2026, 11:46am UTC](https://community.cdata.com/t/cdc-ct-required-for-sync-all-or-alter-schema/1324 "2026-08-14T11:46:27Z")
I’m using CData Sync with a SQL Server source in a Standard job (incremental check column, no CDC or CT enabled). If a new column is added to a source table, will Sync automatically detect and add it to the destination o… --- ## [Sync - S3 Destination - specifying subfolders and file naming options](https://community.cdata.com/t/sync-s3-destination-specifying-subfolders-and-file-naming-options/1322)
**Author:** [@mikelucito](https://community.cdata.com/u/mikelucito)\ **Replies:** 0\ **Last updated:** [July 31, 2026, 3:03pm UTC](https://community.cdata.com/t/sync-s3-destination-specifying-subfolders-and-file-naming-options/1322 "2026-07-31T15:03:04Z")
We’re currently testing the S3 destination for various sources using CSV file format and would like to be able to do 2 things: Specify a subfolder per job or task Append the table name to the destination file for exam… --- ## [CData Sync pipeline - introduce sleep/delay](https://community.cdata.com/t/cdata-sync-pipeline-introduce-sleep-delay/1312)
**Author:** [@Rajesh](https://community.cdata.com/u/Rajesh)\ **Replies:** 2\ **Last updated:** [July 29, 2026, 12:36pm UTC](https://community.cdata.com/t/cdata-sync-pipeline-introduce-sleep-delay/1312 "2026-07-29T12:36:14Z")
Is there a way to introduce a delay between steps in a CData Sync Pipeline? We have a limitation from a source API and need to ensure we delay our API requests by 15 seconds between calls, hence looking to add this delay… --- ## [CData Sync 26.3 Is Here: Upgraded Pipelines, Faster Writes, and More](https://community.cdata.com/t/cdata-sync-26-3-is-here-upgraded-pipelines-faster-writes-and-more/1317)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [July 23, 2026, 4:56pm UTC](https://community.cdata.com/t/cdata-sync-26-3-is-here-upgraded-pipelines-faster-writes-and-more/1317 "2026-07-23T16:56:01Z")
The July release of CData Sync is live, and this one has a few changes that will make your day-to-day noticeably smoother. Here’s what’s new in this release: :green\_circle: Kafka just got a lot easier to set up If you… --- ## [CData Sync Pipeline - stuck on Canceling](https://community.cdata.com/t/cdata-sync-pipeline-stuck-on-canceling/1314)
**Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\ **Replies:** 1\ **Last updated:** [July 16, 2026, 2:38pm UTC](https://community.cdata.com/t/cdata-sync-pipeline-stuck-on-canceling/1314 "2026-07-16T14:38:19Z")
We have been testing with the new pipelines but we ran into an issue A pipeline got canceled and now its stuck on canceling status. Its now impossible to start or delete or the pipeline. We can remove items out of … --- ## [Environment Variable Not Resolving for ReplicateStartDate](https://community.cdata.com/t/environment-variable-not-resolving-for-replicatestartdate/1306)
**Author:** [@SrilathaSeshadri](https://community.cdata.com/u/SrilathaSeshadri)\ **Replies:** 1\ **Last updated:** [June 23, 2026, 10:11am UTC](https://community.cdata.com/t/environment-variable-not-resolving-for-replicatestartdate/1306 "2026-06-23T10:11:28Z")
We upgraded to the latest version of the CDATA last weekend. After that tasks that use environment variables for the ReplicateStartDate property are currently failing. Current Configuration Pre job event \ **Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [May 6, 2026, 6:14pm UTC](https://community.cdata.com/t/whats-new-in-cdata-sync-26-2/1291 "2026-05-06T18:14:38Z") CData Sync 26.2: Git Version Control, Performance boosts, ClickHouse destination & more… We’re excited to share the 26.2 release of CData Sync, packed with new capabilities that give you more control, performance, and fl… --- ## [ServiceNow → SQL Sync: Deletes Not Always Detected on Small, Stable Table](https://community.cdata.com/t/servicenow-sql-sync-deletes-not-always-detected-on-small-stable-table/1276)
**Author:** [@marodsal](https://community.cdata.com/u/marodsal)\ **Replies:** 2\ **Last updated:** [March 25, 2026, 1:34pm UTC](https://community.cdata.com/t/servicenow-sql-sync-deletes-not-always-detected-on-small-stable-table/1276 "2026-03-25T13:34:34Z")
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 up… --- ## [Dynamic bearer token refresh for CData Sync API connector with bearer token authentication](https://community.cdata.com/t/dynamic-bearer-token-refresh-for-cdata-sync-api-connector-with-bearer-token-authentication/1270)
**Author:** [@CJIW](https://community.cdata.com/u/CJIW)\ **Replies:** 0\ **Last updated:** [February 20, 2026, 5:39pm UTC](https://community.cdata.com/t/dynamic-bearer-token-refresh-for-cdata-sync-api-connector-with-bearer-token-authentication/1270 "2026-02-20T17:39:47Z")
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 t… --- ## [❄️ Greetings from CData! ❄️ Sync Q1 2026 Release Highlights ](https://community.cdata.com/t/greetings-from-cdata-sync-q1-2026-release-highlights/1265)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [January 20, 2026, 7:35pm UTC](https://community.cdata.com/t/greetings-from-cdata-sync-q1-2026-release-highlights/1265 "2026-01-20T19:35:00Z")
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 a… --- ## [Sync incremental update error](https://community.cdata.com/t/sync-incremental-update-error/1259)
**Author:** [@CRuybal](https://community.cdata.com/u/CRuybal)\ **Replies:** 0\ **Last updated:** [January 9, 2026, 8:36pm UTC](https://community.cdata.com/t/sync-incremental-update-error/1259 "2026-01-09T20:36:33Z")
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 … --- ## [How to enable CData SQL Server Connections as Destination Connections for Jobs within CData Sync](https://community.cdata.com/t/how-to-enable-cdata-sql-server-connections-as-destination-connections-for-jobs-within-cdata-sync/1249)
**Author:** [@matthewr](https://community.cdata.com/u/matthewr)\ **Replies:** 1\ **Last updated:** [December 4, 2025, 8:53pm UTC](https://community.cdata.com/t/how-to-enable-cdata-sql-server-connections-as-destination-connections-for-jobs-within-cdata-sync/1249 "2025-12-04T20:53:22Z")
When configuring a replication Job after creating a Connection to your SQL Server database, you may initially find that you are unable to utilize this Connection as a Destination. The Connection appears as intended when… --- ## [Configuring Clustering for CData Sync](https://community.cdata.com/t/configuring-clustering-for-cdata-sync/1243)
**Author:** [@Somya](https://community.cdata.com/u/Somya)\ **Replies:** 0\ **Last updated:** [December 1, 2025, 2:10pm UTC](https://community.cdata.com/t/configuring-clustering-for-cdata-sync/1243 "2025-12-01T14:10:21Z")
The CData Sync clustering feature allows multiple Sync installations to operate together as a single, scalable, and highly available environment. By distributing workloads across multiple nodes, clustering ensures contin… --- ## [How to Handle PostgreSQL Infinity Values Using CData Sync](https://community.cdata.com/t/how-to-handle-postgresql-infinity-values-using-cdata-sync/1242)
**Author:** [@Anusha\_M\_B](https://community.cdata.com/u/Anusha_M_B)\ **Replies:** 0\ **Last updated:** [November 27, 2025, 6:26am UTC](https://community.cdata.com/t/how-to-handle-postgresql-infinity-values-using-cdata-sync/1242 "2025-11-27T06:26:57Z")
Working with PostgreSQL data that includes “Infinity” values? Learn how to manage and sync these special values effortlessly using CData Sync. Our newest guide walks you through the necessary steps and best practices to … --- ## [Build AI-Ready Workflows with SQL Server 2025 and CData Sync](https://community.cdata.com/t/build-ai-ready-workflows-with-sql-server-2025-and-cdata-sync/1214)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [October 9, 2025, 5:47pm UTC](https://community.cdata.com/t/build-ai-ready-workflows-with-sql-server-2025-and-cdata-sync/1214 "2025-10-09T17:47:03Z")
Hey CData Community! Microsoft’s SQL Server 2025 brings AI into the heart of the database with new native vector support, enabling you to store, search, and analyze embeddings directly inside SQL Server. When paired wit… --- ## [🍂Greetings from CData!🍂 Sync Q3 2025 Release Highlights](https://community.cdata.com/t/greetings-from-cdata-sync-q3-2025-release-highlights/1199)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [September 23, 2025, 3:28pm UTC](https://community.cdata.com/t/greetings-from-cdata-sync-q3-2025-release-highlights/1199 "2025-09-23T15:28:35Z")
Fall is here and so is CData Sync’s Q3 2025 release! Our latest updates are designed to help you unlock more value from your data, faster and more efficiently. :high\_voltage: Enhanced CDC Catalog Expansion: You asked, w… --- ## [Comprehensive Workday Integration with CData Sync](https://community.cdata.com/t/comprehensive-workday-integration-with-cdata-sync/1158)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [August 8, 2025, 2:01pm UTC](https://community.cdata.com/t/comprehensive-workday-integration-with-cdata-sync/1158 "2025-08-08T14:01:25Z")
Most ETL/ELT tools provide connectivity to Workday; however, the connection is limited because it is only through Reports as a Service (RaaS). With the CData Sync Workday connector, users get more connection options, inc… --- ## [🚀 Summer Release is Here! Sync Q2 2025 Highlights ](https://community.cdata.com/t/summer-release-is-here-sync-q2-2025-highlights/1119)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [June 24, 2025, 7:27pm UTC](https://community.cdata.com/t/summer-release-is-here-sync-q2-2025-highlights/1119 "2025-06-24T19:27:18Z")
We’re excited to share the latest updates in CData Sync, now live with powerful new features designed to elevate your data integration experience: :repeat\_button: Microsoft Mirroring as a Destination In partnership wi… --- ## [Replicate Salesforce Data to SAP Datasphere with CData Sync](https://community.cdata.com/t/replicate-salesforce-data-to-sap-datasphere-with-cdata-sync/1113)
**Author:** [@user1](https://community.cdata.com/u/user1)\ **Replies:** 0\ **Last updated:** [June 17, 2025, 3:39pm UTC](https://community.cdata.com/t/replicate-salesforce-data-to-sap-datasphere-with-cdata-sync/1113 "2025-06-17T15:39:23Z")
Hey CData Community! Looking to bring your Salesforce data into SAP Datasphere without the headaches? Our latest post, Replicate Salesforce Data to SAP Datasphere with CData Sync, walks you through the full setup — from… --- ## [CData Sync - Change Tracking in Dynamics 365 Entities for CDC Replication](https://community.cdata.com/t/cdata-sync-change-tracking-in-dynamics-365-entities-for-cdc-replication/1110)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [June 17, 2025, 5:19am UTC](https://community.cdata.com/t/cdata-sync-change-tracking-in-dynamics-365-entities-for-cdc-replication/1110 "2025-06-17T05:19:34Z")
Hey CData Community! Manually enabling Change Tracking for every Dynamics 365 entity? That is a lot of effort. Good news. CData Sync can do it for you using a stored procedure. It automatically enables Change Tracking… --- ## [Enhanced CDC in CData Sync: How much faster is it?](https://community.cdata.com/t/enhanced-cdc-in-cdata-sync-how-much-faster-is-it/1108)
**Author:** [@user1](https://community.cdata.com/u/user1)\ **Replies:** 0\ **Last updated:** [June 13, 2025, 7:56pm UTC](https://community.cdata.com/t/enhanced-cdc-in-cdata-sync-how-much-faster-is-it/1108 "2025-06-13T19:56:18Z")
Hey CData Community! Just dropped: a quick deep-dive on the new Enhanced CDC feature in CData Sync • 9× faster replication (10 k changes: 6 s vs 54 s) • Always-on log reading + staging area = reduced wait at run time … --- ## [How to setup Incremental Replication](https://community.cdata.com/t/how-to-setup-incremental-replication/1106)
**Author:** [@BI-Mod](https://community.cdata.com/u/BI-Mod)\ **Replies:** 1\ **Last updated:** [June 12, 2025, 12:27pm UTC](https://community.cdata.com/t/how-to-setup-incremental-replication/1106 "2025-06-12T12:27:33Z")
Hi, I have 3 years worth of data. All the data stay the same but the latest 3 months are dynamic. I need to replace the old data with the latest data. But if I do “Drop Table”, it drops all the data and bring all 3 yea… --- ## [CData Sync Enhances Snowflake Integration with Optimized High Volume Data Handling](https://community.cdata.com/t/cdata-sync-enhances-snowflake-integration-with-optimized-high-volume-data-handling/1098)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [May 26, 2025, 8:35am UTC](https://community.cdata.com/t/cdata-sync-enhances-snowflake-integration-with-optimized-high-volume-data-handling/1098 "2025-05-26T08:35:09Z")
Hey CData Community! Moving large volumes of data into Snowflake just got a major performance upgrade. With the release of CData Sync version 24.3, high-volume data replication is now significantly faster and more effic… --- ## [Sync Kafka source and max rows](https://community.cdata.com/t/sync-kafka-source-and-max-rows/1067)
**Author:** [@JTapio](https://community.cdata.com/u/JTapio)\ **Replies:** 7\ **Last updated:** [April 10, 2025, 7:31am UTC](https://community.cdata.com/t/sync-kafka-source-and-max-rows/1067 "2025-04-10T07:31:28Z")
Hi, I have Sync version 24.3.9120.0 and I’m using Apache Kafka as source. It’s working fine, except little irritation. When I run task it will replicate only first 150 000 rows and stops after that. Next time I run the … --- ## [Sync – “\[0\] Failed to cache row \[XXXX\] null"](https://community.cdata.com/t/sync-0-failed-to-cache-row-xxxx-null/1064)
**Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\ **Replies:** 1\ **Last updated:** [March 26, 2025, 9:48am UTC](https://community.cdata.com/t/sync-0-failed-to-cache-row-xxxx-null/1064 "2025-03-26T09:48:52Z")
Since the update to Sync version 25.1.9207 we are getting some strange errors from different tasks. All these tasks worked without problems before the update. So far i have not found any difference (except for the t… --- ## [🌼 Greetings from CData! 🌼 CData Sync Q1 2025 Release Highlights](https://community.cdata.com/t/greetings-from-cdata-cdata-sync-q1-2025-release-highlights/1059)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [March 18, 2025, 5:21pm UTC](https://community.cdata.com/t/greetings-from-cdata-cdata-sync-q1-2025-release-highlights/1059 "2025-03-18T17:21:54Z")
Spring is here, bringing fresh updates to CData Sync! Our latest enhancements are designed to streamline your data integration and management, helping you bloom with efficiency this season: :open\_file\_folder: Workspaces… --- ## [dbt Transformations with CData Sync](https://community.cdata.com/t/dbt-transformations-with-cdata-sync/1054)
**Author:** [@Cameron\_L](https://community.cdata.com/u/Cameron_L)\ **Replies:** 0\ **Last updated:** [March 14, 2025, 2:53pm UTC](https://community.cdata.com/t/dbt-transformations-with-cdata-sync/1054 "2025-03-14T14:53:53Z")
CData Sync supports the execution of ELT processes flexibly using dbt Core or dbt Cloud. This integration gives users complete control over defining and executing complex data transformation workflows in dbt, while CData… --- ## [CData Sync - Loading/Replicating data in a looping batch](https://community.cdata.com/t/cdata-sync-loading-replicating-data-in-a-looping-batch/1022)
**Author:** [@David\_Foster](https://community.cdata.com/u/David_Foster)\ **Replies:** 1\ **Last updated:** [March 12, 2025, 7:15pm UTC](https://community.cdata.com/t/cdata-sync-loading-replicating-data-in-a-looping-batch/1022 "2025-03-12T19:15:07Z")
Hi there. Is there a way of replicating data in batches. We are looking at a lambda approach with small incremental replication, followed up with a weekly full reload to catch late-arriving data and physical/hard delet… [Next page](https://community.cdata.com/c/data-integration/cdata-sync/36.md?page=1)