Real-Time Connectivity

Ask questions, get answers, and engage in discussions about real-time data connectivity solutions from CData.

131 Topics

E
ekanshdEmployee
asked in CData Drivers & Connectors

"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

1
L
2 days ago
T
Tapan18118Employee
asked in CData Drivers & Connectors

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

1
L
2 days ago
PratikV
PratikVEmployee
asked in CData Drivers & Connectors

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

2
PratikV
4 days ago
R
Renukachari_KaseeCollaborator
asked in CData Connect Cloud

unable to view the data from customerinvocies view

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

3
Ethem Q
10 days ago
R
Renukachari_KaseeCollaborator
asked in CData Connect Cloud

Unable to schedule the CData SSIS job in sql server Agent job.

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 entered wrong credentials or wrong callback url.     at jwo230k.FFZ.Ra(Rx )     at jwo230k.FFZ.pg(uNj )     at jwo230k.uPB.K(WP , uNd )     at jwo230k.uPB.G(WP , uT

1
Ethem Q
21 days ago
R
Renukachari_KaseeCollaborator
asked in CData Connect Cloud

Unabale to see the user created workday views/datasets on CData SSIS connector

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 Kaseerenukachari.kasee@redwood.com

3
Ethem Q
21 days ago
R
RuppieApprentice
asked in CData Drivers & Connectors

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 

6
Ethem Q
21 days ago
James T
James TEmployee
asked in CData Connect Cloud

Does Connect Cloud support incremental refreshes in PowerBI?

I am importing some very large tables into PowerBI. Each time the data refreshes, the process gets slowed down since all of the data is getting requested/refreshed.Does Connect Cloud support updating/refreshing the data incrementally?

3
James T
22 days ago
John
JohnCommunity Manager
posted in (C)Data Virtuality

Insights from Our Recent Webinar: "Five Styles of Data Integration"

Thank you to everyone who joined our recent webinar featuring Kevin Petrie and Nick Golovin on "Five Styles of Data Integration." We gathered some insightful questions from the audience and have provided detailed answers below. We hope these will help you better understand the different data integration techniques and how they can be applied in various scenarios. Question 1: Competitive Advantage of Reverse ETLQuestion: Can you please tell me if Reverse ETL has any competitive advantage over the other techniques? Especially regarding removing silos?Answer: Reverse ETL, where data is moved from a data warehouse back into an application, complements rather than competes with other data integration techniques. It's not typically used to remove silos but to enhance application data with insights generated from the data warehouse. Question 2: Managing Dual VirtualizationsQuestion: What if we have two virtualizations: SAP Data Sphere for ERP and another virtualization for Non-ERP data?Answer

0
John
24 days ago
C
cbaptistaApprentice
asked in CData Drivers & Connectors

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

1
L
28 days ago
S
skuchibhotlaApprentice
asked in CData Drivers & Connectors

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

1
L
1 month ago
S
skuchibhotlaApprentice
asked in CData Drivers & Connectors

Cdata mongodb driver failing to list collection

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

1
L
1 month ago
John
JohnCommunity Manager
published in (C)Data Virtuality

CData Software Acquires Data Virtuality | FAQF.A.Q.

 We’re excited to announce the acquisition of Data Virtuality, a leading enterprise data virtualization provider. Below is a brief FAQ designed to provide answers to a few common questions regarding this news.   If you have additional questions not covered in this FAQ, please contact us at connect@cdata.com and a member of our team will assist you.   What is CData Software? CData Software is a leading provider of data access and connectivity. Our standards-based solutions streamline data access and insulate customers from the complexities of integration across ETL/ELT, data virtualization, B2B data integration and embedded connectivity. Leading applications across SaaS, data management, integration, analytics & BI, data science, AI & machine learning, and data governance depend on CData to expand the connectivity offered within the platforms they provide their customers.   Ultimately, CData strives to simplify connectivity between all of the applications and data sources that p

2031
S
1 month ago
AlexTwister77
AlexTwister77Apprentice
asked in CData Drivers & Connectors

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">  <!-- 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. -->    <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

1
lohith
1 month ago
P
PradeepApprentice
asked in CData Drivers & Connectors

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.  

2
lohith
1 month ago
C
cbaptistaApprentice
asked in CData Drivers & Connectors

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.

2
C
1 month ago
J
Julio RavazzanoApprentice
asked in CData Drivers & Connectors

CData SQL Gateway: Problem to start multiple services on the SQL Gateway

Hi Tech Support,I am currently testing your ODBC Connector to Business Central. I managed to connect to Business Central. What I noticed was that the connection was returning all the different divisions that we have on the server. We use the connector to link an SQL Server (as a linked server) but it created a problem. We have multiple tables with the same name which I think it is normal all the different divisions have exactly the same structure tables and field names.So I decided to create multiple ODBC connections, each of them pointing at a different division (on the company field of the connector). This filtered out perfectly the different divisions.The problem is that on the “CData SQL Gateway” I can only start the connection with one of them (that happens to have the default name of “CData D365BusinessCentral Sys”) They are configured exactly the same, using different ports but pointing at different divisions (Company).On the users tab I use also exactly the same user.When I hit

4
Ethem Q
1 month ago
R
Renukachari_KaseeCollaborator
asked in CData Connect Cloud

Error from Workday SSIS connector extention question

Hi Ethem,thanks for your replay, i have updated the latest drivers in my system. after that i can see the WQL extension objects. all objects i can see but however i am seeing some more problem in this query i am attaching error image for your reference. and also one more is, please suggest how to get all the objects listed in workday, same like in sql server usually SELECT * FROM information_schema.Tables sintax used to get all objectssimilar kind of thing any sintax is it available in Workday? kidnly advise.   

3
L
1 month ago
P
PradeepApprentice
asked in CData Drivers & Connectors

Max File processed by a connector

Hi Folks, Please help to advice what will be the max number of files / max Workers a connector will be utilized in a time, since many time i could see files getting stagged up for few hours not getting processed. Then manually sending the files also take time to process, but the server CPU utilization is in optimal level. This causes the business team unable to receive files in time and causing issues,  above is the example from today 9.27 AM MYT files got queued up and not processed for nearly 1.5 hrs. Now i am manually processing them. This is simple Copy Connector. 

4
P
1 month ago
R
Renukachari_KaseeCollaborator
asked in CData Connect Cloud

Error from Workday SSIS connector

Hi Team, while connecting Workday Cdata SSIS connector below error is coming kidnly advise.“Invalid FROM clause starting with character: 6405. Invalid WQL syntax.”i am using below query from workday.select * from creditcardtransactionswhere "company_Prompt" = 'LE020 Redwood Software, Inc.' 

7
Ethem Q
2 months ago
C
CarlRayerApprentice
asked in CData Drivers & Connectors

Support for Salesforce Non Profit Cloud

HiIs support for the new objects in Salesforce’s Non Profit Cloud (NPC) built into the latest version of dbamp; this would be for objects like GiftTransaction, etc?If not, is there a timeline to provide support?Many thanks

1
C
2 months ago
S
schildersApprentice
asked in CData Drivers & Connectors

Is it Possible to Insert Checks into QuickBooks Desktop using the QuickBooks Destination?

I’m evaluating the QuickBooks Destination SSIS connector and have a specific use case of inserting checks into QuickBooks from an OLEDB source query.  When mapping the fields from the query, I noticed that the QuickBooks Destination depicts the Check Amount field as read only.  Is there a workaround that would allow me to insert new check information into QuickBooks Desktop Premier 2020 to include the check amount?

3
Ethem Q
2 months ago
D
db_maverickApprentice
asked in CData Drivers & Connectors

Cassandra to MySql RDS

HI,Is there a direct path available to migrate data from Cassandra to MySQL RDS on AWS??

1
Ankit Singh
2 months ago
garybray
garybrayApprentice
asked in CData Drivers & Connectors

odbc error hy000 using PowerBI

Have a user that gets the following error when trying to refresh the data & import more data using PowerBI.  How can I remedy this for her? 

5
Ethem Q
3 months ago
taranr_sockeye
taranr_sockeyeApprentice
asked in CData Drivers & Connectors

Cdata: PowerBI + Sage Intacct Performance

Hi!Two pronged question. What’s typical performance that should be expected with Cdata’s Sage Intacct / Power BI connector? [I’m getting about 250k rows loaded from a large data set in an hour] Are there any tricks / tips to enable faster load times for large data sets? If I want to say download the GL-Detail table from Sage intacct, waiting 4+ hours to get the information is sometimes a hard ask.Thanks in advance!

4
taranr_sockeye
3 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

  • Product Expert
    cdata_userhas earned the badge Product Expert
  • Product Expert
    Tapan18118has earned the badge Product Expert
  • Product Expert
    mja311has earned the badge Product Expert
  • Product Expert
    jussihihas earned the badge Product Expert
  • Product Expert
    TonyLhas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings