Skip to main content

CData Sync

Share product questions and get support for CData Sync

  • 74 Topics
  • 155 Replies
74 Topics
D
DougN NouriaInfluencer
asked in CData Sync
Uppercasing the destination table name in Snowflake

Hello, Snowflake seems to be case-sensitive with table names, sort of.  If the incoming table name from Sync gets created with lower or mixed case, it gets created that way in Snowflake, and you have to reference them with quotes later on when querying.  Like    select * from “my_table".  Whereas if it were created as MY_TABLE, you wouldn’t need to bother adding quotes.Some data sources (a SQL server database we have, Active Directory, etc.) have lower or mixed case tables as exposed in CData.Is there a way to uppercase these either on the source as the metadata is read, or, when created in the destination?thank you!

1052
D
1 year ago
E
eneopEmployee
posted in CData Sync
Understanding Change Data Capture and Creating CDC job in CData Sync

Change Data Capture (CDC) is a crucial technique in modern data management that allows you to track and capture changes made to a database. It provides real-time insights into data modifications, enabling businesses to react swiftly to evolving trends and requirements. In this article, we'll explore what CDC is and how to implement it using CData Sync.Understanding Change Data Capture (CDC)CDC revolves around capturing data changes at the source using a log file, eliminating the need for constant querying. Instead, CData Sync reads the log file for events (Insert, Update, or Delete) and extracts these changes in near real time, ensuring accurate replication for future use.Supported CDC Sources:MySQL: Utilizes binary logs. Oracle: Leverages Oracle Flashback. PostgreSQL: Employs logical replication. SQL Server: Uses either change tracking or change data capture.Creating a CDC Job in CData SyncTo initiate a job in CData Sync, ensure you have pre-configured source and destination connectio

891
Ankit Singh
1 year ago
A
abdullah028Apprentice
asked in CData Sync
HTTP ERROR 404 Not Found java.util.zip.ZipException: invalid entry size (expected 5623126 but got 5623165 bytes) while installing CData synch using java -jar sync.jar on macos

INFO: Get app data directory form /Users/mac/Downloads/CDataSync /sync.properties file. nullAug 18, 2023 3:51:40 PM cdata.sync.SyncServer aINFO: The server log directory is /Users/mac/Downloads/CDataSync /logs/httpserverAug 18, 2023 3:51:40 PM b.d qINFO: Init Jetty log with default settings.Aug 18, 2023 3:51:40 PM b.d bINFO: Starting server from /Users/mac/Downloads/CDataSync /sync.properties configuration.Aug 18, 2023 3:51:40 PM d.a aINFO: The properties deserializes success.Aug 18, 2023 3:51:41 PM b.d cINFO: Enabling embedded Jsp support...Aug 18, 2023 3:51:41 PM b.d cINFO: Successfully enabled embedded Jsp support.2023-08-18 15:51:41.719:INFO :oejs.Server:main: jetty-10.0.14; built: 2023-02-22T23:12:32.272Z; git: 976721d0f3e903a243584d47870ad2f2c1bf9e55; jvm 17.0.8+9-LTS-2112023-08-18 15:51:49.684:WARN :oejw.WebAppContext:main: Failed startup of context o.e.j.w.WebAppContext@7d3a22a9{/,null,STOPPED}{/Users/mac/Downloads/CDataSync /webapp/sync.war}java.util.zip.ZipException: invalid

891
A
1 year ago
B
bkilariApprentice
asked in CData Sync
Cannot invoke "java.util.List.iterator()" because "" is null

Hi Community, new to CData Sync here.When am trying to extract a certain table from Workday through the inbuilt Workday source connection, an getting the error - [0] Cannot invoke "java.util.List.iterator()" because "" is null Could anyone help with the error please. Thanks in advance.  

9301
Ethem Q
1 year ago
B
bvbert1969Apprentice
asked in CData Sync
rename file after receiving

Dear all, apologizes in advance for the probably silly question, but I am new at this and I could not find any examplea customer of mine is sending me a file always with the same filename, and I need to be able to save it and be sure that it will not be overwrittenfor example adding a timestamp would be perfect (but preserving the extension)EUC2313.xml → EUC2312_20230828101211.xmlEUC2313.xml → EUC2312_20230828101313.xmlhow could I do this ? I can not use filepath or filename

