- - Knowledge base overview
Ideas
Updates
Events
Groups

Home
Community
Live Connectivity
CData Drivers

CData Drivers

Share product questions and get support for CData Drivers & Connectors

122 Topics
227 Replies

When you subscribe we will email you when there is a new topic in this category

122 Topics

Recently active

Most replies Most views Newest first

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?

3 minutes ago

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

190

6 days ago

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.

538

25 days ago

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?

301

27 days ago

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

211

29 days ago

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

652

1 month ago

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.

441

3 months ago

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.

501

3 months ago

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?

421

3 months ago

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?

171

3 months ago

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.

751

3 months ago

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.

782

4 months ago

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

151

4 months ago

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,

441

4 months ago

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?

571

4 months ago

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.

521

5 months ago

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?

562

5 months ago

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

1412

5 months ago

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

2853

5 months ago

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

1261

5 months ago

PratikVEmployee

asked in CData Drivers

Which Data Source supports Direct Query Mode in Power

Hi All,Repeatedly, customers have raised inquiries regarding the compatibility of Power BI's direct query mode with various data sources. They seek clarification on which specific data sources are supported by this featureThe sample image for the same is as below: The Answer to the question is that the support for direct query mode in Power BI is determined by Microsoft rather than CData. To ascertain which data sources are compatible with direct query mode, it's advisable to refer to the provided link from Microsoft's official documentation. This resource will offer comprehensive information regarding the supported data sources for direct query functionality within Power BI.https://learn.microsoft.com/en-us/power-query/connectors/Choose the data source relevant to your specific use case. If you find "DirectQuery" listed under the "Capabilities Supported" section for that particular data source, it indicates that the data source supports the Direct Query method.For example, if you're u

1452

5 months ago

RuppieApprentice

asked in CData Drivers

Experience with SAP Data Lake Relational Engine ?

Hello,i have an account a free SAP HANA Cloud.While i have no difficulties connecting to the SAP HANA DB itself by using severall Drivers and applications i haven’t found a solution for etablishing a connection two the SAP HANA DB Data lake to use the Data Lake relational Engine. There is an official Client available from SAP but only fpr regsieterd SAp users.Question is: Doas someone have made successfull connection two SAP Data Lake by using cdata drivers and can explain how two configure the driver settings ? Thnaks in advance

1186

6 months ago

cbaptistaApprentice

asked in CData Drivers

Help with CData SAPERP RFC parameters

Hello everybody! I’m facing the following situation when trying to execute an RFC trought CData connector for SAP ERP...In SAP, I've created an RFC to retrieve additional data for our needs, it works and have these parameters: The PT_DOCNUM has the following structure: It receives a list of documents and fiscal years to further processing as input in PT_DOCNUM. The returning data is in CT_DATA.According to this page (https://cdn.cdata.com/help/RYJ/rssis/pg_datamodel.htm) I can call the function trough EXEC statement.I’m using SSIS inside Visual Studio 2019 to achieve this step. The test flow is as follows (Using the CData Source component): The first attempt was to fill the DOCS#TEMP table and execute the RFC in the same call: When I execute the above, the RFC is called but no parameter is received on the function (PT_DOCNUM headerline and table are both empty): The second approach, If I use the static JSON command to pass the values it works, for example: Data is retrieved with a bott

921

6 months ago

skuchibhotlaApprentice

asked in CData Drivers

Cdata mongodb driver failing to list collection in dbeaver

Hi, I am getting below error when connecting to mongoDB instance using kerberos.Failed to authenticate database 'instrument', Cannot invoke "XcoreXmongodbX220X8326.qff.c(String)" because the return value of "XcoreXmongodbX220X8326.igf.a()" is null. connection string used: jdbc:mongodb:AuthScheme=GSSAPI;Server=wh-171d272d46.svr.us.jpmchase.net;Port=27040;UseSSL=True;KerberosRealm=exchad.jpmchase.net;KerberosTicketCache=C:\Users\R654476\krb5cc_R654476;SSLServerCert=*;ReplicaSet=wh-1761a58f43.svr.us.jpmchase.net:27040,wh-113139d5b5.svr.us.jpmchase.net:27040;logFile=I:\OMNI-DB2-CERTIFICATES\mongodb-driver.log;Verbosity=5;AuthDatabase=%24external;readPreference=primary;Database=instrument;kerberosServiceRealm=exchad.jpmchase.net driver class name: cdata.jdbc.mongodb.MongoDBDriver

761

6 months ago

skuchibhotlaApprentice

asked in CData Drivers

Cdata mongodb driver failing to list collection

371

6 months ago

Page 1 / 5

Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

Jackolashas earned the badge Product Expert
Amit Sharmahas earned the badge Product Expert
Tnerbhas earned the badge Product Expert
isladavidhas earned the badge Product Expert
Sachahas earned the badge Product Expert

Show all badges

Terms and Conditions Cookie settings

Sign up

Already have an account? Login

CData Community

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.