Skip to main content

Recently active topics

19
Marijan
MarijanEmployee
 CData Virtuality
Fuzzy String Matching in SQL: Using Levenshtein Similarity in CData Virtuality

Use caseCompare strings that look similar but aren’t exactly the same — such as customer names, addresses, or product titles — in SQL queries.We are happy to announce that the development of built in functions to calculate string similarity using different algorithms is under way with the expected release by the end of summer 2025. In the meantime, here is an example on how to achieve this by creating your own virtual procedure. Why Fuzzy Matching?When integrating data from multiple sources or cleaning up inconsistent records, exact string matching (‘=’ or ‘LIKE’) often falls short. For example: "John Smith" vs. "Jon Smith" "Mary Johnson" vs. "Mary Jonson" Despite being nearly identical, these will not match using standard SQL operators.This is where Levenshtein similarity becomes powerful — it quantifies how "close" two strings are based on the minimum number of edits (insertions, deletions, substitutions) needed to convert one into the other. Solution: Levenshtein Similarity as a V

80
Marijan
C
Cdata Arc UserApprentice
 CData Arc
Arc Srpit

I am interested in learning ARC Script for cdata arc and I am from non programming background,  Can you please suggest me any pre requisite (like any programming concepts should know )required before starting learning ARC Script 

171
lohith
A
Anonymous
 CData Partners
Apakah CS AdaKami 24 jam?

Customer Service Adapundi di nomor telepon (08)12.18'506123

152
B
T
Tim WeigelApprentice
 CData DBAmp
Unable to get MetadataXML from CustomField via SF_Metadata

When attempting to use SF_Metadata to retrieve metadata from CustomField, the MetadataXML column is never populating. The Member and Id columns are populating when I use the List operation, and executing the proc with the Retrieve operation appears to succeed, but the MetadataXML column remains NULL.CustomObject and the other tooling objects I’ve worked with have worked fine.This behavior is not confined to a single org. I have confirmed it against three orgs so far.I’ve tried querying CustomField directly in a query using the four-part object identifier, but I get an errorMsg 7314, Level 16, State 1, Line 1The OLE DB provider "MSOLEDBSQL" for linked server "<linked server name here>" does not contain the table ""CData"."Salesforce"."CustomField"". The table either does not exist or the current user does not have permissions on that table.I am able to successfully query the CustomField object in the org via SOQL through Inspector and Workbench to retrieve metadata. I’ve done a fa

281
D
J
JarrodApprentice
 CData MCP Servers
How do you manage your context window when letting AI query large databases through Cdata MCP server?

I’ve been doing some testing querying NetSuite using the CData MCP Server. It works really well! The biggest issue is that the _get_tables query is almost always called first, and it returns thousands of tables because the NetSuite database is so large. This chews up all of Claude’s context and it has to end the conversation before getting anywhere useful. I have disabled the _get_tables tool and provided the relevent tables in my prompt instead, but this kind of defeats the purpose of the tool. What have others done to get around this? Can you modify the _get_tables tool such that it only returns relevant tables? or is there a way for Claude to retrieve and use this data in a way that uses less context? Keen to hear your experiences.

101
Jerod
B
ben.hardcastleApprentice
 CData MCP Servers
The 'DriverPath' option is not a valid JAR file

Hi,I’m trying out the parquet server using the trial/beta JDBC.When trying to run the server as described here:https://github.com/CDataSoftware/parquet-mcp-server-by-cdata?tab=readme-ov-file#running-the-serverI hit an error with my `driverPath` configuration in the .prp file:`The 'DriverPath' option is not a valid JAR file`The path, on Windows, contains a space in it so I also tried enclosing in quotes, but received the same error. `java -jar PATH\TO\cdata.jdbc.parquet.jar` launches the config tool fine

173
B
A
Anusha M BEmployee
 CData Drivers
How to Resolve the Issue of a Missing CData Tab in Excel

Hey CData Community!If you've installed the CData Excel Add-In but don’t see the CData tab, this quick guide will help you bring it back. From enabling the add-in and retrieving the necessary tables from your preferred data source, it’s all covered.To know more, refer to this article: How to Resolve the Issue of a Missing CData Tab in Excel.

110
A
P
PradeepCollaborator
 CData Arc
Custom response in Webhook

Hi Team, I have requirement, where  I need to send back the response back to customer, Below is message we will be receiving from customer, via Webhook connector.    {     "transId": "PUTO300000308",     "whId": "OMEGA-TEST",     "ownerCode": "199501010666",      "jobType": "11",     "jobCode": "010000000408",     "status": "ACTIVE",     "eventAt": "2025-07-03 12:34:56",     "containerId": "00493460370000410856",     "jobGroupCode": "03072026"    }  The response customer is expecting are like below, {"transId": " PUTO300000308","status": "ok","message": ""}  I need pick the transId value from the received data and built the response back with status “Ok” to them. Please help to advice how I need achieve this.

