Skip to main content

CData Drivers

Share product questions and get support for CData Drivers & Connectors

  • 127 Topics
  • 238 Replies
127 Topics
T
TrenaATApprentice
posted in CData Drivers
Cdata connecting SharePoint files to PBI

Hi, i am using cdata for PBI Excel Online to connect my SharePoint files to PowerBI. My SharePoint folder contains secondary folders with multiple documents as well as my main excel. Is there a way to bring the names of the secondary folders into my dataset as well? It's referred to as “Folder Path” when I connect my PBI directly to SharePoint via SharePoint.Files.

371
PratikV
22 days ago
isladavid
isladavidApprentice
posted in CData Drivers
Problems with 13th Gen Intel Processor and CDATA ODBC Driver (Version 21.0) - Any Advice?

Hi everyone,I’m currently encountering some performance issues with my system, which features a 13th Gen Intel processor and is running the CDATA ODBC Driver (Version 21.0). The specific problems I’m facing include slow performance when querying databases, occasional errors when attempting to retrieve or write data, and sometimes the system just hangs while using the CDATA driver. I’ve tried several troubleshooting steps, but the issue persists.Here’s what I’ve tried so far:Reinstalling the CDATA ODBC Driver (Version 21.0) and making sure it is properly configured. Updating all system drivers and BIOS settings for the 13th processor. Ensuring the system is running the latest software updates and patches. Testing the CDATA ODBC Driver (Version 21.0) with different databases to rule out database-specific issues.Despite these efforts, the system still experiences significant performance degradation, especially when handling large data sets or executing complex queries. The 13th Gen Intel

581
E
1 month ago
S
ShakilApprentice
asked in CData Drivers
Missing Transactions in Power BI Data Model with QuickBooks Online Connector

I created a Power BI data model using the QuickBooks Online connector and successfully built some basic reports. However, I noticed that certain transactions are missing from the data. I queried all available tables but couldn’t locate these transactions. Interestingly, when I used the 'TransactionsList' stored procedure, I was able to retrieve all transactions, including the missing ones.I suspect that some transaction types, such as Payroll Checks, may not be accessible through the CData connector or Intuit Accounting API. Has anyone else encountered this issue? Is there a known limitation or a workaround to include these transaction types in the data model?

432
S
1 month ago
A
ashish.pancholiApprentice
asked in CData Drivers
Is it possible to copy selective data from SAP ECC to SAP S/4 HANA using the CDATA JDBC Driver?

I need to copy specific data from the SAP ECC 6.0 tables listed below and paste it into the matching SAP S/4 HANA tables. ADMI_FILES ADMI_RUN  ADMI_STATS ADMI_VARIAI attempted to copy the data manually, and it worked. However, could you please advise if CData JDBC Driver could be used to accomplish this?

552
A
1 month ago
marcellosalas
marcellosalasApprentice
asked in CData Drivers
Issues Connecting to SQL Server with CData ADO.NET Provider - Need Help with Authentication Setup!

Hello everyone,,I am working on setting up a connection between my SQL Server database and a C# application using the CData ADO.NET provider for SQL Server but I am running into some authentication issues. I would like to use Windows Authentication but it doesn’t seem to be working as expected: I have double checked the connection string settings and ensured that "Integrated Security" is set to true. However,,, I keep getting an error related to login credentials.Has anyone here dealt with similar authentication issues using CData’s ADO.NET provider: ?? Also, if there’s a workaround to ensure the connection uses the current user’s Windows credentials,,, I would really appreciate any guidance. I have already gone through this thread https://community.cdata.com/cdata-sync-47/cdata-sync-error-when-creating-a-source-connection-to-sql-server-rpa/ but couldn’t get enough solution.Thanks in advance for your help, any suggestions or resources would be a huge help as I troubleshoot this.With Re

691
L
2 months ago
D
DaveJones4Collaborator
asked in CData Drivers
Dataverse ODBC Driver - How to select dynamic fields

Hi, I’m confused on how to select the dynamic fields. When I look in the driver ui, I can see the dynamic fields like “createdbyname” which are populated based on the values in “createdby” - but if I try to query using `select createdbyname from account` I get an error: “Query failed: [0x80060888] Could not find a property named ‘createdbyname’ on type ‘Microsoft.Dynamics.CRM.account’” Is there something special I need to do to be able to do this? In TSQL with ssms I can select these fields without issue. Reading through the docs, I don’t see a driver setting that seems like it would enable this feature. Can anyone tell me what I’m missing? 

