# Data Integration **URL:** https://community.cdata.com/c/data-integration/10.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Data Integration category](https://community.cdata.com/t/about-the-data-integration-category/1440)
**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-data-integration-category/1440 "2026-10-21T15:35:16Z")
Ask questions, get answers, and engage in discussions about data integration solutions from CData. --- ## [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… --- ## [I'm trying to update to OAuth and I'm getting this error](https://community.cdata.com/t/im-trying-to-update-to-oauth-and-im-getting-this-error/1327)
**Author:** [@jmorgan](https://community.cdata.com/u/jmorgan)\ **Replies:** 1\ **Last updated:** [September 11, 2026, 4:56pm UTC](https://community.cdata.com/t/im-trying-to-update-to-oauth-and-im-getting-this-error/1327 "2026-09-11T16:56:00Z")
\--- Starting SF\_Replicate for Account V965613:21:34: Parameters: SALESFORCEDEV Account Version: V965613:21:38: Running DBAmpAZ.exe.13:21:38: DBAmpAZ 22.0.9670.0 Copyright c 2023 CData Software, Inc.13:21:38: Warning: Co… --- ## [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… --- ## [Introducing the Arc Q3 2026 Release](https://community.cdata.com/t/introducing-the-arc-q3-2026-release/1316)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [July 23, 2026, 4:34pm UTC](https://community.cdata.com/t/introducing-the-arc-q3-2026-release/1316 "2026-07-23T16:34:55Z")
We’re excited to announce the launch of the CData Arc Q3 2026 release (v26.3), delivering powerful new capabilities built around security, operational visibility, and configuration control. This release brings applicatio… --- ## [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… --- ## [Introducing the Arc Q2 2026 Release](https://community.cdata.com/t/introducing-the-arc-q2-2026-release/1290)
**Author:** [@Luc](https://community.cdata.com/u/Luc)\ **Replies:** 0\ **Last updated:** [May 5, 2026, 2:44pm UTC](https://community.cdata.com/t/introducing-the-arc-q2-2026-release/1290 "2026-05-05T14:44:02Z")
We’re excited to announce the launch of the CData Arc Q2 2026 release (v26.2), delivering powerful new capabilities that modernize how teams secure, automate, and manage their integration workflows. This release brings O… --- ## [Error: Could not get the allow dB amp to run remotely registry setting](https://community.cdata.com/t/error-could-not-get-the-allow-db-amp-to-run-remotely-registry-setting/1286)
**Author:** [@dbaserver](https://community.cdata.com/u/dbaserver)\ **Replies:** 1\ **Last updated:** [April 27, 2026, 5:29pm UTC](https://community.cdata.com/t/error-could-not-get-the-allow-db-amp-to-run-remotely-registry-setting/1286 "2026-04-27T17:29:11Z")
I am trying to upgrade from to the latest version 2025. When I start my job, I get the following error message “Could not get the allow dB amp to run remotely registry setting”. It does seem we have this particular regis… --- ## [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… --- ## [DBAmp Massive API Calls after CPQ upgrade](https://community.cdata.com/t/dbamp-massive-api-calls-after-cpq-upgrade/1278)
**Author:** [@joshuawharp](https://community.cdata.com/u/joshuawharp)\ **Replies:** 0\ **Last updated:** [March 24, 2026, 1:28am UTC](https://community.cdata.com/t/dbamp-massive-api-calls-after-cpq-upgrade/1278 "2026-03-24T01:28:43Z")
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. … --- ## [Migrate legacy flows to Trading Partner Console](https://community.cdata.com/t/migrate-legacy-flows-to-trading-partner-console/1271)
**Author:** [@ericbux](https://community.cdata.com/u/ericbux)\ **Replies:** 1\ **Last updated:** [March 9, 2026, 5:28am UTC](https://community.cdata.com/t/migrate-legacy-flows-to-trading-partner-console/1271 "2026-03-09T05:28:27Z")
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… --- ## [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… --- ## [Grouping together records in a flat format (CSV) based on a shared key](https://community.cdata.com/t/grouping-together-records-in-a-flat-format-csv-based-on-a-shared-key/36)
**Author:** [@James\_B](https://community.cdata.com/u/James_B)\ **Replies:** 1\ **Last updated:** [February 2, 2026, 5:16pm UTC](https://community.cdata.com/t/grouping-together-records-in-a-flat-format-csv-based-on-a-shared-key/36 "2026-02-02T17:16:55Z")
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 ex… --- ## [❄️ 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 … --- ## [dbQuery with multiple statements](https://community.cdata.com/t/dbquery-with-multiple-statements/1247)
**Author:** [@Travis](https://community.cdata.com/u/Travis)\ **Replies:** 1\ **Last updated:** [December 24, 2025, 12:16pm UTC](https://community.cdata.com/t/dbquery-with-multiple-statements/1247 "2025-12-24T12:16:48Z")
How can I get this Sql Server dbQuery to work? The INSERT is completing fine, but I need to get the inserted identity PK and Arc is not picking it up. \ insert into table (...) values (...); se… --- ## [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 … --- ## [XML Map connector removes escaping special characters](https://community.cdata.com/t/xml-map-connector-removes-escaping-special-characters/1238)
**Author:** [@IT\_Gheys](https://community.cdata.com/u/IT_Gheys)\ **Replies:** 4\ **Last updated:** [November 24, 2025, 12:43pm UTC](https://community.cdata.com/t/xml-map-connector-removes-escaping-special-characters/1238 "2025-11-24T12:43:41Z")
In the input there is a value “\Germany GmbH & Co. KG\”. After it is mapped it is “ \Germany GmbH & Co. KG Hahnstraße 70\”. How can I set it up that special characters are still escaped after… --- ## [Pagination within the REST Connector](https://community.cdata.com/t/pagination-within-the-rest-connector/87)
**Author:** [@Charlie\_S](https://community.cdata.com/u/Charlie_S)\ **Replies:** 1\ **Last updated:** [November 10, 2025, 9:56pm UTC](https://community.cdata.com/t/pagination-within-the-rest-connector/87 "2025-11-10T21:56:51Z")
Overview Sometimes APIs return data to the connecting client in a page based format. This can happen when the requested dataset to be returned is too large for the API to return in one response, or it could be the way th… --- ## [TSQL Order by with latest version of DbAmp](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234)
**Author:** [@MikeLawrenceNbf](https://community.cdata.com/u/MikeLawrenceNbf)\ **Replies:** 0\ **Last updated:** [November 7, 2025, 9:06pm UTC](https://community.cdata.com/t/tsql-order-by-with-latest-version-of-dbamp/1234 "2025-11-07T21:06:59Z")
Greetings, I sent a detailed example of this to support and I’ll put it here in case it’s something simple. I’m running into a lot of issue with dbamp and ordering by the account name. (both directly and also in t… --- ## [Updated XML Map Source File Update Docs](https://community.cdata.com/t/updated-xml-map-source-file-update-docs/1226)
**Author:** [@Travis](https://community.cdata.com/u/Travis)\ **Replies:** 3\ **Last updated:** [October 30, 2025, 7:36am UTC](https://community.cdata.com/t/updated-xml-map-source-file-update-docs/1226 "2025-10-30T07:36:05Z")
How do I delete unused template files? --- ## [Unable to request body in rest connector](https://community.cdata.com/t/unable-to-request-body-in-rest-connector/1206)
**Author:** [@Prakash104](https://community.cdata.com/u/Prakash104)\ **Replies:** 2\ **Last updated:** [October 27, 2025, 2:21pm UTC](https://community.cdata.com/t/unable-to-request-body-in-rest-connector/1206 "2025-10-27T14:21:15Z")
Let me explain the overall flow i am trying to achieve. The flow is exposed as rest service to client. Client will call the rest service to send a file to a specific location. Client will trigger the flow, there is a req… [Next page](https://community.cdata.com/c/data-integration/10.md?page=1)