# Editions

**URL:** https://community.cdata.com/c/troubleshooting/editions/38.md

[Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md)

---

## [About the Editions category](https://community.cdata.com/t/about-the-editions-category/1468)

<div class="topic-metadata">

**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-editions-category/1468 "2026-10-21T15:35:18Z")

</div>

Editions

---

## [SQL Server Database and User Creation   For   A SQL Server user with Least Privilege Acces](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305)

<div class="topic-metadata">

**Author:** [@michaeld](https://community.cdata.com/u/michaeld)\
**Replies:** 0\
**Last updated:** [June 18, 2026, 8:51pm UTC](https://community.cdata.com/t/sql-server-database-and-user-creation-for-a-sql-server-user-with-least-privilege-acces/1305 "2026-06-18T20:51:49Z")

</div>

The Following Scripts can be used to create a SQL Server Database and SQL Server user with Minimum permissions. Executive summary This design follows least privilege, clear ownership boundaries, and containment. The…

---

## [Establishing Azure AD SSO Authentication in CData API Server](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-api-server/1304)

<div class="topic-metadata">

**Author:** [@Sudarshan](https://community.cdata.com/u/Sudarshan)\
**Replies:** 0\
**Last updated:** [June 18, 2026, 7:18pm UTC](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-api-server/1304 "2026-06-18T19:18:24Z")

</div>

Single Sign-On (SSO) with Azure Active Directory (Azure AD) improves security, simplifies access management, and enhances the login experience for CData API Server users. By integrating Azure AD using the OpenID Connect …

---

## [Connection to an OAuth data source fails with “No Error Code Provided” (Windows Edition)](https://community.cdata.com/t/connection-to-an-oauth-data-source-fails-with-no-error-code-provided-windows-edition/1292)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [May 6, 2026, 9:01pm UTC](https://community.cdata.com/t/connection-to-an-oauth-data-source-fails-with-no-error-code-provided-windows-edition/1292 "2026-05-06T21:01:16Z")

</div>

I am attempting a new connection to an external data source in CData Arc. When I complete the authorization against the source, the connection fails with an error “No Error Code Provided”: There do not appear to be…

---

## [Can I use key created using PuTTYgen in the SFTP features in CData Arc?](https://community.cdata.com/t/can-i-use-key-created-using-puttygen-in-the-sftp-features-in-cdata-arc/1275)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [March 20, 2026, 2:40pm UTC](https://community.cdata.com/t/can-i-use-key-created-using-puttygen-in-the-sftp-features-in-cdata-arc/1275 "2026-03-20T14:40:55Z")

</div>

A common form of authentication used in SFTP transfers is Public Key authentication. In this form of authentication, the SFTP client creates a public and private key pair, and shares the public key with the SFTP Server a…

---

## [Sync: Configure SAML based SSO](https://community.cdata.com/t/sync-configure-saml-based-sso/1255)

<div class="topic-metadata">

**Author:** [@Prateek\_Jain](https://community.cdata.com/u/Prateek_Jain)\
**Replies:** 0\
**Last updated:** [December 19, 2025, 8:47pm UTC](https://community.cdata.com/t/sync-configure-saml-based-sso/1255 "2025-12-19T20:47:25Z")

</div>

Configuring SAML-Based Single Sign-On (SSO) with Microsoft Entra ID for CData Sync With SAML-based Single Sign-On (SSO), users can seamlessly authenticate through their organization’s identity provider (IdP), enabling s…

---

## [Tips on replacing a self-signed private key certificate](https://community.cdata.com/t/tips-on-replacing-a-self-signed-private-key-certificate/1254)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [December 16, 2025, 10:37pm UTC](https://community.cdata.com/t/tips-on-replacing-a-self-signed-private-key-certificate/1254 "2025-12-16T22:37:42Z")

</div>

Private key certificates are used in AS2 and other MFT protocols to allow for secure elements of MFT transfers – notably, data encrypted with the matching public key certificate can be decrypted with the private key cert…

---

## [HRESULT: 0xC0047043 Exception when using SSIS components](https://community.cdata.com/t/hresult-0xc0047043-exception-when-using-ssis-components/1245)

<div class="topic-metadata">

**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\
**Replies:** 0\
**Last updated:** [December 2, 2025, 2:58pm UTC](https://community.cdata.com/t/hresult-0xc0047043-exception-when-using-ssis-components/1245 "2025-12-02T14:58:20Z")

</div>

While working with our SSIS components in Visual Studio, you may encounter an Exception from HRESULT: 0xC0047043 error: This is a known issue in Visual Studio SSIS project. It occurs because Visual Studio UI attemp…

---

## [SQLServerV2: This connector type has been removed and will no longer function](https://community.cdata.com/t/sqlserverv2-this-connector-type-has-been-removed-and-will-no-longer-function/1239)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [November 21, 2025, 8:40pm UTC](https://community.cdata.com/t/sqlserverv2-this-connector-type-has-been-removed-and-will-no-longer-function/1239 "2025-11-21T20:40:04Z")

</div>

Why: Different versions of the SQL Server connector were available in different releases of CData Arc, and the V2 release was one that made use of central database connection configurations but referenced the nati…

---

## [LDAP Authentication Setup in CData Sync with ApacheDS](https://community.cdata.com/t/ldap-authentication-setup-in-cdata-sync-with-apacheds/1192)

<div class="topic-metadata">

**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\
**Replies:** 0\
**Last updated:** [September 18, 2025, 3:43pm UTC](https://community.cdata.com/t/ldap-authentication-setup-in-cdata-sync-with-apacheds/1192 "2025-09-18T15:43:36Z")

</div>

This article explains LDAP authentication and how to set it up with an ApacheDS on-premises server. What is LDAP? LDAP (Lightweight Directory Access Protocol) is an open, vendor-neutral, industry-standard application p…

---

## [How to access the Derby Database in CData Sync AMI Edition](https://community.cdata.com/t/how-to-access-the-derby-database-in-cdata-sync-ami-edition/1185)

<div class="topic-metadata">

**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\
**Replies:** 0\
**Last updated:** [September 11, 2025, 9:05pm UTC](https://community.cdata.com/t/how-to-access-the-derby-database-in-cdata-sync-ami-edition/1185 "2025-09-11T21:05:49Z")

</div>

In this article, we will demonstrate how to install the Derby database engine and how to connect to the Sync application database in the AMI edition. Warning: Modifying the application database directly may cause un…

---

## [SAP ERP Tableau Connector: Troubleshooting "SAP JCo Library Not Found"](https://community.cdata.com/t/sap-erp-tableau-connector-troubleshooting-sap-jco-library-not-found/1116)

<div class="topic-metadata">

**Author:** [@PratikV](https://community.cdata.com/u/PratikV)\
**Replies:** 0\
**Last updated:** [June 23, 2025, 1:26pm UTC](https://community.cdata.com/t/sap-erp-tableau-connector-troubleshooting-sap-jco-library-not-found/1116 "2025-06-23T13:26:37Z")

</div>

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 an…

---

## [Automating Real-Time Data Pipelines using CData JDBC Drivers](https://community.cdata.com/t/automating-real-time-data-pipelines-using-cdata-jdbc-drivers/1075)

<div class="topic-metadata">

**Author:** [@Manikandan\_Palanisamy](https://community.cdata.com/u/Manikandan_Palanisamy)\
**Replies:** 0\
**Last updated:** [April 17, 2025, 7:26pm UTC](https://community.cdata.com/t/automating-real-time-data-pipelines-using-cdata-jdbc-drivers/1075 "2025-04-17T19:26:49Z")

</div>

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 t…

---

## [How are control numbers assigned in the EDI connectors and can I reset them?](https://community.cdata.com/t/how-are-control-numbers-assigned-in-the-edi-connectors-and-can-i-reset-them/1063)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [March 24, 2025, 9:37pm UTC](https://community.cdata.com/t/how-are-control-numbers-assigned-in-the-edi-connectors-and-can-i-reset-them/1063 "2025-03-24T21:37:55Z")

</div>

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 inter…

---

## [What is the .eml file that I see on disk in CData Arc? Can I restore this to the original format?](https://community.cdata.com/t/what-is-the-eml-file-that-i-see-on-disk-in-cdata-arc-can-i-restore-this-to-the-original-format/1008)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [January 29, 2025, 10:37pm UTC](https://community.cdata.com/t/what-is-the-eml-file-that-i-see-on-disk-in-cdata-arc-can-i-restore-this-to-the-original-format/1008 "2025-01-29T22:37:40Z")

</div>

When inspecting a file on disk in CData Arc, you will see that files that you see in the Administration console show a filename: But if you look directly in the Receive folder for the connector on disk, an .eml file …

---

## [Performance and Load Testing on CData Driver Using JMeter](https://community.cdata.com/t/performance-and-load-testing-on-cdata-driver-using-jmeter/996)

<div class="topic-metadata">

**Author:** [@Manikandan\_Palanisamy](https://community.cdata.com/u/Manikandan_Palanisamy)\
**Replies:** 0\
**Last updated:** [January 16, 2025, 9:51pm UTC](https://community.cdata.com/t/performance-and-load-testing-on-cdata-driver-using-jmeter/996 "2025-01-16T21:51:45Z")

</div>

This Knowledge Base article provides a step-by-step guide on using Apache JMeter to perform load testing or benchmarking with CData’s Salesforce JDBC driver. It explains how to configure JMeter to simulate multiple users…

---

## [Common Errors using our JDBC Drivers in Apache Kafka](https://community.cdata.com/t/common-errors-using-our-jdbc-drivers-in-apache-kafka/978)

<div class="topic-metadata">

**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\
**Replies:** 0\
**Last updated:** [December 20, 2024, 10:45pm UTC](https://community.cdata.com/t/common-errors-using-our-jdbc-drivers-in-apache-kafka/978 "2024-12-20T22:45:29Z")

</div>

Apache Kafka is an open-source stream processing platform that is primarily used for building real-time data pipelines and event-driven applications. When paired with the CData JDBC Drivers, Kafka can work with live data…

---

## [Incoming requests greater than 30 MB are rejected with an HTTP error 413 “Request Entity Too Large” when hosted in IIS](https://community.cdata.com/t/incoming-requests-greater-than-30-mb-are-rejected-with-an-http-error-413-request-entity-too-large-when-hosted-in-iis/962)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [December 3, 2024, 3:41pm UTC](https://community.cdata.com/t/incoming-requests-greater-than-30-mb-are-rejected-with-an-http-error-413-request-entity-too-large-when-hosted-in-iis/962 "2024-12-03T15:41:59Z")

</div>

When receiving large AS2 transmissions from my partners, any transmission of a payload greater than 30 MB that is not sent via Chunked-Transfer-Encoding is rejected with an error at the web server: 413 “Request Entity…

---

## [Tips on troubleshooting performance issues in CData Arc](https://community.cdata.com/t/tips-on-troubleshooting-performance-issues-in-cdata-arc/933)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [November 5, 2024, 9:12pm UTC](https://community.cdata.com/t/tips-on-troubleshooting-performance-issues-in-cdata-arc/933 "2024-11-05T21:12:22Z")

</div>

CData Arc is a web application solution for creating complex document processing flows, and because of the variety of environments that you can run the application in, the number of processes that you can configure the a…

---

## [A quick guide to the Base URL](https://community.cdata.com/t/a-quick-guide-to-the-base-url/922)

<div class="topic-metadata">

**Author:** [@James\_B](https://community.cdata.com/u/James_B)\
**Replies:** 0\
**Last updated:** [October 21, 2024, 7:10pm UTC](https://community.cdata.com/t/a-quick-guide-to-the-base-url/922 "2024-10-21T19:10:36Z")

</div>

CData Arc is a web application that uses several endpoints in the application for its communications. The resources in CData Arc that support external communications include: the /pub/Receive.rsb endpoint that recei…

---

## [Integrating Data in Azure PowerShell runbook Using CData Cmdlets Connector](https://community.cdata.com/t/integrating-data-in-azure-powershell-runbook-using-cdata-cmdlets-connector/905)

<div class="topic-metadata">

**Author:** [@Khushi\_Khandelwal](https://community.cdata.com/u/Khushi_Khandelwal)\
**Replies:** 0\
**Last updated:** [September 26, 2024, 5:53pm UTC](https://community.cdata.com/t/integrating-data-in-azure-powershell-runbook-using-cdata-cmdlets-connector/905 "2024-09-26T17:53:41Z")

</div>

PowerShell Workflow runbooks are text runbooks based on Windows PowerShell Workflow. The CData cmdlets Driver for Salesforce enables to interact with Salesforce data from within your Azure Automation environment. This a…

---

## [How to create self-signed certificates to enable SSL/TLS connectivity for CData Sync](https://community.cdata.com/t/how-to-create-self-signed-certificates-to-enable-ssl-tls-connectivity-for-cdata-sync/894)

<div class="topic-metadata">

**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\
**Replies:** 0\
**Last updated:** [September 3, 2024, 5:16pm UTC](https://community.cdata.com/t/how-to-create-self-signed-certificates-to-enable-ssl-tls-connectivity-for-cdata-sync/894 "2024-09-03T17:16:06Z")

</div>

To enable SSL/TLS connectivity for CData Sync, you will need SSL/TLS certificates. The valid formats that can be used in Sync include JKS, PKCS12, and JCEKS. This article explains how to create self-signed certifica…

---

## [Improving Connector to Connector Performance for Flows in CData Arc using FlowExecute](https://community.cdata.com/t/improving-connector-to-connector-performance-for-flows-in-cdata-arc-using-flowexecute/888)

<div class="topic-metadata">

**Author:** [@Arturo\_S](https://community.cdata.com/u/Arturo_S)\
**Replies:** 0\
**Last updated:** [August 23, 2024, 6:09pm UTC](https://community.cdata.com/t/improving-connector-to-connector-performance-for-flows-in-cdata-arc-using-flowexecute/888 "2024-08-23T18:09:17Z")

</div>

In 2022, Arc introduced the Flow API Functionality, which allows for the publication of an entire flow as an API endpoint that is consumed by users authenticated through the Admin API. Since the entire flow is processed …

---

## [Access Is Denied – cmd.exe](https://community.cdata.com/t/access-is-denied-cmd-exe/867)

<div class="topic-metadata">

**Author:** [@Zachary\_G](https://community.cdata.com/u/Zachary_G)\
**Replies:** 0\
**Last updated:** [July 19, 2024, 6:57pm UTC](https://community.cdata.com/t/access-is-denied-cmd-exe/867 "2024-07-19T18:57:53Z")

</div>

Occasionally, on a fresh install of one of the many CData Excel Add-ins, you will see the below error: This error means that either a system IT policy, or antivirus software has blocked a portion of the Excel Add…

---

## [Fixing SAP Native Jar File Issue while establishing SAP ERP connection in CData Sync](https://community.cdata.com/t/fixing-sap-native-jar-file-issue-while-establishing-sap-erp-connection-in-cdata-sync/862)

<div class="topic-metadata">

**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\
**Replies:** 0\
**Last updated:** [July 16, 2024, 2:12pm UTC](https://community.cdata.com/t/fixing-sap-native-jar-file-issue-while-establishing-sap-erp-connection-in-cdata-sync/862 "2024-07-16T14:12:56Z")

</div>

Error message: SAP JCo library not found: verify the correct jar file is present. Problem Description: When encountering issues related to missing SAP native jar files, it typically indicates a SAP Java Connecto…

---

## [Installation of Tomcat Server and Deploying CData Sync on it](https://community.cdata.com/t/installation-of-tomcat-server-and-deploying-cdata-sync-on-it/861)

<div class="topic-metadata">

**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\
**Replies:** 0\
**Last updated:** [July 12, 2024, 9:28pm UTC](https://community.cdata.com/t/installation-of-tomcat-server-and-deploying-cdata-sync-on-it/861 "2024-07-12T21:28:03Z")

</div>

Apache Tomcat is a popular free and open-source web container and webserver to serve Java-based web apps or pages. Download Tomcat server’s latest edition Zip file from https://tomcat.apache.org/ and extract the files…

---

## [Best practices for Migrating CData Sync from a previous .NET version to V24 Cross-Platform in an IIS Deployment](https://community.cdata.com/t/best-practices-for-migrating-cdata-sync-from-a-previous-net-version-to-v24-cross-platform-in-an-iis-deployment/809)

<div class="topic-metadata">

**Author:** [@Bukuroshe\_D](https://community.cdata.com/u/Bukuroshe_D)\
**Replies:** 0\
**Last updated:** [July 1, 2024, 5:35pm UTC](https://community.cdata.com/t/best-practices-for-migrating-cdata-sync-from-a-previous-net-version-to-v24-cross-platform-in-an-iis-deployment/809 "2024-07-01T17:35:24Z")

</div>

Starting with Sync 2024, the .NET edition of the application is deprecated. A general guide about “Migrating CData Sync from the .NET Edition to the Cross-Platform Edition” can be found on the following article: Migrati…

---

## [CData Arc’s Health Checks Explained](https://community.cdata.com/t/cdata-arc-s-health-checks-explained/806)

<div class="topic-metadata">

**Author:** [@Arturo\_S](https://community.cdata.com/u/Arturo_S)\
**Replies:** 0\
**Last updated:** [June 28, 2024, 1:28pm UTC](https://community.cdata.com/t/cdata-arc-s-health-checks-explained/806 "2024-06-28T13:28:35Z")

</div>

CData Arc is an integration platform that can be scaled up to process large volumes of data, but it is inherently an application solution that will be limited by the resources of the system hosting it. When system limita…

---

## [Which data sources support DirectQuery mode in Power BI?](https://community.cdata.com/t/which-data-sources-support-directquery-mode-in-power-bi/804)

<div class="topic-metadata">

**Author:** [@PratikV](https://community.cdata.com/u/PratikV)\
**Replies:** 0\
**Last updated:** [June 27, 2024, 2:48pm UTC](https://community.cdata.com/t/which-data-sources-support-directquery-mode-in-power-bi/804 "2024-06-27T14:48:21Z")

</div>

Repeatedly, customers have raised inquiries regarding the compatibility of Power BI’s direct query mode with various data sources. They seek clarification on which this feature supports specific data sources. Here is a …

---

## [Sync – An SQL data change is not permitted for a read-only connection, user or database.](https://community.cdata.com/t/sync-an-sql-data-change-is-not-permitted-for-a-read-only-connection-user-or-database/797)

<div class="topic-metadata">

**Author:** [@Omar](https://community.cdata.com/u/Omar)\
**Replies:** 0\
**Last updated:** [June 21, 2024, 9:06pm UTC](https://community.cdata.com/t/sync-an-sql-data-change-is-not-permitted-for-a-read-only-connection-user-or-database/797 "2024-06-21T21:06:13Z")

</div>

This error can indicate one of the following: The disk that Sync is trying to store data on is full Sync does not have permissions to write to the Derby database or SQLite database that it uses to store Sync inform…

[Next page](https://community.cdata.com/c/troubleshooting/editions/38.md?page=1)