974
PratikV
2 months ago
A
Amit SharmaApprentice
asked in CData Drivers
Dremio - Cdata cosmos mongodb Data Read

Hi Community, I have installed Cdata cosmos mongodb driver for a poc and i am able to connect Azure Cosmos Mongo db. In jdbc ui inferface and in data model tab i am able to see the collections along with data. but when i try to query the same from dremio i get error "unknown operator: $readPreference”. can someone help me on this issue?  RegardsAmit

410
A
2 months ago
D
DaveJones4Collaborator
asked in CData Drivers
Using Dataverse ODBC - how to query choicelabels?

Using the ODBC driver, I am trying to query ChoiceLabels - this simple query works in SSMS but not using the ODBC driver in my reporting application: select * from choicelabels The odbc driver returns:A table could not be found that matches choicelabels.Is there something else I need to do to query this table? I need to join it against an entity table in order to decode the choice value.   

648
Ethem Q
3 months ago
M
matthewrEmployee
asked in CData Drivers
Encountering "The catalog needs to be specified in the TABLE or VIEW property" error when querying an Oracle connection

When specifying the name of a table in the Tables connection property (or the name of a view in the Views property), you may receive the following error when querying a table in your Oracle connection (even if the connection was successfully tested):The catalog needs to be specified in the TABLE or VIEW property.However, Oracle does not make use of catalogs. With this in mind, what should be done to work around the error?

361
M
3 months ago
E
emmanuelkattoNewcomer
asked in CData Drivers
Methods for achieving real-time data synchronization - Emmanuel Katto

Hello Everyone, My name is Emmanuel Katto. I wanted to know what are the methods for achieving real-time data synchronization using CData connectors? Are there particular connectors better suited for this? Looking forward to your suggestions. Thanks in advance! Best,Emmanuel Katto

241
Ethem Q
3 months ago
J
JdotceeApprentice
asked in CData Drivers
Visual getting started guide for JDBC ODBC driver

Do we have a visual JDBC ODBC bridge getting started guide? Unfortunately, I’m a visual learner and I can’t find visual resources on how to set it up on my device. I’m using Microsoft Server

822
J
3 months ago
G
GawriApprentice
asked in CData Drivers
Error : cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

Hi All,I am trying to connect my dynamics GP web services through python but I am unable to do so. I was working out the basic code given on their website and still unable to work it out. Could you advise any probable solution for it?ERROR:cdata.dynamicsgp.DatabaseError: [500] Could not execute the specified command: Failed to log into Dynamics GP Server, please check your settings. Error message: HTTP protocol error. 404 Not Found.

481
Ethem Q
5 months ago
R
RajeshApprentice
asked in CData Drivers
Delta lake supported?

Hi,I don’t see a connector for “delta lake” on Azure Data Lake Store Gen2. Is this not a supported source? If not, is it on the roadmap? Thanks.

571
EndritS
5 months ago
James T
James TEmployee
asked in CData Drivers
How can I set up Tableau Bridge with a CData ODBC Drivers?

I found out that I need Tableau Bridge in order to “bridge” my CData ODBC driver with Tableau Cloud. Do you have any instructions you can share?

591
James T
5 months ago
James T
James TEmployee
asked in CData Drivers
Can I use Custom Filters in Tableau to set up Incremental Refresh?

I have a lot of data in my data source that I am trying to use with Tableau. When using CData connectors, is there a way I can help improve performance by only pulling in changed data?

181
James T
5 months ago
T
thebank987Apprentice
asked in CData Drivers
How do I use ArcESB to retrieve data from restful API using a webhook, then take that data and import it into SQL Server Management Studio?

I have a project where I need to retrieve data from a RESTful API. I have already created my request script and tested it in POSTMan.  I would like to retrieve data from the RESTful API’s response, input the data into SQL Server Management Studio.  My Question is what is the appropriate flow of connectors to build this? The Goal is to use a Webhook to retrieve data from the RESTful API, then be able to import that data into tables in SQL Server Management studio.   

811
Rohit
6 months ago
N
ntropicApprentice
asked in CData Drivers
JDBC Azure DataBricks and AzureServicePrincipal Authentication

I am trying to understand the driver behavior when connecting to an Azure DataBricks workspace using AzureServicePrincipal. Given the Azure Service principal and secret it seems to first obtain the Azure AD token and then it tries to call DataBricks REST API using the Azure AD token to obtain a Personal Access Token for the service principal. This is a problem because we do not allow personal access tokens in our environment. Is there a reason why it cannot use the Azure AD token directly to obtain access? Appreciate any insights or help.

