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.

1 Comment

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

Leave a Reply