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

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?

I’m using the cdata connector to load from snowflake to Microsoft dynamics dataverse target.I have tested the following approach:I have tested with JDBC_IC connection and the reject records are captured in error file but processes the good records. While running with the JDBC V2 connection the mapping fails when it encounters a record and rolls back all record.Any suggestions on creating error record file with JDBC V2 would be very helpful

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.   

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.

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

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,

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?

Hi Ethem, i am able to connect freshbooks, except invoices object, all other objects are showing an error. kindly assist me on this. i am attaching an error image please check and suggest Thanks,Chari

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. 

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?

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

Hi Team, i am unable to connect my freshbooks using Cdata connection kinldy share me the connection properties. in Freshbooks site there is an option to create app under that app all settings are attached as an attachment. please check and suggeset Thanks,Chari 

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

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 fi

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

Hi Ethem, i am unable to the data in customerinvoices object. any filters do we need to appliy kindly help me.i have attached the error images please check.. Thanks,Chari

Hi Ethem Q,i have created the ssis package using the CData workday drivers. package is running smoothly when it is in SSIS compailor. and i am trying to schedule this package as agent job in sql server, it is failing with below error. kindly help me in this.. MessageExecuted as user: XXXXXXXXX\RKASEE. Microsoft (R) SQL Server Execute Package Utility  Version 15.0.2000.5 for 32-bit  Copyright (C) 2019 Microsoft. All rights reserved.    Started:  2:13:56 PM  Error: 2024-04-26 14:15:59.96     Code: 0xC0047062     Source: Workday_BankAccounts CData Workday Source [609]     Description: CData.SSIS.Workday.WorkdayException (0x80004005): [500] Request timed out. Either there is a server issue, or you've entered wrong credentials or wrong callback url. ---> jwo230k.Rx: Request timed out. Either there is a server issue, or you've

Hi Team, in workday SSIS cdata connector whatever my team has been created new views based on workday system datasets are not visible on views dropdown list. is there any permissions issue?  or user created views we will not see? kidnly Suggest. Thanks,Renukachari [email protected]

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 

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 in

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

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

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">  <!-- Pass in the json response that contains the token to jsonOpen. -->  <arc:set attr="token.text" value="[http:content]" />  <arc:call op="jsonOpen" in="token" out="handle">    <!-- Call jsonDOMGet with the handle that was obtained from jsonOpen. --

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.