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://:[/?]
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.
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
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.
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.