# Ideas **URL:** https://community.cdata.com/c/ideas/26.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Ideas category](https://community.cdata.com/t/about-the-ideas-category/1456)
**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-ideas-category/1456 "2026-10-21T15:35:17Z")
(Replace this first paragraph with a brief description of your new category. This guidance will appear in the category selection area, so try to keep it below 200 characters.) Use the following paragraphs for a longer d… --- ## [Follow up from 178x Cost Spread Whitepaper](https://community.cdata.com/t/follow-up-from-178x-cost-spread-whitepaper/1339)
**Author:** [@njoffe](https://community.cdata.com/u/njoffe)\ **Replies:** 0\ **Last updated:** [October 9, 2026, 1:01pm UTC](https://community.cdata.com/t/follow-up-from-178x-cost-spread-whitepaper/1339 "2026-10-09T13:01:43Z")
Thank you for your research in the 178X Cost Spread Whitepaper. It confirms what we see in the AI Agent product that we’re building. As a task matures, is it recommened to move parts of the business logic into an AI too… --- ## [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… --- ## [Version control / git integration](https://community.cdata.com/t/version-control-git-integration/222)
**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\ **Replies:** 1\ **Last updated:** [December 16, 2025, 1:53pm UTC](https://community.cdata.com/t/version-control-git-integration/222 "2025-12-16T13:53:30Z")
As we make changes to workspaces it is important that we use version control. We also need to control deployment between test and production cData Arc instances. It would be good if a Workspace could have an associat… --- ## [Transform Your Accounting with Custom, Next-Gen QuickBooks Sync](https://community.cdata.com/t/transform-your-accounting-with-custom-next-gen-quickbooks-sync/1251)
**Author:** [@nisha11](https://community.cdata.com/u/nisha11)\ **Replies:** 0\ **Last updated:** [December 8, 2025, 1:42pm UTC](https://community.cdata.com/t/transform-your-accounting-with-custom-next-gen-quickbooks-sync/1251 "2025-12-08T13:42:35Z")
Next-Gen Custom QuickBooks Integration Solutions Build tailor-made QuickBooks integrations for any app, ERP, CRM, or POS. QBIS delivers custom sync solutions for QuickBooks Online & Desktop. Next-Gen Custom QuickBooks … --- ## [🚨IF YOU USE API Access Control: Salesforce change may stop DBAmp on Nov 4, 2025 🚨](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [October 21, 2025, 1:26pm UTC](https://community.cdata.com/t/if-you-use-api-access-control-salesforce-change-may-stop-dbamp-on-nov-4-2025/1224 "2025-10-21T13:26:33Z")
TL&DR Salesforce announced on Wednesday, Oct 15, 2025 that it’s deprecating the “Use Any API Client” permission within API Access Control. If your Salesforce org has API Access Control enabled, only allow-listed Connecte… --- ## [Controlling Min and Max LastModTime Values in Incremental Jobs (CData Sync)](https://community.cdata.com/t/controlling-min-and-max-lastmodtime-values-in-incremental-jobs-cdata-sync/1143)
**Author:** [@IrdiD](https://community.cdata.com/u/IrdiD)\ **Replies:** 0\ **Last updated:** [July 28, 2025, 3:37pm UTC](https://community.cdata.com/t/controlling-min-and-max-lastmodtime-values-in-incremental-jobs-cdata-sync/1143 "2025-07-28T15:37:18Z")
:counterclockwise\_arrows\_button:How Incremental Replication Works (in simple terms) :gear:What These Offsets Do :bar\_chart: Examples :card\_index\_dividers:TL;DR Logic Flow When running incremental replication jobs in CD… --- ## [Regex Expression](https://community.cdata.com/t/regex-expression/1133)
**Author:** [@LetherMade](https://community.cdata.com/u/LetherMade)\ **Replies:** 0\ **Last updated:** [July 21, 2025, 7:41am UTC](https://community.cdata.com/t/regex-expression/1133 "2025-07-21T07:41:49Z")
In the programming world, regex is a very useful tool to have in your toolbelt. However, the only regex tool available within CDataVirtuality is ARRAY\_LIKE\_REGEX, which functions solely as a boolean validator—it checks … --- ## [Cdata Sync Email Notification Errors Only](https://community.cdata.com/t/cdata-sync-email-notification-errors-only/1107)
**Author:** [@Mik](https://community.cdata.com/u/Mik)\ **Replies:** 0\ **Last updated:** [June 11, 2025, 3:11pm UTC](https://community.cdata.com/t/cdata-sync-email-notification-errors-only/1107 "2025-06-11T15:11:35Z")
Just a minor product suggestion for CData Sync. We have all of our jobs setup with email notification with the “errors only” option enabled. Some of our jobs have a large number of tasks within them. What we typically… --- ## [Connecting TIBCO Spotfire to CData Virtuality using JDBC](https://community.cdata.com/t/connecting-tibco-spotfire-to-cdata-virtuality-using-jdbc/1099)
**Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [May 26, 2025, 11:37am UTC](https://community.cdata.com/t/connecting-tibco-spotfire-to-cdata-virtuality-using-jdbc/1099 "2025-05-26T11:37:53Z")
Connecting TIBCO Spotfire Information Services to a CData Virtuality server requires a custom JDBC data source template. Below we outline the driver details and provide a correctly structured XML template (rooted at \ **Author:** [@Marijan](https://community.cdata.com/u/Marijan)\ **Replies:** 0\ **Last updated:** [May 19, 2025, 8:28am UTC](https://community.cdata.com/t/we-re-centralizing-our-community-experience/1095 "2025-05-19T08:28:29Z") To streamline access to information and enhance your experience, we’re fully transitioning to the CData Community as our central hub for discussions and knowledge sharing. As part of this move, the Data Virtuality Commun… --- ## [3 Ways to Integrate External Data Sources with FileMaker via CData ODBC Drivers](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1086)
**Author:** [@Dibyendu](https://community.cdata.com/u/Dibyendu)\ **Replies:** 0\ **Last updated:** [May 8, 2025, 5:51am UTC](https://community.cdata.com/t/3-ways-to-integrate-external-data-sources-with-filemaker-via-cdata-odbc-drivers/1086 "2025-05-08T05:51:50Z")
Hey CData Community! Ready to supercharge your FileMaker apps? Say hello to a world “beyond the file\*”\* with CData ODBC Drivers! Whether you’re taming spreadsheets, poking into cloud platforms, or cracking open database… --- ## [cData Arc Developer available](https://community.cdata.com/t/cdata-arc-developer-available/988)
**Author:** [@russellfeeed](https://community.cdata.com/u/russellfeeed)\ **Replies:** 0\ **Last updated:** [January 8, 2025, 9:48pm UTC](https://community.cdata.com/t/cdata-arc-developer-available/988 "2025-01-08T21:48:38Z")
Hi all Hopefully this is okay to post here. I’m an experienced cData Arc developer looking to use my skills to help other organisations get the most out of cData Arc. If you have a project or challenge you wish to di… --- ## [Cdata Sync - 10 Suggested features.](https://community.cdata.com/t/cdata-sync-10-suggested-features/723)
**Author:** [@ninken](https://community.cdata.com/u/ninken)\ **Replies:** 5\ **Last updated:** [December 18, 2024, 5:37pm UTC](https://community.cdata.com/t/cdata-sync-10-suggested-features/723 "2024-12-18T17:37:40Z")
Greetings as I use more and more of CData Sync in our environment. I’ve jotted down features I would like to see in future editions of CData Sync. Jobs 1. Feature: New tab in the Overview, Task, Job History… Called \[No… --- ## [Scheduled Queries](https://community.cdata.com/t/scheduled-queries/60)
**Author:** [@Jessica\_Ritchie](https://community.cdata.com/u/Jessica_Ritchie)\ **Replies:** 2\ **Last updated:** [December 13, 2024, 7:09pm UTC](https://community.cdata.com/t/scheduled-queries/60 "2024-12-13T19:09:45Z")
While it’s great that I can query my data across different connections sometimes it takes a while for the query results to populate. It would be nice if: I could schedule specific datasets to query on set days/times Be… --- ## [Data Organization](https://community.cdata.com/t/data-organization/56)
**Author:** [@Jessica\_Ritchie](https://community.cdata.com/u/Jessica_Ritchie)\ **Replies:** 2\ **Last updated:** [December 13, 2024, 7:09pm UTC](https://community.cdata.com/t/data-organization/56 "2024-12-13T19:09:16Z")
While I am currently able to access my data across all the connections I have setup inside of Connect Cloud, I spend a lot of time navigating to different datasets manually versus having them organized in one place. Havi… --- ## [Query Wizard Builder](https://community.cdata.com/t/query-wizard-builder/62)
**Author:** [@Jessica\_Ritchie](https://community.cdata.com/u/Jessica_Ritchie)\ **Replies:** 2\ **Last updated:** [December 13, 2024, 7:08pm UTC](https://community.cdata.com/t/query-wizard-builder/62 "2024-12-13T19:08:26Z")
I’m a newbie when it comes to writing SQL code and sometimes my manager wants me to create queries that include things like filtering and joins which I am unable to do. It would be great if there was a wizard or easy ste… --- ## [Jobs using a Connection](https://community.cdata.com/t/jobs-using-a-connection/479)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 4\ **Last updated:** [December 13, 2024, 2:55pm UTC](https://community.cdata.com/t/jobs-using-a-connection/479 "2024-12-13T14:55:13Z")
When viewing a Connection, it would be nice to see someplace the dependencies on that connection. (I.e. the jobs that have tasks which reference that connection.) --- ## [Suggestion, Add the ability to add Names or description to Queries in Transformation](https://community.cdata.com/t/suggestion-add-the-ability-to-add-names-or-description-to-queries-in-transformation/941)
**Author:** [@Jackolas](https://community.cdata.com/u/Jackolas)\ **Replies:** 0\ **Last updated:** [November 14, 2024, 8:34am UTC](https://community.cdata.com/t/suggestion-add-the-ability-to-add-names-or-description-to-queries-in-transformation/941 "2024-11-14T08:34:50Z")
ATM we are using Cdata Sync to extract data from SAP ERP to a data-warehouse and this is working great. To make the data readable/usable we do a lot of transformation after the data is loaded. However we did notice that… --- ## [Transformations - Pre-load transformation](https://community.cdata.com/t/transformations-pre-load-transformation/599)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 13\ **Last updated:** [July 24, 2024, 8:31am UTC](https://community.cdata.com/t/transformations-pre-load-transformation/599 "2024-07-24T08:31:49Z")
I would like to be able to do two things with Transformations: Be able to execute a transformation at the Start of a job, rather than just at the end. So a Trigger of “Before job”. Be able to execute a transformation … --- ## [Enhancing Data Sync with Validation and Reconciliation Features](https://community.cdata.com/t/enhancing-data-sync-with-validation-and-reconciliation-features/665)
**Author:** [@ninken](https://community.cdata.com/u/ninken)\ **Replies:** 4\ **Last updated:** [July 23, 2024, 4:37pm UTC](https://community.cdata.com/t/enhancing-data-sync-with-validation-and-reconciliation-features/665 "2024-07-23T16:37:45Z")
I am reaching out to propose an enhancement to our data sync product, specifically regarding the introduction of validation and reconciliation functionalities. As our data source requirements caters to various data synch… --- ## [Ability to download Entire Message with Headers and re-import them into Connectors](https://community.cdata.com/t/ability-to-download-entire-message-with-headers-and-re-import-them-into-connectors/805)
**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\ **Replies:** 0\ **Last updated:** [June 27, 2024, 2:57pm UTC](https://community.cdata.com/t/ability-to-download-entire-message-with-headers-and-re-import-them-into-connectors/805 "2024-06-27T14:57:16Z")
Maybe it’s bad practice, but in my flow I use Script connectors to create data which I pass through the flow in Message Headers. Sometimes, it’s useful to download the message, adjust it and re-upload it. However thi… --- ## [Sync - search content of jobs from main search bar](https://community.cdata.com/t/sync-search-content-of-jobs-from-main-search-bar/646)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 1\ **Last updated:** [May 23, 2024, 5:04pm UTC](https://community.cdata.com/t/sync-search-content-of-jobs-from-main-search-bar/646 "2024-05-23T17:04:10Z")
While on the main Jobs view in Sync (/jobs.rst), if you use the free-text Search bar, it only searches the names of the jobs. (Whereas the Job view /job-details.rst will search the Task names etc.) Sometimes you can’t … --- ## [🚀 Exciting News from CData! 🚀 Data Sync Q1 2024 Release Highlights](https://community.cdata.com/t/exciting-news-from-cdata-data-sync-q1-2024-release-highlights/706)
**Author:** [@anonymous](https://community.cdata.com/u/anonymous)\ **Replies:** 0\ **Last updated:** [April 30, 2024, 1:47pm UTC](https://community.cdata.com/t/exciting-news-from-cdata-data-sync-q1-2024-release-highlights/706 "2024-04-30T13:47:39Z")
We’re thrilled to announce the latest enhancements to CData Sync, now with even more powerful features to supercharge your data integration and management: :globe\_with\_meridians: Sync Cloud - Our renowned Sync product,… --- ## [Disk Space Usage Dashboard and/or more granular cleanup controls](https://community.cdata.com/t/disk-space-usage-dashboard-and-or-more-granular-cleanup-controls/633)
**Author:** [@russell-jerseypost](https://community.cdata.com/u/russell-jerseypost)\ **Replies:** 0\ **Last updated:** [February 15, 2024, 10:40pm UTC](https://community.cdata.com/t/disk-space-usage-dashboard-and-or-more-granular-cleanup-controls/633 "2024-02-15T22:40:49Z")
Sometimes when deploying flows which handle a large number of messages, it’s easy to consume more disk space than expected. A way to identify the Connectors/Workspaces which are consuming the most disk space would all… --- ## [Comments on Job and Task](https://community.cdata.com/t/comments-on-job-and-task/611)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 0\ **Last updated:** [January 26, 2024, 1:23pm UTC](https://community.cdata.com/t/comments-on-job-and-task/611 "2024-01-26T13:23:39Z")
I would like to be able to add a short comment to some Jobs or Tasks within a Job. Something to guide other developers about any pitfalls or why a particular ingestion approach was taken. It would be great to have a “c… --- ## [CDC/CT - Resynchronize from Date](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 5\ **Last updated:** [January 12, 2024, 12:58pm UTC](https://community.cdata.com/t/cdc-ct-resynchronize-from-date/583 "2024-01-12T12:58:27Z")
I’ve been using Sync to pull from MS SQL Server, from a couple of different sources that have either CDC or Change Tracking enabled. Occasionally, there is some kind of hiccup where things get out of sync. There are ch… --- ## [AI Generated Queries](https://community.cdata.com/t/ai-generated-queries/57)
**Author:** [@Jessica\_Ritchie](https://community.cdata.com/u/Jessica_Ritchie)\ **Replies:** 2\ **Last updated:** [December 28, 2023, 9:07pm UTC](https://community.cdata.com/t/ai-generated-queries/57 "2023-12-28T21:07:01Z")
Instead of writing SQL to generate custom queries it would be amazing if I could write prompts via an AI tool to generate the output for me. This would be especially helpful if members of my team weren’t knowledgable wit… --- ## [Re-sort order of Tasks within a Sync job](https://community.cdata.com/t/re-sort-order-of-tasks-within-a-sync-job/581)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 2\ **Last updated:** [December 28, 2023, 8:56pm UTC](https://community.cdata.com/t/re-sort-order-of-tasks-within-a-sync-job/581 "2023-12-28T20:56:23Z")
I’d like to change the order of the Tasks within my Job. Seems like the easiest way to do this within your existing UI, would be to add under the “. . . “ hover menu (on the Task tab), an “Move Up” and “Move Down” opti… --- ## [Sync - see related Transformations while looking at a Job](https://community.cdata.com/t/sync-see-related-transformations-while-looking-at-a-job/587)
**Author:** [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Replies:** 0\ **Last updated:** [December 28, 2023, 5:33pm UTC](https://community.cdata.com/t/sync-see-related-transformations-while-looking-at-a-job/587 "2023-12-28T17:33:31Z")
While looking at the details of a Job (job-details.rst), I’d like to have a tab for “Transformations”. This would show me a list of transformations that are triggered when this job or its tasks run. Clicking on the tra… [Next page](https://community.cdata.com/c/ideas/26.md?page=1)