Skip to main content
Solved

Connect to a Datalake through JDBC -> ODBC Bridge


avanrijn
Contributor
Forum|alt.badge.img+2

Dear Sir,

For one of our customers we need to connect with TX to a Datalake (CSI Cloud).
Our customer is able to connect with PowerBI to their Datalake with a JDBC → ODBC Bridge piece of software from ZappySys JDBC Bridge Driver. This works fine.

Now we need to connect with TimeXtender without this third party JDBC Bridge Driver software to save our client some ZappySys license money.

So I checked with the CData component in TimeXtender, but it seems their is no JDBC → ODBC Bridge Driver available...

Question: Is their a way to do this with the best Data Management Platform in the world ?

Hope you can shine a light on this.

Thanx in advance.

 

Regards from Amsterdam,

Arthur
Fourpoints TimeXtender Partner

Best answer by rory.smith

@avanrijn ,

 

you shouldn't need a JDBC-ODBC bridge as that only converts JDBC calls into ODBC calls. Having an ODBC (or OLEdb or ADO) driver should be enough. JDBC bridges are only really useful in a Java software development context.

View original
Did this topic help you find an answer to your question?

Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • March 13, 2023

Hi Arthur

What is CSI Cloud?

I searched for it, but could not really find anything that seemed to be correct.
CData also provides a JDBC bridge, but it is not a specific data source you can choose.


rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • TimeXtender Xpert
  • March 13, 2023

@avanrijn ,

 

you shouldn't need a JDBC-ODBC bridge as that only converts JDBC calls into ODBC calls. Having an ODBC (or OLEdb or ADO) driver should be enough. JDBC bridges are only really useful in a Java software development context.


Thomas Lind
Community Manager
Forum|alt.badge.img+5
  • Community Manager
  • March 13, 2023

Yeah, I agree with Rory.

You need to figure out what sort of data source they connected to with the bridge and see if you can figure out what kind you need. Likely a CData provider will exist, hence what my question about what CSI cloud is.


Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

@avanrijn any updates on this? please let us know so we can try to help with the connection to the CSI cloud :)


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings