Skip to main content

Recently active topics

17 Topics
M
Manikandan PalanisamyEmployee
published in Editions
Automating Real-Time Data Pipelines using CData JDBC Drivers

Data integration and automation have become crucial for businesses that rely on seamless data flows between different platforms. In this article, we’ll walk you through building and automating a real-time data pipeline to transfer work items from Azure DevOps to SharePoint, using CData JDBC drivers, Java, and automation tools such as Windows Task Scheduler, Cron Jobs, and Jenkins. This approach helps ensure your data is always up to date, without the need for manual intervention. Why Automate Data Pipelines? Before we jump into the technical setup, let’s first understand why automating data pipelines is so important:  Real-time Data Availability: Automation ensures that your data is transferred and synchronized in real-time across platforms.  Reduced Human Error: By eliminating manual processes, the chances of errors are minimized.  Efficiency and Time Savings: With automation in place, you can free up valuable time and resources for more strategic tasks.  Scalability: As your busin

20
M
B
bgrassiApprentice
asked in Developers
Netsuite connection via SuiteQL not about to query PricingGroup Table

Was trying to access the PricingGroup Table in Netsuite via SuiteQL and keep getting back this error: The query failed with the following error:\r\nUnable to retrieve columns for table [PricingGroup].Query for reference:  {    "query": "SELECT TOP 10 * FROM NetSuite7.Netsuite.PricingGroup"}I have been having this issue with several other tables and/or fields that just don’t seem to be accessible via SuiteQL. Another example is on the Item table I can’t return PurchaseUnit or StockUnit.  Why isn’t everything just available and query able in SuiteQL? 

281
C
L
lansleysApprentice
asked in CData Arc
Solution for not working Receive file from a FTP server from multiply folder and send an email with a different subject depending on the folder

Hi All,Sorry for the late response and recreating the  topic. The solution provide did to work as the heading info is no been added to the file. Not sure if this is because of the way I created the flows.   The file are received/collected from the FTP server and place into the folder on my server. Please would some assist with a possible solution. Thank you 

271
James B
D
DuyNguyenApprentice
asked in CData Drivers
PostgreSQL Data in MySQL Workbench with no tables

Hi.I am using CData SQL Gateway to query PostgreSQL data in MySQL workbench. MySQL workbench has successfully connected to PostgreSQL data source, but no table can be fetched.Here is my error: This is my CData PostgreSQL ODBC configuration:And this is my mysql remoting service configuration in CData SQL Gateway:This is my MySQL WorkBench connection configuration to the above “mysql remoting service”: How do I resolve this issue? Many thanks!

291
Ethem Q
Q
quinnfEmployee
posted in CData Drivers
SharePoint - Insert Behavior for ID Column on Custom Lists

When creating a custom List in SharePoint, whether through the SharePoint GUI or using the CData driver, several default columns are added automatically. One of these is the “ID” column, which is the primary key for the List.Although the “ID” column is marked as read-only in the column metadata, SharePoint does not consistently enforce this restriction during data insertion. The actual behavior depends on whether you are using the REST or SOAP schema. REST:When inserting records using the REST schema, the “ID” column can be included in the insert statement:INSERT INTO MyCustomList (ID, Column1) VALUES (1234, 'Hello REST');In this case, all data in the statement, including the explicitly set “ID” value, is persisted in SharePoint. While the CData driver typically raises an error such as:Column [ColumnName] could not be inserted. This column is read-only. This restriction is not enforced for the “ID” column when using the REST schema, as of driver version 24.0.9077.0 and later. This exce

250
Q
J
JTapioCollaborator
asked in CData Sync
Sync Kafka source and max rows

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 task, it replicates 179 000 rows and so on. Row count will increase. Seem to be randomI can run job multiple times and it will continue where it was stopped earlier. Is there way to change this behavior, so that all rows will be replicated at once?

897
J
A
AnnaEmployee
posted in CData Virtuality
Announcing CData Virtuality 25.0: our next major release

We are thrilled to announce the first release of the new version 25 of CData Virtuality. Along with it comes the brand-new version of the CData Virtuality Documentation to help you get the most out of the update. The improvements on the Server side include replacing the WMIC Windows tool in the startup scripts and migrating the Server to WildFly 26.1.3 and Java 17. While we’re not making performance promises, moving to Java 17 and WildFly 26.1.3 brings important modernization benefits:  Java 17 is the next LTS after Java 11, ensuring ongoing security updates and stability; Improvements to Garbage Collection, JIT compiler, and memory handling may offer subtle performance gains; Built-in crypto improvements and reduced attack surface thanks to stronger encapsulation (JEP 403) increase security; Internal changes improve startup and module loading times; More recent and secure versions of libraries like RESTEasy, Undertow, Elytron, and more. Another implemented solution improves se

