Real-Time Connectivity

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

127 Topics

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 

1
Ethem Q
2 hours 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
3 hours ago
S
SageApprentice
asked in CData Connect Cloud

How to contact SAge 50 Accounting Support 888/3OO-9183 @24*7(Toll-Free-Number)

Get expert help and support for Sage 50 Accounting Support (̲8̲8̲8̲)̲3̲0̲0̲-̲9̲1̲8̲3̲. Contact us for assistance with any issues or questions you may have. Sage 50 Accounting Help (̲8̲8̲8̲)̲3̲0̲0̲-̲9̲1̲8̲3̲ stands out as a popular choice among businesses of all sizes. However, even the best software can encounter issues, making reliable customer support indispensable for users.Understanding Sage 50 Accounting 888.3OO-9183Sage 50 Accounting support 888.3OO-9183 is a comprehensive software solution designed to streamline financial management for businesses. With features like invoicing, expense tracking, and payroll management, it offers significant benefits for users looking to optimize their accounting processes. Despite its many advantages, users may encounter various challenges while using Sage 50.The Importance of Customer Support 888.3OO-9183Customer support plays a crucial role in ensuring a smooth experience for Sage 50 users 888.3OO-9183. When issues arise, prompt resolution is

0
S
10 hours ago
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

0
E
1 day 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
2 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
6 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
16 days 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
16 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

1
Ethem Q
22 days 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
28 days 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
28 days 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
30 days 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
1 month 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
1 month 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
1 month 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
2 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
2 months ago
D
db_maverickApprentice
asked in CData Connect Cloud

Cassandra to MySQL Db migration is failing

Hi,I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.The migration job ran for 11 hours and then failed with below error:2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hen

1
John
2 months ago
D
db_maverickApprentice
asked in CData Connect Cloud

Db migration is failing for large tables : Cassandra to MySQL

Hi,I have been trying to migrate data from cassandra to mysql..The size of the source data table is approx. 4.5 GB.The migration job ran for 11 hours and then failed with below error:2024-01-24T22:13:40.908+0530    1    [2|Q-Id]    [SQL |Cache ] The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Cache ] Cache failed: The operation timed out.2024-01-24T22:13:40.955+0530    0    [2|Q-Id]    [SQL |Cache ] Replication Failed. Error:The operation timed out.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:cdata.jdbc.cassandra.CassandraDriver]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:MySQL]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [RealDB:Derby]The connection is disconnected.2024-01-24T22:13:40.955+0530    1    [2|Q-Id]    [SQL |Messag] Query Failed: [REPLICATE [orderdashboard] WITH _id = 'dVliqUz79KW/pJr8i8+vNg==', ReplicateID = 'ym5RUxyrxDweS3YeOqwAow==' SELECT * FROM [hen

1
A
2 months ago
C
carmel.ronNewcomer
asked in CData Drivers & Connectors

Salesforce driver - json data

I upgraded the Salesforce JDBC  driver from version 21 to 23.There is a difference in behavior between the 2 versions : I execute this query and get different results: SELECT User.Name FROM User On version 23:{  "Name": "Carmel"} On version 21:“Carmel”Is this the expected behavior? Is there a fix for it? 

1
Ethem Q
2 months ago
K
KevinApprentice
asked in CData Drivers & Connectors

Attribute id is required by quickbooksadodesktopupdate

Quickbooks - ODBC call is failing when trying to update a column using a Passthrough query in MS Access. It appears to only fail when there are multiple records to update. Works fine with a single record. SQL string looks like this:UPDATE SalesReceiptsSET DepositAccount = ‘Checking’WHERE Date=’2024-01-01’;Persistent connection is ENABLED  

1
Ethem Q
3 months ago
Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=

Badge winners

  • Product Expert
    Sagehas earned the badge Product Expert
  • Product Expert
    Ruppiehas earned the badge Product Expert
  • Product Expert
    ekanshdhas earned the badge Product Expert
  • Product Expert
    jacob fhas earned the badge Product Expert
  • Product Expert
    skuchibhotlahas earned the badge Product Expert
Show all badges
Terms and ConditionsCookie settings