# \#cdata-sync **URL:** https://community.cdata.com/tag/cdata-sync/86.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [How Should PII Be Handled in AI Data Pipelines?](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1336)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 5\ **Last updated:** [November 11, 2026, 10:10am UTC](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1336 "2026-11-11T10:10:43Z")
As businesses connect AI applications with databases, APIs, and other enterprise data sources, how should personally identifiable information (PII) be handled throughout the data pipeline? Sensitive information can appe… --- ## [Should Sensitive Data Be Anonymized Before Reaching an LLM?](https://community.cdata.com/t/should-sensitive-data-be-anonymized-before-reaching-an-llm/1334)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 2\ **Last updated:** [November 11, 2026, 9:59am UTC](https://community.cdata.com/t/should-sensitive-data-be-anonymized-before-reaching-an-llm/1334 "2026-11-11T09:59:56Z")
As more businesses connect AI tools with live databases, documents, APIs, and other enterprise data sources, I think an important question is where privacy protection should happen. If a retrieved record contains names,… --- ## [How Should PII Be Handled in AI Data Pipelines?](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1335)
**Author:** [@rom\_c](https://community.cdata.com/u/rom_c)\ **Replies:** 0\ **Last updated:** [October 8, 2026, 8:33am UTC](https://community.cdata.com/t/how-should-pii-be-handled-in-ai-data-pipelines/1335 "2026-10-08T08:33:31Z")
As businesses connect AI applications with databases, APIs, and other enterprise data sources, how should personally identifiable information (PII) be handled throughout the data pipeline? Sensitive information can appe… --- ## [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:** [@david.oraz](https://community.cdata.com/u/david.oraz)\ **Replies:** 0\ **Last updated:** [June 15, 2026, 10:19pm UTC](https://community.cdata.com/t/dbamp-refreshall-job-intermittent-failures-after-hyperforce-migration/1303 "2026-06-15T22:19:21Z") We are experiencing intermittent failures with DBAmp RefreshAll jobs across random tables following our Hyperforce migration. We engaged DBAmp Support, and their analysis indicates that the HTTP callouts are occasionall… --- ## [What's New in CData Sync 26.2](https://community.cdata.com/t/whats-new-in-cdata-sync-26-2/1291)
**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… --- ## [Sage Intacct Job Configuration Best Practices](https://community.cdata.com/t/sage-intacct-job-configuration-best-practices/1260)
**Author:** [@noebrown](https://community.cdata.com/u/noebrown)\ **Replies:** 0\ **Last updated:** [January 12, 2026, 4:17pm UTC](https://community.cdata.com/t/sage-intacct-job-configuration-best-practices/1260 "2026-01-12T16:17:30Z")
The following is intended for jobs that use Sage Intacct as a source connection. Prerequisites Before configuring any Sage Intacct replication job, verify the following in the tables/tasks of your job. You can verify ea… --- ## [Sync: Configure SAML based SSO](https://community.cdata.com/t/sync-configure-saml-based-sso/1255)
**Author:** [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\ **Replies:** 0\ **Last updated:** [December 19, 2025, 8:47pm UTC](https://community.cdata.com/t/sync-configure-saml-based-sso/1255 "2025-12-19T20:47:25Z")
Configuring SAML-Based Single Sign-On (SSO) with Microsoft Entra ID for CData Sync With SAML-based Single Sign-On (SSO), users can seamlessly authenticate through their organization’s identity provider (IdP), enabling s… --- ## [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 … --- ## [CData Product Updates Q3 2025](https://community.cdata.com/t/cdata-product-updates-q3-2025/1237)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [November 13, 2025, 7:37pm UTC](https://community.cdata.com/t/cdata-product-updates-q3-2025/1237 "2025-11-13T19:37:44Z")
CData Product Updates Newsletter This quarter’s CData update is a little different. Instead of separate newsletters for each product, we’re sharing one combined view across the entire CData portfolio. --- ## [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… --- ## [LDAP Authentication Setup in CData Sync with ApacheDS](https://community.cdata.com/t/ldap-authentication-setup-in-cdata-sync-with-apacheds/1192)
**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\ **Replies:** 0\ **Last updated:** [September 18, 2025, 3:43pm UTC](https://community.cdata.com/t/ldap-authentication-setup-in-cdata-sync-with-apacheds/1192 "2025-09-18T15:43:36Z")
This article explains LDAP authentication and how to set it up with an ApacheDS on-premises server. What is LDAP? LDAP (Lightweight Directory Access Protocol) is an open, vendor-neutral, industry-standard application p… --- ## [How to access the Derby Database in CData Sync AMI Edition](https://community.cdata.com/t/how-to-access-the-derby-database-in-cdata-sync-ami-edition/1185)
**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\ **Replies:** 0\ **Last updated:** [September 11, 2025, 9:05pm UTC](https://community.cdata.com/t/how-to-access-the-derby-database-in-cdata-sync-ami-edition/1185 "2025-09-11T21:05:49Z")
In this article, we will demonstrate how to install the Derby database engine and how to connect to the Sync application database in the AMI edition. Warning: Modifying the application database directly may cause un… --- ## [CData Product Updates Q3 2025](https://community.cdata.com/t/cdata-product-updates-q3-2025/1168)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [September 3, 2025, 11:38am UTC](https://community.cdata.com/t/cdata-product-updates-q3-2025/1168 "2025-09-03T11:38:09Z")
CData Product Updates Newsletter This quarter’s CData update is a little different. Instead of separate newsletters for each product, we’re sharing one combined view across the entire CData portfolio. With Foundations 2… --- ## [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… --- ## [CData HubSpot Driver v24 and Above Enhances Functionality with Leads Object](https://community.cdata.com/t/cdata-hubspot-driver-v24-and-above-enhances-functionality-with-leads-object/1157)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [August 3, 2025, 1:25pm UTC](https://community.cdata.com/t/cdata-hubspot-driver-v24-and-above-enhances-functionality-with-leads-object/1157 "2025-08-03T13:25:17Z")
Hey CData Community! Starting with CData HubSpot Driver v24, you can access the Leads object just like any other table. No complex API calls or custom workarounds needed. Whether you’re using CData Connect Spreadsheets,… --- ## [Query Regarding Restrictions on Fetching Campaign Records for Salesforce Marketing Cloud via CData](https://community.cdata.com/t/query-regarding-restrictions-on-fetching-campaign-records-for-salesforce-marketing-cloud-via-cdata/1142)
**Author:** [@kalpeshpawar](https://community.cdata.com/u/kalpeshpawar)\ **Replies:** 1\ **Last updated:** [July 30, 2025, 1:18pm UTC](https://community.cdata.com/t/query-regarding-restrictions-on-fetching-campaign-records-for-salesforce-marketing-cloud-via-cdata/1142 "2025-07-30T13:18:09Z")
We would like to inquire if there are any specific restrictions or limitations when fetching records for “campaigns” specifically from Salesforce Marketing Cloud (SFMC) using CData connectors/drivers. --- ## [GCP to Salesforce Marketing Cloud Integration Fails with 'SYNC\_EVENTBUS\_EXECUTION\_TIMEOUT' on Journeys Entity Fetch](https://community.cdata.com/t/gcp-to-salesforce-marketing-cloud-integration-fails-with-sync-eventbus-execution-timeout-on-journeys-entity-fetch/1141)
**Author:** [@kalpeshpawar](https://community.cdata.com/u/kalpeshpawar)\ **Replies:** 1\ **Last updated:** [July 30, 2025, 1:08pm UTC](https://community.cdata.com/t/gcp-to-salesforce-marketing-cloud-integration-fails-with-sync-eventbus-execution-timeout-on-journeys-entity-fetch/1141 "2025-07-30T13:08:33Z")
We are currently using a GCP application integration to connect to Salesforce Marketing Cloud. Our goal is to fetch a list of the Journeys entity. However, when attempting to list or retrieve data for the Journeys entit… [Next page](https://community.cdata.com/tag/cdata-sync/86.md?match_all_tags=true&page=1&tags%5B%5D=cdata-sync)