190
A
J
JDBApprentice
asked in Connect Spreadsheets
Connect Spreadsheets Error - exception: service spreadsheets timed out while accessing document with id

Connected to Sage Intacct data via Google Sheets.  When processing a basic query of 15 fields (no formulas) I receive this error after about 136,000+ rows.  This ran fine in MS Excel.  I’ve set Timeout to 0 but the issue persists.  Are there other Advanced Settings that should be changed to allow for up to 250,000 rows to load?

291
Ethem Q
J
jfuhrmanApprentice
asked in CData Connect Cloud
Connect Cloud - How to open and return data from a specific csv file saved in a sharepoint folder?

Hi Community!I’m trying to create a source to sharepoint where we can navigate to a specific file saved on the sharepoint location and open the contents of a csv or xlsm file. Is this possible? I have the sharepoint connection created using AzureAD authentication method. Using a query such as this:  SELECT * FROM [Sharepoint_testing].[REST].[Financial Models] where Name like '%.xlsm%' I can get the various file names contained in the Sharepoint location, and see things like file size, modify date, etc. At this point, I can’t figure out how to use the file name retrieved and then query it to get at the contents of it… any help with this?  TIA for the assist, i appreciate it. 

512
Jerod
R
Rodrigo de AlbuquerqueEmployee
asked in CData Drivers
SAP Success Factors - Get Data Error related to snapshot based pagination

When querying my data from SAP SF or running my package in SSIS, I’m getting the following error message: Get data error: [COE_SNAPSHOT_BAD_REQUEST] We have temporarily blocked the snapshot pagination request from companyUser Test |ODATA for all entities until Thu Mar 20 15:51:40 UTC 2025 because too many consecutive requests have been attempted without accessing subsequent data.

181
R
Luc
LucCommunity Manager
published in CData Arc
Introducing the CData Arc Q1 2025 Version ReleaseNews

The first CData Arc update of 2025 is here! The Q1 2025 release brings powerful new capabilities to streamline trading partner management, expand connectivity, and enhance security. Here’s what’s new: 🔹 Enhanced trading partner management – Test workflows end-to-end before deployment to minimize integration errors.🔹 Expanded connectivity & formats – New XML Group connector and ZPL label support for seamless shipping label generation.🔹 Enterprise-grade security – Built-in 2FA and extended Arc Key Vault integration for enhanced data protection.🔹 EU compliance & hosting – Support for AS4, ENTSOG V4, ZUGFeRD, and GDPR-compliant EU hosting.🔹 Migration utilities – Simplified migration from legacy platforms like Dell Boomi and IBM Sterling.🔹 Action required: Arc v22 support ending – Direct support for CData Arc versions v22 and older will be discontinued on June 24, 2025. For users of these versions, this means that receiving technical support from our team will first require an

594
C
Luc
LucCommunity Manager
CData Arc Newsletter - Q1 2025Newsletter

CData Arc Newsletter We’ve been hard at work enhancing CData Arc to improve usability, expand enterprise file integration capabilities, and accelerate development of new workflows. In this newsletter, we present what’s new and what’s coming up. Latest release highlights: CData Arc V2025.1With CData Arc’s latest version, we are doubling down on our commitment to faster onboarding and integration timelines, advanced data mapping capabilities, and deeper security in your file integrations. Read our release blog to learn more about what’s included in the latest version. Learn more   Register for the CData Product Showcase – March 26, 2025Join us for our first-ever CData Product Showcase, where we’ll highlight new features, roadmap insights, and upcoming innovations.CData Arc customers will also get an in-depth look into our Central Trading Partner Management console and how it can accelerate B2B data integration. This live session will feature Manish, our CPO, alongside other CData product

