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

119 Topics
217 Replies

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

119 Topics

Recently active

Most replies Most views Newest first

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

11 days ago

leoarthurApprentice

asked in CData Drivers

Best Practices for Organizing a Server Rack to Optimize Airflow and Cooling

Hey everyone,I’m looking for advice on how to effectively organize a server rack to optimize airflow and cooling. As we all know, proper airflow is crucial in preventing overheating and ensuring the longevity of our equipment. Here are a few best practices I’ve come across, and I’d love to hear your thoughts or additional tips!Top-to-Bottom Airflow: Position servers so that the air intake fans face the front of the rack, and the exhaust fans face the back. This helps create a clear path for cool air to flow in and hot air to escape. Use Blank Panels: Install blanking panels in unused rack spaces to prevent hot air from recirculating into the cold aisle, maintaining a consistent temperature. Cable Management: Keep cables organized and out of the airflow path. Using cable ties and management trays can help maintain clear airflow channels. Regular Maintenance: Regularly check and clean filters and fans to ensure that dust and debris don’t impede airflow. Monitor Temperature: Utilize tempe

12 days ago

leoarthurApprentice

asked in CData Drivers

Best Practices for Optimizing CData Data Connectors with Intel Arc GPUs

Hi everyone,I’m currently working on a project that involves using CData data connectors with Intel Arc graphics cards. I want to ensure that I’m getting the best performance and efficiency out of this setup. Could anyone share best practices for optimizing CData data connectors specifically when using Intel Arc GPUs?Best Practices:Update Drivers: Ensure that both Intel Arc drivers and CData connectors are up to date to benefit from the latest performance improvements and bug fixes. Adjust Connection Settings: Configure CData data connectors to utilize multi-threading options if available. This can enhance performance, especially with the parallel processing capabilities of Intel Arc GPUs. Monitor GPU Usage: Use Intel's performance monitoring tools to check if the GPU is being fully utilized. Adjust settings in CData to match the GPU’s performance profile. Optimize Data Queries: Design efficient queries and avoid over-fetching data to reduce processing load. This helps in balancing the

19 days 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.

2 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.

2 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?

2 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?

2 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.

2 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.

3 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

3 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,

3 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?

3 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.

4 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?

4 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

4 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

4 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

4 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

4 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

5 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

5 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

5 months ago

skuchibhotlaApprentice

asked in CData Drivers

Cdata mongodb driver failing to list collection

5 months ago

AlexTwister77Apprentice

asked in CData Drivers

Token Bearer recovery problem by script

Hello everyone ,I am trying to retrieve a Bearer Token with the GET Bearer Token script on ARC script connector : Below is my script :<arc:set attr="http.URL" value="https://prodautok.authentication.eu10.hana.ondemand.com/oauth/token?grant_type=client_credentials&token_format=jwt" /><arc:set attr="http.postdata" value='{"password":"XXXXXXX=","username":"sb-21f210cb-9a40-44f8-a78f-c23d13ceec27!b185659|it-rt-prodautok!b117912"}' /><arc:call op="httpPost" in="http" out="response">  <arc:set attr="token.text" value="[http:content]" /> <arc:call op="jsonOpen" in="token" out="handle">  <arc:set attr="json.handle" value="[handle.handle]" /> <arc:set attr="json.map:token" value="/json/access_token" /> <arc:call op="jsonDOMGet" in="json" out="result" > <!-- Se

6 months ago

PradeepApprentice

asked in CData Drivers

AS2 Connection - Invalid signature schemes

Hi Folks, When we config the AS2 connection with new partner, receiving the “Invalid signature schemes” error , below is the log info , How to resolve this Signature issue. Is it something done at CData end or the Partner end.

6 months ago

cbaptistaApprentice

asked in CData Drivers

SAP Function READ_TEXT

Hi everyone! I would like to know if is it possible to retrieve data from the SAP ECC 6.0 Function READ_TEXT, using the CData SSIS Components for SAP ERP 2023. Thanks.

6 months ago

Page 1 / 5

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

Badge winners

Dorando Myslimihas earned the badge Product Expert
Slackerhas earned the badge Product Expert
kmauzoulhas earned the badge Product Expert
Khushi Khandelwalhas earned the badge Product Expert
Jdotceehas 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.