2826
James B
1 year ago
D
Deb Cobb_PMMEmployee
posted in CData Sync
CData Sync Q3 2023 Release

Hi Everyone!The latest release of CData Sync has arrived! Take a closer look at what's new and how it can benefit you. Visit these resources to learn more:BlogWhat’s New in the Q3 Sync releaseKnowledge Base ArticlesEnterprise features Transformation librariesExperience what’s new yourself!Start a 30 day trial  Upgrade to the latest release And of course, let us know what you think!All the best,The CData Sync Team

260
D
1 year ago
R
RonMooApprentice
asked in CData Sync
Error: Entity 'WorkStepStatus' is not supported by the Bulk API.

Executing SF_MirrorAll results in an error as indicated below.  It occurs both with FullCopy or DeltaCopy.  I have performed various searches but haven’t found a solution.  --- Starting SF_Mirror for WorkStepStatus V8304 [SQLSTATE 01000]01:53:03: Parameters: SALESFORCE_Med_ARCH_FULL WorkStepStatus  Version: V8304 [SQLSTATE 01000]01:53:04: DBAmpAZ 22.0.8304.0 Copyright c 2021 CData Software, Inc. [SQLSTATE 01000]01:53:04: Obtaining Connection Props [SQLSTATE 01000]01:53:04: Obtaining User Information [SQLSTATE 01000]01:53:04: Using settings from Registry. [SQLSTATE 01000]01:53:05: Using FullCopy because the WorkStepStatus table does not exist. [SQLSTATE 01000]01:53:05: Server: WUIT-S-14261, Database: MedARCH_SF_FULL, Linked Server: SALESFORCE_Med_ARCH_FULL [SQLSTATE 01000]01:53:05: Using the Salesforce BulkAPI. [SQLSTATE 01000]01:53:06: Create WorkStepStatus_Previous20230828015305925 with new structure. [SQLSTATE 01000]01:53:06: Error: Entity 'WorkStepStatus' is not supported by the Bul

601
R
1 year ago
J
JTapioApprentice
asked in CData Sync
[META|Cache ] Cache failed: Updating Row is failed. ERROR: Invalid HTTP response!

Hi, I’ve been successfully using Sync to replicate data from Eleasticsearch index to Azure Data Lake. Now I have faced an issue one of index that is bigger than others (not much, but obviously enough bigger). In replication log there are following errors: [META|Cache ] Cache failed: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000 [SQL |Messag] Query Failed: [CACHE [uspa/spaiderloki/arkisto/2023] SELECT [_id], [Aika], [Atunnus], [Caller], [Callsite], [cdata_timestamp], [Duration], [Exception], [Filter], [guid], [ID], [kafka_partition], [Logger], [LogLevel], [Message], [Thread], [Version] FROM [Elasticsearch].[uspa-spaiderloki_arkisto_20233x]]. Error: Updating Row is failed. ERROR: Invalid HTTP response! Cannot upload PostData: System error: An existing connection was forcibly closed by the remote host., AffectedCount: 5200000 Updating Row is failed. ERROR: I

2761
P
1 year ago
D
DevApprentice
asked in CData Sync
Twitter API Details

Can i get the Twitter Connector API details for the Cdata platform ? 

372
D
1 year ago
T
tlallyApprentice
asked in CData Sync
Need to replicate ContentDocumentLink from Salesforce

When I attempt to replicate ContentDocumentLink with CData Sync from Salesforce to SQL, I am getting this error. [0] [500] Could not execute the specified command: [sf:MALFORMED_QUERY] MALFORMED_QUERY: Implementation restriction: ContentDocumentLink requires a filter by a single Id on ContentDocumentId or LinkedEntityId using the equals operator or multiple Id's using the IN operator. The tool that I am looking to replace with CData Sync can do it.  Is there a workaround to get this object to replicate? Thanks

6791
A
1 year ago
A
ashleypaceRSFApprentice
asked in CData Sync
CData Sync Email Connector