422
P
M
Marcus_SApprentice
 CData User Group
How to query Cdata Sync Job History metadata

Hey All, I’m using cdata sync , version  Cross-Platform Edition - 24.2.9064.0. I’d like to pull cdata sync’s job history  metadata   into a table in SQL Server, so I can perform analysis. Any suggestions on how to do this? I didn’t find anything in the documentation other than info on how to use the cdata sync GUI, but that is not useful.I’d even settle for exporting job history data into a .csv file if that is possible. Ultimately, I want to be able to perform aggregations on the number of records loaded per job. This can’ tbe done through the existing GUI. Thanks! 

272
M
P
Peter_BoelkeApprentice
 CData DBAmp
Error when retrieving AuraDefinition

Hi, since a month we are getting this error:08:06:39: Using the Salesforce SOAP API. [SQLSTATE 01000]08:06:39: Create AuraDefinitionInfo_Previous20250630080639716 with new structure. [SQLSTATE 01000]08:06:40: Error System.Web.Services.Protocols.SoapException: EXCEEDED_ID_LIMIT: AuraDefinitionInfo does not support queryMore(), use LIMIT to restrict the results to a single batch [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) [SQLSTATE 01000]at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) [SQLSTATE 01000]at DBAmpAZ.sforce.SforceService.query(String queryString) [SQLSTATE 01000]at afo220A.iA.s() [SQLSTATE 01000]08:06:40: Drop if it exists. [SQLSTATE 01000]08:06:40: Error: Unable to drop the table. [SQLSTATE 01000]08:06:40: System.InvalidOperationException: ExecuteReader: Connection property has not been ini

473
Ethem Q
Luc
LucCommunity Manager
CData Sync Newsletter - Q2 2025

CData Sync Newsletter We’re happy to update you on the latest developments and features for CData Sync. This quarter, Sync introduced support for Open Mirroring for Microsoft Fabric and SuiteAnalytics support. Plus, see what’s coming next in our Summer Product Showcase and learn how Commando’s small IT team automated data movement across supply chain, finance and fulfillment.  Now in Sync: Open Mirroring to Microsoft FabricOur Q2 release introduces support for Open Mirroring, enabling near real-time replication of source data into Microsoft Fabric-managed Delta Lake tables. This complements Sync’s existing ability to write Parquet, Avro, or CSV to OneLake—making Sync one of the only tools offering multiple ingestion methods for Fabric. Open Mirroring is ideal for live dashboards and time-sensitive reporting, while file-based delivery remains perfect for batch pipelines and data science. With both options in a single platform, teams gain flexibility without needing multiple tools. Learn

140
Luc
Jerod
JerodCommunity Manager
 CData Drivers
Important Update: NetSuite SuiteQL Schema Changes

Action Required: This update affects customers using NetSuite SuiteQL schema. SuiteTalk schema users are not impacted.SummaryWe are notifying CData customers of critical changes to NetSuite SuiteQL Schema due to NetSuite's migration from netsuite.com to netsuite2.com. Multiple objects have been deprecated, potentially affecting your data connectivity operations.Impact Level: High Affected Schema: SuiteQL only Unaffected Schema: SuiteTalkRead more here: https://www.cdata.com/kb/entries/netsuite-suiteql-schema-changes.rst

60
Jerod
A
Arun A.Employee
 CData Arc
Introducing the CData Arc Q2 2025 Release! Smarter EDI routing, connectivity, governance and more

The CData Arc Team is excited to announce our Q2 2025 release, with powerful enhancements to connectivity, visibility, and security! What’s New? The Q2 2025 release focuses on improving EDI metadata awareness, enhancing API integration, and reinforcing platform governance. Our overall goal with this release is to accelerate workflow design and give you greater visibility into your trading partner network. Key Highlights:  Enhanced EDI control: EDI workflows are now metadata-aware, allowing you to track and route documents based on information in document headers.  Improved REST API integration: Use Swagger doc imports to easily integrate with REST APIs.  Extended governance and security: We’ve added SAML 2.0 integrations with identity providers, extended RBAC, and support for remote certificate management.  Full blog post here: https://www.cdata.com/blog/cdata-arc-release-q2-2025  Stay tuned for more updates, and as always, we appreciate your feedback! Let us know how these new featu

120
A
Jaclyn
JaclynEmployee
 CData Sync
🚀 Summer Release is Here! Sync Q2 2025 Highlights 

