Creating a DB connection to SAP HANA

Discussion on developing CloverETL engine, transformation components etc.

Jdubu
Posts: 2
Joined: Tue Oct 15, 2013 7:40 pm

Creating a DB connection to SAP HANA

Postby Jdubu » Tue Oct 15, 2013 7:54 pm

I am using CloverETL Designer Community edition, Version: 3.5.0.031M1 and I am trying to figure out if I can set up a connection to a SAP HANA database.

SAP provides a jdbc driver (ngdbc.jar) for use by java developers. It must be in the classpath and the url connection string is in the form:
jdbc:sap://<server>:<port>[/?<options>]

All the options to 'add driver' and 'add JAR to driver class path' are disabled in the DB connection dialog. That is where I was expecting to add ngdbc.jar.

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: Creating a DB connection to SAP HANA

Postby kubosj » Thu Oct 17, 2013 8:36 am

Dear Jdubu,

You are trying correct functionality ("add-driver") but unfortunatelly custom JDBC drivers are not supported in Community edition. You can download Trial version and check there - see http://www.cloveretl.com/download
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com

Jdubu
Posts: 2
Joined: Tue Oct 15, 2013 7:40 pm

Re: Creating a DB connection to SAP HANA

Postby Jdubu » Mon Oct 21, 2013 2:27 am

I downloaded the trial version as you suggested and have good news. I was able to easily establish a database connection, create metadata and run a test graph that reads from the database.

Adding the driver worked exactly as expected. When creating metadata or issuing a query to read from the database the only modification I had to make was to add double quotes as below.

CloverETL Generated: Select * from schemaname.tablename

Modification: Select * from "schemaname"."tablename"

I am sure there must be a way to configure Clover to generate the query with the proper quotes but I ran out of time.

kubosj
Posts: 372
Joined: Thu Jan 12, 2012 9:10 am

Re: Creating a DB connection to SAP HANA

Postby kubosj » Mon Oct 21, 2013 9:51 am

Dear Jdubu,

I am glad to hear you were able to connect SAP Hana. We have selection of "JDBC specific" in Database connection wizard. Unfortunately SAP Hana is not among supported databases and therefore JDBC specific for it is missing. I will ask development team to add it - see https://bug.javlin.eu/browse/CLO-2254 for details.

As temporary workaround you may try to select various JDBC specific. There is big chance SAP Hana will be compatible with some existing database.
Jaroslav Kubos
CloverCARE Support
CloverETL | Rapid Data Integration

Visit us online at http://www.cloveretl.com