952
N
6 months ago
R
RajaApprentice
asked in CData Drivers
CDATA jdbc excel license for ODI Prod and non Prod servers both local and server agents

HiPlease anyone explain the licensing requirement for Oracle Data Integrator (ODI) using CDATA jdbc driver for excel? We have purchased the cdata jdbc excel driver for ODI however not sure if we can use the license on both PROD and non PROD servers as its two different servers and two ODI agents. Do we need to generate the license file on both server from one license? and also we have local agent and server agent in ODI so how do we use the licence wisely?  How do we make use of the license on both prod & non-prod and local & server agents in ODI?  ThanksRaja

171
Ankit Singh
6 months ago
P
PravallikaMApprentice
asked in CData Drivers
CDATA SFTP Driver

I am using CDATA SFTP control flow CDATA-sftp-download procedure to download all the files from SFTP server to sql server , its working fine when the files are available on SFTP server but getting  error unable to populate result columns for single row type, query returned a empty set  when trying to execute the when the files are not present on server.Any idea how to solve this error. Thanks,

481
Ethem Q
6 months ago
N
Naomi YEmployee
asked in CData Drivers
Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'.

I’m using the Dynamics365 ODBC Driver with SQL Gateway to create a Linked Server. When I try creating a Service within SQL Gateway using a new System DSN, I run into this error of  Error: 'Unable to create data source with driver 'DriverType=ODBC;Platform=64', Keyword not supported: 'DRIVER'.'. How do I resolve this issue?

701
N
6 months ago
T
TheDataDevsApprentice
asked in CData Drivers
NetSuite SSIS connector issue

I am creating a simple ETL package in Visual Studio 2022. I have a data flow using Cdata DataSource, and an OLE DB as the destination. I open the cdata netsuite source editor, select the transaction via and hit ok and visual studio just sits there and hangs. 

621
Ethem Q
7 months ago
A
AbdulApprentice
asked in CData Drivers
CData ODBC Scheduled Refresh

I am using CData Connector (ODBC)  with PowerBI to access my data (Zoho CRM). Is there a way to configure a scheduled refresh? Is this even something that can help me?

582
L
7 months ago
D
DSistemasApprentice
asked in CData Drivers
No Firedac components to install in RAD Studio 12 Athena; is it planned to be released?

We have our subscription active; and installed Delphi 12/Athena and downloaded the 2023 components.But in the installer there is no option to install in RAD Studio 12.0 Athena:Will there be an update for this version 12?Regards

1892
D
7 months ago
E
ekanshdEmployee
posted in CData Drivers
"Could not load JDBC driver class” Error in Oracle Data Integrator when working with an agent

In this article, we will walk through how to resolve an error received in Oracle Data Integrator (ODI) when trying to connect with our JDBC Drivers. Below is an example of the error, specifically the first line in the Exception Stack Trace. java.lang.RuntimeException: java.lang.IllegalArgumentException: Could not load JDBC driver class [cdata.jdbc.<Driver Name>]  This error message indicates that the Driver is not accessible to ODI and therefore, ODI could not load it. The steps to resolve this error are as follows:Place the JAR and LIC files of the JDBC Driver within ODI’s userlib directory if you’re working without the agent. The location of the userlib directory is dependent on OS.  UNIX system: $HOME/.odi/oracledi/userlib Windows systems: %APPDATA%\odi\oracledi\userlib Please note that if we’re working with an oracle agent in ODI then we need to place the .jar and .lic files in both the locations which are as follows:UNIX system: $HOME/.odi/oracledi/userlib. and $ODI_HOME/odi

3603
L
7 months ago
T
Tapan18118Employee
posted in CData Drivers
Optimizing BLOB Data Extraction from Oracle Database with Connect Server

Exploring databases and retrieving information from standard data types such as varchar, string, or char is usually straightforward. However, dealing with BLOB (Binary Large Object) type columns introduces added complexity to the process.Generally, BLOB refers to Binary Large Object, representing a collection of binary data stored as a single entity. This encompasses various file types such as images, videos, spreadsheets, and PDFs, all stored within cells designated as BLOB.In this discussion, we'll delve into the process of accessing a PDF file stored within a BLOB type column via Connect Server, ensuring the preservation of both the file's integrity in terms of size and its actual content. Firstly, I have created a database featuring four columns: ID, FILE_NAME, FILE_TYPE, and COLUMN4. COLUMN4 was specifically designated as the BLOB type column within the database. Below is a screenshot illustrating this setup. Within this table, there are two records, each storing a PDF file within

1761
L
7 months ago
Terms and ConditionsCookie settings