We’re excited to share the latest updates in CData Sync, now live with powerful new features designed to elevate your data integration experience: 🔁 Microsoft Mirroring as a Destination In partnership with Microsoft, Sync now supports OneLake Mirroring, enabling direct ingestion into the Microsoft Fabric ecosystem. With native Parquet support and catalog integration, it's a seamless way to accelerate your lakehouse strategy. 📈 CDC for SAP ERP Deliver near real-time replication from SAP ERP systems using RFC, expanding our enterprise-grade CDC coverage. 🔐 Stronger Identity & Access Management Enjoy a smoother, more secure experience with revamped SAML integration and 2FA 🌟 Coming in July!  New Reverse ETL Destinations: Pardot, Sage Intacct, and Salesforce Marketing Cloud  Open Table Format Support: support for DeltaLake on AWS, Azure, and GCP.  📚 View full release details in the Current Release Documentation. 🆓 Start a Free Trial or upgrade your Sync install to explore the la

440
Jaclyn
M
MortenspApprentice
 CData Drivers
ADO.net Provider for Access and Charset

I can’t get the connection string to work with charset ie. DataSource=myaccesdb;Charset=windows-1252; The connection is fine, but Charset has no effect. Has anyone solved this?

643
Ethem Q
PratikV
PratikVEmployee
 Editions
SAP ERP Tableau Connector: Troubleshooting "SAP JCo Library Not Found"

When trying to establish a connection to the SAP ERP with our Tableau Connector, you might run into an error indicating that the SAP JCo library is missing. To fix this, make sure the appropriate JAR file is available and properly set up the required native libraries. To resolve the "SAP JCo library not found" error, follow these steps:  Retrieve Native Libraries from SAP:  To link up with SAP ERP through our driver, you'll need to acquire the native libraries from SAP. You can get these directly from SAP's official source. https://support.sap.com/en/product/connectors/jco.html Copy the JAR and DLL Files: After acquiring the necessary JAR and DLL files from SAP, position them in the default directory on your system as follows: C:\Program Files\CData\CData Tableau Connector for SAP ERP 2024\lib  C:\Program Files\Tableau\Drivers\CData Tableau Connector for SAP ERP Opening the JAR File: Keep in mind that the method for accessing the JAR file in SAP ERP differs slightly. Simply double-clic

100
PratikV
Jerod
JerodCommunity Manager
 CData MCP Servers
CData MCP Server Data Source thread

CData launched is first batch of MCP (model context protocol) Servers on May 1st, 2025 with the following servers:Adobe Analytics ADP Google BigQuery Databricks Dynamics 365 Excel Online Gmail Google Analytics Google Calendars Google Sheets HubSpot Jira Microsoft Teams MySQL NetSuite PostgreSQL QuickBooks Online Amazon Redshift Intacct Salesforce Slack Snowflake Enterprise Data Warehouse Microsoft SQL Server Veeva Vault & Vault CRM WorkdayWe’ll update this thread as we add new sources, so stay tuned!~~If you have requests from our library, let us know!~~

784
Jerod
Luc
LucCommunity Manager
CData Arc Newsletter - Q2 2025Newsletter

CData Arc Newsletter We’re continuing to innovate and expand CData Arc's capabilities to streamline your file transfer operations, simplify EDI integration workflows and strengthen your security posture. In this newsletter, we highlight the latest enhancements to the platform and share a preview of the exciting developments to come. Upcoming live event: Summer 2025 ShowcaseDon’t miss our upcoming Summer Product Showcase to learn about CData Arc’s Q2 release - featuring enhanced security, REST API connectivity through swagger documentation, new Python scripting support, and more. Engage with CData’s product leaders and learn how our platform is helping enterprises accelerate AI adoption. Register now   Did you know?In our Q1 2025 release, we've enhanced CData Arc's capabilities with end-to-end workflow testing directly within the Trading Partner Management Console. This powerful feature allows organizations to thoroughly test workflows with trading partners before deployment, ensuring i

180
Luc
Luc
LucCommunity Manager
CData Virtuality Newsletter - Q2 2025Newsletter

CData Virtuality Newsletter Data teams today are asked to do more—faster, smarter, and without slowing down operations. This quarter, we delivered on that need:Strategic platform enhancements in the v25 release Expanded AI capabilities to accelerate your AI initiatives​ Real-world impact showcased through new customer case studiesAlso, don’t miss our upcoming Summer Product Showcase for an insider’s sneak peek into our 2025 roadmap for new innovations across our entire suite of offerings!  v25 Release Recap: Strategic platform enhancements Earlier this quarter, we released CData Virtuality v25, bringing key enhancements across the board: Java 17 LTS runtime upgrade Improved MPP engine performance Updated naming conventions aligned with CData standards Usability and security improvements ​​​​​We have also shipped a minor update this month with: Python support for Windows Clustering updates For more details, visit our documentation   Enterprise AI with CData Accelerating and simplifying

90
Luc
CData Foundations 2025

Badge winners

Show all badges
Terms and ConditionsCookie settings