# Data Sources **URL:** https://community.cdata.com/c/troubleshooting/data-sources/41.md [Latest](https://community.cdata.com/latest.md) · [Categories](https://community.cdata.com/categories.md) · [Tags](https://community.cdata.com/tags.md) --- ## [About the Data Sources category](https://community.cdata.com/t/about-the-data-sources-category/1471)
**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-data-sources-category/1471 "2026-10-21T15:35:18Z")
Data Sources --- ## [Access live WooCommerce data in LibreOffice via JDBC](https://community.cdata.com/t/access-live-woocommerce-data-in-libreoffice-via-jdbc/1269)
**Author:** [@tlleahy07](https://community.cdata.com/u/tlleahy07)\ **Replies:** 0\ **Last updated:** [February 19, 2026, 4:19pm UTC](https://community.cdata.com/t/access-live-woocommerce-data-in-libreoffice-via-jdbc/1269 "2026-02-19T16:19:22Z")
Connecting LibreOffice to a CData JDBC connector is a relatively smooth process that can be done in just a few steps. In this walkthrough I will be using the WooCommerce JDBC connector. First, launch LibreOffice and in… --- ## [Establishing Azure AD SSO Authentication in CData API Server](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-api-server/1268)
**Author:** [@Sudarshan](https://community.cdata.com/u/Sudarshan)\ **Replies:** 0\ **Last updated:** [February 3, 2026, 2:21pm UTC](https://community.cdata.com/t/establishing-azure-ad-sso-authentication-in-cdata-api-server/1268 "2026-02-03T14:21:51Z")
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 … --- ## [SAP ERP JDBC: “sapjco3.dll already loaded in another classloader” when used from Jaspersoft Studio](https://community.cdata.com/t/sap-erp-jdbc-sapjco3-dll-already-loaded-in-another-classloader-when-used-from-jaspersoft-studio/1246)
**Author:** [@James\_B](https://community.cdata.com/u/James_B)\ **Replies:** 0\ **Last updated:** [December 2, 2025, 4:36pm UTC](https://community.cdata.com/t/sap-erp-jdbc-sapjco3-dll-already-loaded-in-another-classloader-when-used-from-jaspersoft-studio/1246 "2025-12-02T16:36:04Z")
The CData SAP ERP driver uses the sapjco3.jar dependency, which must be referenced in the classpath. This JAR, in turn, depends on sapjco3.dll, whose path must be added to the PATH system environment variable. When usin… --- ## [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.](https://community.cdata.com/t/malformed-query-implementation-restriction-contentdocumentlink-requires-a-filter-by-a-single-id-on-contentdocumentid-or-linkedentityid-using-the-equals-operator-or-multiple-ids-using-the-in-operator/1053)
**Author:** [@Ismete\_M](https://community.cdata.com/u/Ismete_M)\ **Replies:** 0\ **Last updated:** [March 13, 2025, 3:31pm UTC](https://community.cdata.com/t/malformed-query-implementation-restriction-contentdocumentlink-requires-a-filter-by-a-single-id-on-contentdocumentid-or-linkedentityid-using-the-equals-operator-or-multiple-ids-using-the-in-operator/1053 "2025-03-13T15:31:36Z")
When trying to get ContentDocumentLink records with the following query example: SELECT \* FROM ContentDocumentLink Salesforce returns the following error: MALFORMED\_QUERY: Implementation restriction: ContentDocumentLi… --- ## [Optimizing DTM Buffer Size and Default Buffer Block Size in Informatica PowerCenter for batch writes](https://community.cdata.com/t/optimizing-dtm-buffer-size-and-default-buffer-block-size-in-informatica-powercenter-for-batch-writes/1031)
**Author:** [@Orges\_Muzhaqi](https://community.cdata.com/u/Orges_Muzhaqi)\ **Replies:** 0\ **Last updated:** [February 27, 2025, 10:49pm UTC](https://community.cdata.com/t/optimizing-dtm-buffer-size-and-default-buffer-block-size-in-informatica-powercenter-for-batch-writes/1031 "2025-02-27T22:49:46Z")
When using CData drivers alongside various tools, it is crucial to consider the configurations and properties of these tools, as they may override the drivers’ settings. In Informatica PowerCenter, two key memory setting… --- ## [How to Install a Custom Read Table RFC Function Module in SAP](https://community.cdata.com/t/how-to-install-a-custom-read-table-rfc-function-module-in-sap/1027)
**Author:** [@Alba\_Trupja](https://community.cdata.com/u/Alba_Trupja)\ **Replies:** 0\ **Last updated:** [February 20, 2025, 10:35pm UTC](https://community.cdata.com/t/how-to-install-a-custom-read-table-rfc-function-module-in-sap/1027 "2025-02-20T22:35:10Z")
A Function Module in SAP is a reusable, modular piece of code that performs a specific task. It is part of the ABAP (Advanced Business Application Programming) language and is stored in the Function Builder (SE37). Funct… --- ## [Google Ads returns large values for Micro Columns](https://community.cdata.com/t/google-ads-returns-large-values-for-micro-columns/1019)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [February 12, 2025, 10:53pm UTC](https://community.cdata.com/t/google-ads-returns-large-values-for-micro-columns/1019 "2025-02-12T22:53:23Z")
When working with the Google Ads API, we often encounter discrepancies between the numeric values returned by the API and the values displayed on the Google Ads UI. This difference arises because the API returns certain … --- ## [Creating a Custom OAuth App on Snowflake](https://community.cdata.com/t/creating-a-custom-oauth-app-on-snowflake/995)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [January 13, 2025, 4:32pm UTC](https://community.cdata.com/t/creating-a-custom-oauth-app-on-snowflake/995 "2025-01-13T16:32:30Z")
Snowflake uses the OAuth, which requires the authenticating user to interact with Snowflake via the browser. The way we create a custom OAuth app, is by creating an integration object in Snowflake, which is based on the … --- ## [How to Resolve the "HTTP Protocol Error. 401 Unauthorized" in MYOB Connection](https://community.cdata.com/t/how-to-resolve-the-http-protocol-error-401-unauthorized-in-myob-connection/963)
**Author:** [@Sudarshan](https://community.cdata.com/u/Sudarshan)\ **Replies:** 0\ **Last updated:** [December 3, 2024, 9:31pm UTC](https://community.cdata.com/t/how-to-resolve-the-http-protocol-error-401-unauthorized-in-myob-connection/963 "2024-12-03T21:31:24Z")
In this article, we will guide you through resolving the “HTTP protocol error. 401 Unauthorized” encountered when connecting to MYOB. This error is typically caused by invalid credentials or authentication issues. Below … --- ## [Troubleshooting “ViewAnalyticsRestricted” PermissionException when Querying the ViewsAnalytics and ViewersAnalytics Views in Confluence](https://community.cdata.com/t/troubleshooting-viewanalyticsrestricted-permissionexception-when-querying-the-viewsanalytics-and-viewersanalytics-views-in-confluence/939)
**Author:** [@matthewr](https://community.cdata.com/u/matthewr)\ **Replies:** 0\ **Last updated:** [November 11, 2024, 10:04pm UTC](https://community.cdata.com/t/troubleshooting-viewanalyticsrestricted-permissionexception-when-querying-the-viewsanalytics-and-viewersanalytics-views-in-confluence/939 "2024-11-11T22:04:09Z")
This article contains steps for resolving the “ViewsAnalyticsRestricted” PermissionException that can be thrown when querying the ViewsAnalytics and ViewersAnalytics Views once a connection to Confluence has been establi… --- ## [Steps to create a custom role with RBAC permissions on Azure to manage an Azure Cosmos DB for NoSQL account.](https://community.cdata.com/t/steps-to-create-a-custom-role-with-rbac-permissions-on-azure-to-manage-an-azure-cosmos-db-for-nosql-account/910)
**Author:** [@Dorando\_Myslimi](https://community.cdata.com/u/Dorando_Myslimi)\ **Replies:** 0\ **Last updated:** [October 4, 2024, 9:50pm UTC](https://community.cdata.com/t/steps-to-create-a-custom-role-with-rbac-permissions-on-azure-to-manage-an-azure-cosmos-db-for-nosql-account/910 "2024-10-04T21:50:55Z")
Sometimes clients face permission errors while trying to authenticate using ‘Azure AD’ or ‘Azure Service Principal’ AuthScheme with our CosmosDB driver. One of them is the RBAC (role-based access control) error permissio… --- ## [Encountering “The schema name ‘REST’ is invalid” error when refreshing the published SharePoint data on Tableau Server](https://community.cdata.com/t/encountering-the-schema-name-rest-is-invalid-error-when-refreshing-the-published-sharepoint-data-on-tableau-server/909)
**Author:** [@kristinab](https://community.cdata.com/u/kristinab)\ **Replies:** 0\ **Last updated:** [October 4, 2024, 9:12pm UTC](https://community.cdata.com/t/encountering-the-schema-name-rest-is-invalid-error-when-refreshing-the-published-sharepoint-data-on-tableau-server/909 "2024-10-04T21:12:28Z")
In this article we are going to explain how to overcome the “The schema name ‘REST’ is invalid” error, after publishing the data source configured with the CData Tableau Connector for SharePoint from Tableau Desktop to T… --- ## [SharePoint - "Error: 917656" when using AuthScheme=SharePointOAuth"](https://community.cdata.com/t/sharepoint-error-917656-when-using-authscheme-sharepointoauth/903)
**Author:** [@Luçjano\_Capo](https://community.cdata.com/u/Lu%C3%A7jano_Capo)\ **Replies:** 0\ **Last updated:** [September 18, 2024, 8:57pm UTC](https://community.cdata.com/t/sharepoint-error-917656-when-using-authscheme-sharepointoauth/903 "2024-09-18T20:57:35Z")
Error: 917656; Access denied. Before opening files in this location, you must first browse to the web site and select the option to login automatically". This error originates from Microsoft and occurs when the app’… --- ## [Python in Linux: SAP ERP – Error Message: SAP JCo library not found: verify the correct jar file is present](https://community.cdata.com/t/python-in-linux-sap-erp-error-message-sap-jco-library-not-found-verify-the-correct-jar-file-is-present/896)
**Author:** [@Ockert](https://community.cdata.com/u/Ockert)\ **Replies:** 0\ **Last updated:** [September 4, 2024, 5:48pm UTC](https://community.cdata.com/t/python-in-linux-sap-erp-error-message-sap-jco-library-not-found-verify-the-correct-jar-file-is-present/896 "2024-09-04T17:48:30Z")
Unix environments will always utilize the Java Connector (JCo) RFC API. This error message arises when needed files are either missing, or not added to the class path. The following files will be needed: sapjco3.jar … --- ## [MongoDB - Resolving \[500\] System error: No such host is known](https://community.cdata.com/t/mongodb-resolving-500-system-error-no-such-host-is-known/895)
**Author:** [@Ockert](https://community.cdata.com/u/Ockert)\ **Replies:** 0\ **Last updated:** [September 3, 2024, 7:06pm UTC](https://community.cdata.com/t/mongodb-resolving-500-system-error-no-such-host-is-known/895 "2024-09-03T19:06:48Z")
The “No such host is known” error appears when an invalid value is used for the Server connection property. The first step is ensuring the host name or IP address is valid. MongoDB Compass is a great tool for running co… --- ## [GLSchemeCode Change track](https://community.cdata.com/t/glschemecode-change-track/880)
**Author:** [@muthuEOL](https://community.cdata.com/u/muthuEOL)\ **Replies:** 1\ **Last updated:** [August 28, 2024, 11:39am UTC](https://community.cdata.com/t/glschemecode-change-track/880 "2024-08-28T11:39:40Z")
I have GL Account Classification Mapping In Dataverse Table i used automation to pull data from Exact online and pushed data into dataverse . I need help on how to track that GLSchemeCode Changes from previous version t… --- ## [ODBC SSAS (SQL Server Analysis Services) Tabular: “\[DataSource.Error\] ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified.”](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889)
**Author:** [@Florjan\_C](https://community.cdata.com/u/Florjan_C)\ **Replies:** 0\ **Last updated:** [August 23, 2024, 7:36pm UTC](https://community.cdata.com/t/odbc-ssas-sql-server-analysis-services-tabular-datasource-error-odbc-error-im002-microsoft-odbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified/889 "2024-08-23T19:36:16Z")
“ODBC: ERROR \[IM002\] \[Microsoft\]\[ODBC Driver Manager\] Data source name not found and no default driver specified” error means that the Data Source Name (DSN) specified in the connection configuration is not being found i… --- ## [Check GLAccountCode linked with Division](https://community.cdata.com/t/check-glaccountcode-linked-with-division/882)
**Author:** [@muthuEOL](https://community.cdata.com/u/muthuEOL)\ **Replies:** 1\ **Last updated:** [August 7, 2024, 9:34pm UTC](https://community.cdata.com/t/check-glaccountcode-linked-with-division/882 "2024-08-07T21:34:49Z")
from which table we can check what are GLAccount code linked for a particular Division ? --- ## [Impact of ban of ODP RFCs on CData SAP ERP drivers](https://community.cdata.com/t/impact-of-ban-of-odp-rfcs-on-cdata-sap-erp-drivers/878)
**Author:** [@John\_G](https://community.cdata.com/u/John_G)\ **Replies:** 0\ **Last updated:** [August 1, 2024, 1:10pm UTC](https://community.cdata.com/t/impact-of-ban-of-odp-rfcs-on-cdata-sap-erp-drivers/878 "2024-08-01T13:10:07Z")
SAP Note 3255746 announced a ban on using RFCs (Remote Function Calls) included as part of the Operational Data Provisioning (ODP) Data Replication API by third parties. CData SAP ERP drivers do NOT make use of any of th… --- ## [Connecting to GitHub: OAuth, GitHub Apps, and Personal Access Tokens](https://community.cdata.com/t/connecting-to-github-oauth-github-apps-and-personal-access-tokens/875)
**Author:** [@Anil\_Kumar](https://community.cdata.com/u/Anil_Kumar)\ **Replies:** 0\ **Last updated:** [July 25, 2024, 6:16pm UTC](https://community.cdata.com/t/connecting-to-github-oauth-github-apps-and-personal-access-tokens/875 "2024-07-25T18:16:35Z")
The GitHub driver already allows for seamless connection to data sources using OAuth. When you log into the developer console and navigate to the apps page, you will find sections for GitHub Apps and personal access toke… --- ## [How to enable Oracle Logminer](https://community.cdata.com/t/how-to-enable-oracle-logminer/860)
**Author:** [@Harsh\_Paliwal](https://community.cdata.com/u/Harsh_Paliwal)\ **Replies:** 0\ **Last updated:** [July 12, 2024, 8:18pm UTC](https://community.cdata.com/t/how-to-enable-oracle-logminer/860 "2024-07-12T20:18:39Z")
1) Login to your oracle using SqlPlus with user: sys as sysdba and password : root 2) Now run the following sql queries step by step in SqlPlus: i) select name,log\_mode from v$database; The output you will get … --- ## [Reckon Accounts Hosted Common Errors](https://community.cdata.com/t/reckon-accounts-hosted-common-errors/786)
**Author:** [@LaurenH](https://community.cdata.com/u/LaurenH)\ **Replies:** 0\ **Last updated:** [June 18, 2024, 8:38pm UTC](https://community.cdata.com/t/reckon-accounts-hosted-common-errors/786 "2024-06-18T20:38:36Z")
In this article you will find typical scenarios for using the CData data providers with Reckon Accounts Hosted and how to resolve the most common error messages. Below you will find procedures and steps to resolve the m… --- ## [Troubleshooting “Cannot Find Library File: System.Data.CData.OracleOCIw.dll" Error on Linux/Ubuntu](https://community.cdata.com/t/troubleshooting-cannot-find-library-file-system-data-cdata-oracleociw-dll-error-on-linux-ubuntu/779)
**Author:** [@Tapan18118](https://community.cdata.com/u/Tapan18118)\ **Replies:** 0\ **Last updated:** [June 11, 2024, 3:20pm UTC](https://community.cdata.com/t/troubleshooting-cannot-find-library-file-system-data-cdata-oracleociw-dll-error-on-linux-ubuntu/779 "2024-06-11T15:20:01Z")
This article contains detailed steps for resolving the mentioned error that most of our customers face as they download the Oracle driver. This specifically focuses on Connect Servers installation on Linux systems (Ubunt… --- ## [Edit Generated Schema Files](https://community.cdata.com/t/edit-generated-schema-files/747)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [June 5, 2024, 7:59pm UTC](https://community.cdata.com/t/edit-generated-schema-files/747 "2024-06-05T19:59:21Z")
In this article, I will outline how to edit a newly generated schema file using our Connectors. This article will use our QuickBooks Online Power BI Connector as an example; however, this walkthrough is applicable to any… --- ## [Inserting 2 or more Journal Entry Lines using the CData Netsuite connectors](https://community.cdata.com/t/inserting-2-or-more-journal-entry-lines-using-the-cdata-netsuite-connectors/743)
**Author:** [@Zachary\_G](https://community.cdata.com/u/Zachary_G)\ **Replies:** 0\ **Last updated:** [June 4, 2024, 5:14pm UTC](https://community.cdata.com/t/inserting-2-or-more-journal-entry-lines-using-the-cdata-netsuite-connectors/743 "2024-06-04T17:14:41Z")
Inserting journal entries is more difficult then most tables, as journal entries have an additional requirement of needing at least 2 separate lines to create a new Journal Entry record. Using your CData Netsuite connec… --- ## [“\[INVALID\_PARAMETER\] Invalid search query” error when trying to query NetSuite tables](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741)
**Author:** [@DylanO](https://community.cdata.com/u/DylanO)\ **Replies:** 0\ **Last updated:** [June 3, 2024, 7:19pm UTC](https://community.cdata.com/t/invalid-parameter-invalid-search-query-error-when-trying-to-query-netsuite-tables/741 "2024-06-03T19:19:10Z")
When using any of our NetSuite connectors, you may see the following error when trying to query a table: \[INVALID\_PARAMETER\] Invalid search query. Detailed unprocessed description follows. Search error occurred: Field ‘\<… --- ## [Bullhorn: HTTP status 500, NullPointerException error](https://community.cdata.com/t/bullhorn-http-status-500-nullpointerexception-error/728)
**Author:** [@Kristian\_K](https://community.cdata.com/u/Kristian_K)\ **Replies:** 0\ **Last updated:** [May 24, 2024, 9:49pm UTC](https://community.cdata.com/t/bullhorn-http-status-500-nullpointerexception-error/728 "2024-05-24T21:49:19Z")
This error is commonly encountered during the authentication flow while establishing a connection with Bullhorn. The server triggers this error when it detects lingering old cookies from past sessions. To resol… --- ## [ApplicationAuthorizationFailed error when connecting to QuickBooks Online](https://community.cdata.com/t/applicationauthorizationfailed-error-when-connecting-to-quickbooks-online/727)
**Author:** [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\ **Replies:** 0\ **Last updated:** [May 24, 2024, 9:29pm UTC](https://community.cdata.com/t/applicationauthorizationfailed-error-when-connecting-to-quickbooks-online/727 "2024-05-24T21:29:33Z")
When testing your connection to QuickBooks Online (QBO), you may run into an error message of \[3100\] message=ApplicationAuthorizationFailed; errorCode=003100; statusCode=403. Unfortunately, this error message from QBO do… --- ## [Generating log files on Azure Application Services](https://community.cdata.com/t/generating-log-files-on-azure-application-services/683)
**Author:** [@Bergi\_M](https://community.cdata.com/u/Bergi_M)\ **Replies:** 0\ **Last updated:** [April 5, 2024, 1:17pm UTC](https://community.cdata.com/t/generating-log-files-on-azure-application-services/683 "2024-04-05T13:17:10Z")
In this knowledge-base article, we will delve into the process of generating logs for an application that utilizes the CData ADO.NET connector and is hosted on Azure App Services. After developing our ASP.NET Core app… [Next page](https://community.cdata.com/c/troubleshooting/data-sources/41.md?page=1)