280
Luc
J
JackolasApprentice
asked in CData Sync
Sync – “[0] Failed to cache row [XXXX] null"

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 tables) between tasks that work and that won’t work. It even fails on small datasets (19 in this example, a 16.000.000+ tasks works without problem)And the log also is not showing a lot of info:2025-03-25T12:34:16.494+0100    2    [ |Q-Id| T-Id]    [ |Q-Id]    [SQL |Bulk  ] 15 rows are being committed.2025-03-25T12:34:16.494+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Starting WriteToServer2025-03-25T12:34:16.494+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoke WriteToServer2025-03-25T12:34:16.508+0100    1    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoke WriteToServer is failed. null2025-03-25T12:34:16.508+0100    5    [    2|    0| 1164]    [CORE] [RealDB:SQLServer]Invoking rollbackTransaction. 2025-03-25T12:34:16.509+0100    0    

481
J
J
Joey FApprentice
asked in Developers
Will my product work on an ARM-based PC?

In the coming days, I’m getting a new laptop with a qualcomm chip. The product I have is the CData Excel Add-In for QuickBooks Online 2021 (RNXGA) (Perpetual use). Will this product work on an ARM-based Windows device? Or will I need to find an alternate solution?

172
Ethem Q
Luc
LucCommunity Manager
CData Sync Newsletter - Q1 2025Newsletter

CData Sync Newsletter We're excited to share the latest developments and features for CData Sync. This quarter, Sync’s product release brought new operational capabilities, expanded reverse ETL, and enhanced destination write capabilities. We also have a product release webinar fast approaching, a Sync product tip, and a customer story to spotlight.  Smarter, faster, and more flexible: What’s new with Sync in Q1The Q1 Sync release brings new updates designed to help you work smarter and optimize your data operations.This introduces Workspaces, which offers complete control over your teams’ data pipelines through individually governed environments. Sync now also features:CDC support for near-real-time data replication from DB2 and Informix Enhanced write performance into RedShift and Databricks by 3-4x. Reverse ETL support for Oracle as a source and HubSpot, Zoho CRM, and Kintone as destinations. Read the release blog   CData Product Showcase – March 26, 2025Join us for our first-ever C

360
Luc
James B
James BEmployee
published in Editions
How are control numbers assigned in the EDI connectors and can I reset them?

When the X12, EDIFACT, and VDA connectors general EDI from XML inputs, each document that is generated has at least one control number created in the outbound documents. In EDI X12, there are control numbers in the interchange and functional group lines:  ISA*00*          *00*          *ZZ*Sender         *ZZ*Receiver       *250304*1022*U*00401*000000003*0*T*:~ GS*PO*Sender*Receiver*20250304*1022*3*T*004010~ ST*850*0001~  In EDIFACT, there is a control number in the UNB segment (and more rarely, a second in the UNG segment if that is used):  UNA:+.?*' UNB+UNOA:4+Sender:ZZZ+Receiver:ZZZ+20250304:1121+000000040' UNH+1+ORDRSP:D:97A:UN:EDOR04'  And in VDA, a Transmission Control Number  71103Sender   Receiver 0000200003250304         11825429 1J         These identifiers are used as unique tracking identifiers for each document, and in each case, the connector maintains a simple state table in the backend database that begins at 1 and increments anew for every new document created:  In the

10
James B
A
AnnaEmployee
posted in CData Virtuality
Announcing CData Virtuality 4.11: Key enhancements, fixes, and new integrations

On the Server side, we’ve implemented a new feature – the "importer.defaultCatalog" model property.We’ve also enhanced Google BigQuery to allow setting partitioning and clustering options for recommended optimizations and materialized tables created for them. Additionally, we’ve fixed a bug that caused INSERT and SELECT INTO queries with a subquery in a WHERE IN clause to hang in the running state.We’ve also worked on LDAP authentication, enabling hybrid LDAP and internal authorization, and fixed a bug causing "SYSADMIN.changeResourceOwnerAndExecutor" to not function properly.Also, we’ve implemented the ability to add a user-specific time zone configuration for job schedules. The Exporter now supports exporting data based on the user’s time zone, too.The REST API has also received some improvements: we’ve extended pagination support for source endpoints calling stored procedures with return values and made the "format" parameter specified in the URL take precedence over the ACCEPT head

140
A
CData's Winter 2025 Release

Badge winners

  • Product Expert
    bgrassihas earned the badge Product Expert
  • Product Expert
    DuyNguyenhas earned the badge Product Expert
  • Product Expert
    quinnfhas earned the badge Product Expert
  • Product Expert
    JDBhas earned the badge Product Expert
  • Product Expert
    Annahas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings