ngdbc.jar<\/strong>) from the archive. You will find the driver in the archive inside a hidden folder under: repository\/.archive\/lib\/ngdbc.jar)<\/p>\nUse the driver with the connection string<\/p>\n
jdbc:sap:\/\/<server>:<port><\/pre>\nWhere the port is<\/p>\n
3<instance_number>15<\/pre>\nSo if your instance number is 10, the port would be 310<\/strong>15.<\/p>\nThe custom driver class name is<\/p>\n
com.sap.db.jdbc.Driver<\/pre>\n <\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
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 latest “Java Web Tomcat 8”… Continue reading How to connect to SAP HANA using JDBC<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":"","jetpack_post_was_ever_published":false},"categories":[331],"tags":[219,346,204],"class_list":["post-2239","post","type-post","status-publish","format-standard","hentry","category-software-development-en-en","tag-big-data-en","tag-hana","tag-programming","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1tlzy-A7","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2174,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-connect-pentaho-data-integration-to-sap-hana\/","url_meta":{"origin":2239,"position":0},"title":"How to Connect Pentaho Data Integration to SAP HANA","author":"Daniel Pradilla","date":"22\/06\/2016","format":false,"excerpt":"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\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\/2016\/06\/pentaho-saphana.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2016\/06\/pentaho-saphana.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2016\/06\/pentaho-saphana.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2234,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-build-an-api-for-sap-hana-using-strongloop-loopback\/","url_meta":{"origin":2239,"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":1973,"url":"https:\/\/www.danielpradilla.info\/blog\/improve-sap-business-objects\/","url_meta":{"origin":2239,"position":2},"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":[]},{"id":1979,"url":"https:\/\/www.danielpradilla.info\/blog\/como-mejorar-tus-graficos-de-business-objects\/","url_meta":{"origin":2239,"position":3},"title":"C\u00c3\u00b3mo mejorar tus gr\u00c3\u00a1ficos de Business Objects","author":"Daniel Pradilla","date":"16\/08\/2013","format":false,"excerpt":"Business Objects, la plataforma de Inteligencia de Negocios de SAP, es\u00a0realmente p\u00c3\u00a9sima para la visualizaci\u00c3\u00b3n de datos.\u00a0De alguna manera, logra que los desarrolladores tomen todas las malas decisiones posibles al mismo tiempo y crea unos cuadros de mandos (si pueden llamarse as\u00c3\u00ad) realmente feos e inutilizables. Recientemente he visto varias\u2026","rel":"","context":"In "Control de Proyectos"","block_context":{"text":"Control de Proyectos","link":"https:\/\/www.danielpradilla.info\/blog\/category\/controldeproyectos\/"},"img":{"alt_text":"disaster, disguised as a ","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":[]},{"id":2074,"url":"https:\/\/www.danielpradilla.info\/blog\/nate-silver-and-the-age-of-data-journalism\/","url_meta":{"origin":2239,"position":4},"title":"Nate Silver And The Age of Data Journalism","author":"Daniel Pradilla","date":"24\/03\/2014","format":false,"excerpt":"A few days ago, the new version of Nate Silver's FiveThirtyEight went live, backed by ESPN. According to Silver's observations, explained in his site's manifesto, the market is ripe for a data-oriented journalism. I totally agree. A day doesn't go by in which I hear or read an argument that\u2026","rel":"","context":"In "Lifestyle"","block_context":{"text":"Lifestyle","link":"https:\/\/www.danielpradilla.info\/blog\/category\/lifestyle\/"},"img":{"alt_text":"538_intro4","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/03\/538_intro4.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/03\/538_intro4.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/03\/538_intro4.png?resize=525%2C300 1.5x"},"classes":[]},{"id":2062,"url":"https:\/\/www.danielpradilla.info\/blog\/making-sense-of-numbers-while-browsing-the-web\/","url_meta":{"origin":2239,"position":5},"title":"Making sense of numbers while browsing the web","author":"Daniel Pradilla","date":"21\/01\/2014","format":false,"excerpt":"https:\/\/www.youtube.com\/watch?v=4xlSErmEmso Almost every time we read an article, we are faced with numbers. Good writers try to pre-digest those figures for you with analogies. But most of the times, we are left alone to decipher what the numbers mean. The thing is that we rarely interrupt our reading to stop\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":"Screen Shot 2014-01-19 at 11.01.29 AM","src":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/01\/Screen-Shot-2014-01-19-at-11.01.29-AM.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/01\/Screen-Shot-2014-01-19-at-11.01.29-AM.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/01\/Screen-Shot-2014-01-19-at-11.01.29-AM.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2014\/01\/Screen-Shot-2014-01-19-at-11.01.29-AM.png?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2239","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=2239"}],"version-history":[{"count":0,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2239\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/media?parent=2239"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/categories?post=2239"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/tags?post=2239"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/08\/SAP-HANA-Certified.jpg\")
<\/p>\n