Experience with SAP Data Lake Relational Engine ?

Hi @Ruppie,

Thank you for raising your question here. We ran some tests with a similar trial instance for SAP Hana Cloud Data Lake and it does look like something is preventing the connection from being established when using the CData SAP Hana connector. At this point, I am not sure that the SAP Hana driver can support this kind of instance at this time, but we will be sure to investigate further. 

After searching a bit around I came across the following resources from SAP which seems to indicate that it is possible to make a connection via JDBC to the Data Lake Relational Engine:

https://developers.sap.com/tutorials/hana-cloud-dl-clients-jdbc.html 

What caught my attention in the steps above is that the JDBC driver being used in this tutorial is an JDBC driver for SQLAnywhere which can be noticed from the connection string provided. With this information in mind I went ahead and attempted to connect to the trial SAP Data Lake instance via our SybaseIQ driver (which supports SQLAnywhere connections as well) and actually managed to establish a successful connection.

Now, I am not fully confident if this approach would help you accomplish what you need but if you want to give this a try I can certainly point you in the right direction. For this, you would first need a newer version of the CData SybaseIQ connector as we have just recently added support for SQLAnywhere instances with SSL support and this is not reflected in the website builds as of yet.

I would recommend you submit a support ticket or reach out to the support team at support@cdata.com and ask for an updated version of the CData connector for SybaseIQ so that we can further assist you.

Hi @Ruppie 

As mentioned in the above post, you will need an updated version of the Sybase IQ connector and I can only provide that via email support. Kindly raise a ticket in support or reach out to support@cdata.com and we will follow up with the newest version.

With the updated driver i got from you it works as decribed

I was able two read at least the database schema.

Have two cross check it with ordinary DB client but it looks fien so far ;-)

Again: Many thanks for the professional rapid help ;-) 

Will report about small sample projekt when done .

Note: Is it allowed two foreward “special version of driver” two other colleaues or ist it currentyl an unifically version you don’t wan’ to publish to other ;-)