{"id":2174,"date":"2016-06-22T02:49:49","date_gmt":"2016-06-22T06:49:49","guid":{"rendered":"https:\/\/www.danielpradilla.info\/blog\/?p=2174"},"modified":"2016-06-22T02:58:00","modified_gmt":"2016-06-22T06:58:00","slug":"how-to-connect-pentaho-data-integration-to-sap-hana","status":"publish","type":"post","link":"https:\/\/www.danielpradilla.info\/blog\/how-to-connect-pentaho-data-integration-to-sap-hana\/","title":{"rendered":"How to Connect Pentaho Data Integration to SAP HANA"},"content":{"rendered":"

\"pentaho-saphana\"<\/p>\n

Recently I had to connect Pentaho Data Integration to SAP HANA and I made some notes along the way:<\/p>\n

The first step is to get the SAP HANA JDBC driver, a file called ngdbc.jar<\/strong>. The quickest way is to\u00a0download and install the SAP HANA client from the SAP Software Download Center<\/a>, and then extract the file from your installation directory
\n(C:\\Program Files\\sap\\hdbclient\\<\/span> on\u00a0Windows,\u00a0<\/span>\/usr\/sap\/hdbclient\/<\/span> on Linux)<\/span><\/p>\n

If you don’t have a user account for the SAP Software Download Center<\/a>, you’ll need to get the driver from some other source. For example:<\/p>\n

    \n
  1. Install the SAP HANA tools<\/a> into eclipse (oh, yeah, you may need to install eclipse first<\/a>)<\/li>\n
  2. Look for the eclipse plugin files<\/a>\u00a0that were installed with the SAP HANA tools \u00a0(mine were in <home_folder>\/.p2\/pool\/plugins)<\/li>\n
  3. Look for any jar file with jdbc on its name. I found one called\u00a0com.sap.ndb.studio.jdbc_2.3.5.jar.<\/li>\n
  4. Change the jar extension to zip and unpack it. Cross your fingers.<\/li>\n
  5. Look for a lib directory and see if the ngdbc.jar file is in it.<\/li>\n
  6. Repeat 4,5 until you find the file.<\/li>\n<\/ol>\n

    (I don’t get\u00a0why SAP wants to hinder development for their platform by making it almost impossible to get their JDBC driver but anyways)<\/p>\n

    Go to the folder where you installed Pentaho Data Integration and copy your recently obtained ngdbc.jar file into the lib directory.<\/p>\n

    Restart (or start) Pentaho Data Integration.<\/p>\n

    Pentaho Enterprise Edition:<\/strong>\u00a0If you have the Enterprise Edition of Pentaho Data Integration, doing a bulk load in SAP HANA is pretty straightforward. Just follow the instructions here<\/a>.<\/p>\n

    Pentaho Community Edition:<\/strong> I believe Pentaho doesn’t provide the SAP HANA bulk load plugin for\u00a0you. In that case, you need to set up a Generic Database connection and use a regular table output step<\/a>.<\/p>\n

    Create a new transformation, and then create a new connection.<\/p>\n

    \"Screen<\/p>\n

    Per this page<\/a>, we learn that the connection string for a SAP HANA connection is<\/p>\n

    jdbc:sap:\/\/<server>:<port><\/pre>\n
    Where the port is<\/p>\n
    3<instance_number>15<\/pre>\n
    So if your instance number is 10, the port would \u00a0be 310<\/strong>15.<\/p>\n
    The custom driver class name is com.sap.db.jdbc.Driver<\/p>\n
    \"Screen<\/p>\n
    Fill the form, click test, Ok and you’re good to go!<\/strong><\/p>\n
    You may now use this connection to read\/write data from\/to SAP HANA.<\/p>\n
    I tested this with PDI 4.4, 5.4 and 6.1. Help me keep this post updated by pinging me at twitter<\/a> if any of this is no longer valid.<\/p>\n
     <\/p>\n","protected":false},"excerpt":{"rendered":"
    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\u00a0download and install the SAP HANA client from the SAP Software Download Center, and then extract the… Continue reading How to Connect Pentaho Data Integration to SAP HANA<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[331],"tags":[219,204],"class_list":["post-2174","post","type-post","status-publish","format-standard","hentry","category-software-development-en-en","tag-big-data-en","tag-programming","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1tlzy-z4","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2239,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-connect-to-sap-hana-using-jdbc\/","url_meta":{"origin":2174,"position":0},"title":"How to connect to SAP HANA using JDBC","author":"Daniel Pradilla","date":"27\/08\/2018","format":false,"excerpt":"Recently I had to connect a Java application 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\u00a0the SAP Hana Cloud Platform SDK from here: https:\/\/tools.hana.ondemand.com\/#cloud Choose the\u2026","rel":"","context":"In "Software Dev."","block_context":{"text":"Software Dev.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/software-development-en-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/08\/SAP-HANA-Certified.jpg?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":2234,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-build-an-api-for-sap-hana-using-strongloop-loopback\/","url_meta":{"origin":2174,"position":1},"title":"How to build an API for SAP HANA using strongloop\/loopback","author":"Daniel Pradilla","date":"30\/05\/2018","format":false,"excerpt":"One of the aspects I like the most about SAP HANA is the cloud app development environment that allows you to quickly put together a data-entry app using Fiori. Recently, I wanted to build a small JavaScript app for data querying and entry using the awesome ag-grid. The data was\u2026","rel":"","context":"In "Software Dev."","block_context":{"text":"Software Dev.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/software-development-en-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/loopback-arc.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/loopback-arc.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/loopback-arc.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/loopback-arc.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":1987,"url":"https:\/\/www.danielpradilla.info\/blog\/short-guide-to-pentaho-data-integration\/","url_meta":{"origin":2174,"position":2},"title":"A short and sweet introduction to Pentaho Data Integration","author":"Daniel Pradilla","date":"16\/08\/2013","format":false,"excerpt":"Whenever I have to create or maintain a Pentaho Data Integration scheduled job I have to go back to the Pentaho wiki or google for use cases. Although I should, I never remember the specifics and going through 2007 forum posts and outdated documentation is always a pain. Recently, I\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"6906OT_Instant Pentaho Data Integration Kitchen","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/6906OT_Instant-Pentaho-Data-Integration-Kitchen.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":1984,"url":"https:\/\/www.danielpradilla.info\/blog\/una-breve-guia-de-pentaho-data-integration\/","url_meta":{"origin":2174,"position":3},"title":"Una breve gu\u00c3\u00ada de Pentaho Data Integration","author":"Daniel Pradilla","date":"16\/08\/2013","format":false,"excerpt":"Cada vez que tengo que mantener un job de Pentaho Data Integration, tengo que volver al wiki de Pentaho o buscar en google algunos casos de uso. Aunque deber\u00c3\u00ada, nunca recuerdo los detalles espec\u00c3\u00adficos y buscar entre posts de 2007 y documentaci\u00c3\u00b3n a\u00c3\u00b1eja, es siempre doloroso. Hace poco, me tropec\u00c3\u00a9\u2026","rel":"","context":"In "Control de Proyectos"","block_context":{"text":"Control de Proyectos","link":"https:\/\/www.danielpradilla.info\/blog\/category\/controldeproyectos\/"},"img":{"alt_text":"6906OT_Instant Pentaho Data Integration Kitchen","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/6906OT_Instant-Pentaho-Data-Integration-Kitchen.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":2224,"url":"https:\/\/www.danielpradilla.info\/blog\/pentaho-is-slow-for-servers-with-too-many-home-directories\/","url_meta":{"origin":2174,"position":4},"title":"Pentaho is slow for servers with too many home directories","author":"Daniel Pradilla","date":"28\/04\/2018","format":false,"excerpt":"Over the course of two years, browsing solutions on our Pentaho 5.4 server became progressively slow. It came to a point in which you had to wait 2-3 minutes to see the list of solutions in the Pentaho User Console. The catalina log didn't say much and we didn't have\u2026","rel":"","context":"In "Software Dev."","block_context":{"text":"Software Dev.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/software-development-en-en\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1973,"url":"https:\/\/www.danielpradilla.info\/blog\/improve-sap-business-objects\/","url_meta":{"origin":2174,"position":5},"title":"How to improve your Business Objects charts","author":"Daniel Pradilla","date":"13\/08\/2013","format":false,"excerpt":"Business Objects, SAP's BI platform, is notoriously bad for data visualization. Somehow, it empowers the developers to make all the wrong decisions at the same time and create really ugly and unusable \"dashboards\". Lately, I've seen my share of ugly bobip visualizations, like the one above. Which would seem ok\u2026","rel":"","context":"In "Project Mgmt."","block_context":{"text":"Project Mgmt.","link":"https:\/\/www.danielpradilla.info\/blog\/category\/projectmanagement-en\/"},"img":{"alt_text":"disaster, disguised as a \"dashboard\"","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2013\/08\/Slide-5-SAP-BusinessObjects-4.0-Event-Insight2.jpg?resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/comments?post=2174"}],"version-history":[{"count":0,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2174\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/media?parent=2174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/categories?post=2174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/tags?post=2174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}