Does anyone here have any experience with the CData Sync email connector? I want to know what type of functionality it has - as in, can it read attached files and replicate those, etc?

461
E
1 year ago
F
FishXVApprentice
asked in CData Sync
NetSuite Connector - No Tasks Found

Hi all, Was wondering if anyone has any ideas regarding a NetSuite connector that will allow me to add the connection but displays no tasks when adding a new job.  The connector is using an OAuth token to auth against SuiteQL. It can connect sucessfully, although I can’t create any tasks as it says “No Tasks found. Please verify your connection has access to tables”. The permissions in NetSuite were set according to “https://cdn.cdata.com/help/DNH/cloud/default.htm#pg_permissions”. Any help would be appreciated!

312
F
1 year ago
B
bweatherfordApprentice
asked in CData Sync
CData Sync and MS Teams REST API

Has anyone ever used the REST API Source to get to MS Teams Auto Attendant and/or Call Queue data?Any help is appreciated.

1334
Ankit Singh
1 year ago
A
AmbroseApprentice
asked in CData Sync
EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.

I am using cdata sync and getting the error “EXCEEDED_ID_LIMIT: there are '600000' or more records deleted in the specified time period. Please retry getDeleted() call using a shorter time period.”I have seen other posts say to use a Full vs partial copy but I am not sure that is something that Cdata sync does.   Is there a way go get beyond this error in cdata or salesforce?

5321
E
1 year ago
D
Deb Cobb_PMMEmployee
posted in CData Sync
New Sync release - modern UI and even better hybrid cloud connectivity

Our newest Sync release is now generally available! In this release, as part of our ongoing work to improve the Sync user experience, we employed a Voice of the Customer methodology, soliciting and listening to customer feedback about navigation flows, tasks that would benefit from a more streamlined approach, and the need for improved schema support for common use cases. Read the blog to learn more.

220
D
1 year ago
D
Deb Cobb_PMMEmployee
posted in CData Sync
CData Sync flyer datasheet

Take a look at CData Sync capabilities.

431
John C
1 year ago
James T
James TEmployee
asked in CData Sync
Why don't I see any records returned for my Sage Intacct tables?

I know I have data in my source but there a 0 records returned in my destination!

1161
James T
1 year ago
E
Eric PEmployee
asked in CData Sync
Is there a migrate button on Sync?

I’m currently in the process of changing machines and I do have a lot of jobs and connections in my Sync machine, does Sync have a migrate feature that could help me transfer all the jobs and connections in an easier way or do I need to manually recreate all the connections and jobs?

301
E
1 year ago
B
Ben REmployee
asked in CData Sync
Error when trying to create and save a new connection in CData Sync

When I try to configure a new connection in CData Sync, I click the “Create & Test” button, then an error is displayed:“Add the connection failed: attempt to write to a readonly database”

8071
B
1 year ago
O
OmarEmployee
posted in CData Sync
How do I get Databricks running with CData Sync?

I’m having an error with Sync timing out Databricks clusters when starting up, I’ve tried modifying the job timeout and connection timeout but haven’t been able to solve it.I’m also getting “Failed to check the directory status” 500 errors, what’s going on?

811
O
1 year ago
J
JonathanEmployee
asked in CData Sync
Rename job in CData Sync

I created a job in Sync, but decided I want to change the name I gave the job. However, I don’t see an option in Sync’s UI to do this. Am I able to rename a job in Sync once it’s been created?

1151
J
1 year ago
M
Mike REmployee
asked in CData Sync
How do I enable CData Sync as a Windows service?

I want to be able to run Sync as a Windows service so that it can start automatically when I turn on my laptop.

331
M
1 year ago
M
MahaEmployee
asked in CData Sync
What is the recommended method to add a column to a replicated table recording when the data was synced by CData?

What is the recommended method to add a column to a replicated table recording when the data was synced by CData? Is there a built-in feature or a custom query?

701
M
1 year ago
R
rariegEmployee
asked in CData Sync
How to generate CData Sync logs

Hello,I am having issues trying to generate logs in CData Sync. Could someone help me with it?

671
R
1 year ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Show all badges
Terms and ConditionsCookie settings