Skip to Content

In this blog post we are going to learn how to create a HANA Database Connection within Pentaho PDI.

1)  Go to SAP HANA CLIENT installation path and copy the “ngdbc.jar”

*You can get SAP HANA CLIENT & SAP HANA STUDIO from : https://hanadeveditionsapicl.hana.ondemand.com/hanadevedition/

/wp-content/uploads/2014/09/1_534396.png

2) Copy and paste the jar file to : <YourPentahoRootFolder>/data-integration/lib

/wp-content/uploads/2014/09/2_534397.png

3) Start Pentaho PDI and create a new Connection

* Make sure your JAVA_HOME environment variable is setting correctly.

/wp-content/uploads/2014/09/3_534401.png

/wp-content/uploads/2014/09/3_1_534402.png

/wp-content/uploads/2014/09/3_2_534403.png

4) Create a transformation,  rick click on Database connection to create a new database connection

/wp-content/uploads/2014/09/4_534404.png

5) Select “Generic Database” connection type and Access as “Native(JDBC)”

/wp-content/uploads/2014/09/5_534405.png

6)  Fill the following parameter on Settings

Connection Name: NAMEYOURCONNECTION

Custom Connection URL: jdbc:sap://YOUR_IP_ADDREES:30015

Custom Driver Class Name: com.sap.db.jdbc.Driver

User Name: YOURHANAUSER

Password: YOURHANAPASSWORD

/wp-content/uploads/2014/09/6_534412.png

7) Test your connection.

/wp-content/uploads/2014/09/7_534410.png

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. vara prasad Puram

    Hello Rene,

    I have followed the same steps to connect SAP HANA to Pentaho. But I am getting the below error message

    ” Driver class ‘com.sap.db.jdbc.Driver’ could not be found, make sure the ‘Generic database’ driver (jar file) is installed. com.sap.db.jdbc.Driver ”

    I have placed the ngdbc jar file into C:\pdi-ce-7.1.0.0-12\data-integration\lib but still getting the above error.

    Could you please provide me some solution on how to resolve this issue.

    Regards,

    VaraPrasad.

    (0) 

Leave a Reply