Recently I had to connect Pentaho Data Integration to SAP HANA and I made some notes along the way:
The first step is to get the SAP HANA JDBC driver, a file called ngdbc.jar. The quickest way is toÂ download and install the SAP HANA client from the SAP Software Download Center, and then extract the file from your installation directory
(C:\Program Files\sap\hdbclient\ onÂ Windows,Â /usr/sap/hdbclient/ on Linux)
If you donâ€™t have a user account for the SAP Software Download Center, youâ€™ll need to get the driver from some other source. For example:
- Install the SAP HANA tools into eclipse (oh, yeah, you may need to install eclipse first)
- Look for the eclipse plugin filesÂ that were installed with the SAP HANA tools Â (mine were in <home_folder>/.p2/pool/plugins)
- Look for any jar file with jdbc on its name. I found one calledÂ com.sap.ndb.studio.jdbc_2.3.5.jar.
- Change the jar extension to zip and unpack it. Cross your fingers.
- Look for a lib directory and see if the ngdbc.jar file is in it.
- Repeat 4,5 until you find the file.
(I donâ€™t getÂ why SAP wants to hinder development for their platform by making it almost impossible to get their JDBC driverâ€¦ but anywaysâ€¦)
Go to the folder where you installed Pentaho Data Integration and copy your recently obtained ngdbc.jar file into the lib directory.
Restart (or start) Pentaho Data Integration.
Pentaho Enterprise Edition:Â If you have the Enterprise Edition of Pentaho Data Integration, doing a bulk load in SAP HANA is pretty straightforward. Just follow the instructions here.
Pentaho Community Edition: I believe Pentaho doesnâ€™t provide the SAP HANA bulk load plugin forÂ you. In that case, you need to set up a Generic Database connection and use a regular table output step.
Create a new transformation, and then create a new connection.
Per this page, we learn that the connection string for a SAP HANA connection is
Where the port is
So if your instance number is 10, the port would Â be 31015.
The custom driver class name is com.sap.db.jdbc.Driver
Fill the form, click test, Ok and youâ€™re good to go!
You may now use this connection to read/write data from/to SAP HANA.
I tested this with PDI 4.4, 5.4 and 6.1. Help me keep this post updated by pinging me at twitter if any of this is no longer valid.