{"id":2234,"date":"2018-05-30T05:33:45","date_gmt":"2018-05-30T09:33:45","guid":{"rendered":"https:\/\/www.danielpradilla.info\/blog\/?p=2234"},"modified":"2018-05-30T05:33:45","modified_gmt":"2018-05-30T09:33:45","slug":"how-to-build-an-api-for-sap-hana-using-strongloop-loopback","status":"publish","type":"post","link":"https:\/\/www.danielpradilla.info\/blog\/how-to-build-an-api-for-sap-hana-using-strongloop-loopback\/","title":{"rendered":"How to build an API for SAP HANA using strongloop\/loopback"},"content":{"rendered":"

\"\"<\/p>\n

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<\/a>.<\/p>\n

Recently, I wanted to build a small JavaScript app for data querying and entry using the awesome ag-grid<\/a>. The data was in SAP HANA but the prospect of building and testing a secure API was quite daunting (is it worth it? How long is it going to take? Who’s going to maintain it?) It was actually easier to switch to MongoDB, use Express or Parse<\/a> and add an ETL process to sync the databases. Wouldn’t it be great if there was a way to create some sort of automatic API through configuration?<\/p>\n

There is.<\/p>\n

The Loopback component of Strongloop<\/a> offers the possibility to quickly create secure APIs for CRUD operations against MySQL, Postgres, Oracle and other databases. In many cases, it allows you to completely bypass the development of boring and \u2013commoditized\u2013 backend stuff. Using a convention over configuration approach, you can create endppoints for each of your tables in a matter of minutes.<\/p>\n

But, can it connect to SAP HANA?<\/p>\n

I googled and found a connector for HANA<\/a><\/p>\n

The best way to set this up is to containerize the solution: create a docker container with an installation of strongloop and link a directory in the host machine to the working directory of the container, that way you keep the configuration outside of the container to quickly modify it, and you can quickly switch or upgrade the container.<\/p>\n

I started from node official image<\/a>, but you can start from the strongloop official image<\/a>, and created my own, which you can use. Here is a link to my image<\/a>.<\/p>\n

\r\nFROM node\r\n\r\nMAINTAINER Daniel Pradilla <info@danielpradilla.info>\r\n\r\nRUN npm -g config set user root\r\n\r\nRUN npm install -g --unsafe-perm strongloop \r\n\r\nRUN npm install loopback-datasource-juggler\r\n\r\nRUN npm install loopback-connector-saphana\r\n\r\nWORKDIR \/app\r\nEXPOSE 3000\r\n<\/pre>\n
Once you start the container, you need to create a connection to SAP HANA<\/p>\n
\r\ndocker run --name loopback -p 3000:3000 -v `pwd`:\/app\/ -t -i danielpradilla\/loopback slc loopback:datasource\r\n<\/pre>\n
Then, you have to edit your server\/datasources.json file and manually specify the schema name (This is something that you don’t need to do with other databases, and you may get stuck on a table not found error if you don’t do it)<\/p>\n
\r\n{\r\n  "db": {\r\n    "name": "db",\r\n    "connector": "memory"\r\n  },\r\n  "hana": {\r\n    "host": "my_server_address",\r\n    "port": my_server_port,\r\n    "database": "MY_DATABASE_NAME",\r\n    "name": "hana",\r\n    "user": "my_HANA_user",\r\n    "password": "my_hana_password",\r\n    "schema": "MY_SCHEMA_NAME",\r\n    "connector": "saphana"\r\n  }\r\n}\r\n<\/pre>\n
Then you create an endpoint to the table using the wizard<\/p>\n
\r\ndocker run --name loopback -p 3000:3000 -v `pwd`:\/app\/ -t -i danielpradilla\/loopback slc loopback:model\r\n<\/pre>\n
Or using arc by running the API interface<\/p>\n
\"\"<\/p>\n
\r\ndocker run --name loopback -p 3000:3000 -v `pwd`:\/app\/ -t -i danielpradilla\/loopback slc arc\r\n<\/pre>\n
And after that, you are ready to experience the awesomeness of having all the API endpoints created for you.<\/p>\n
\r\ndocker run --name loopback -p 3000:3000 -v `pwd`:\/app\/ -t -i danielpradilla\/loopback slc run .\r\n<\/pre>\n
\"\"<\/p>\n
The next step would be to secure the API using microgateway<\/a> for API Key validation, OAuth 2.0 and rate limiting,<\/p>\n","protected":false},"excerpt":{"rendered":"
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 in SAP HANA but the… Continue reading How to build an API for SAP HANA using strongloop\/loopback<\/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":[],"class_list":["post-2234","post","type-post","status-publish","format-standard","hentry","category-software-development-en-en","entry"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1tlzy-A2","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":2234,"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":2239,"url":"https:\/\/www.danielpradilla.info\/blog\/how-to-connect-to-sap-hana-using-jdbc\/","url_meta":{"origin":2234,"position":1},"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":2212,"url":"https:\/\/www.danielpradilla.info\/blog\/linear-optimization-with-or-tools-building-a-web-front-end-with-falcon-and-gunicorn\/","url_meta":{"origin":2234,"position":2},"title":"Linear Optimization with or-tools \u00e2\u20ac\u201d building a web front-end with falcon and gunicorn","author":"Daniel Pradilla","date":"14\/11\/2017","format":false,"excerpt":"In a previous post, I put together a script for solving a linear optimisation problem using Google's OR-tools. This python script is callable from the command line and you kinda need to know what you are doing and how to organize the parameters. So, in order to address this difficulty,\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\/2017\/11\/groceryshopping.gif?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2017\/11\/groceryshopping.gif?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2017\/11\/groceryshopping.gif?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2017\/11\/groceryshopping.gif?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":2229,"url":"https:\/\/www.danielpradilla.info\/blog\/linear-optimization-with-or-tools-containerizing-a-gunicorn-web-application\/","url_meta":{"origin":2234,"position":3},"title":"Linear optimization with or-tools: containerizing a gunicorn web application","author":"Daniel Pradilla","date":"15\/05\/2018","format":false,"excerpt":"Previously, we left our app working with our local python+gunicorn+nginx installation. In order to get there we had to do quite a bit of configuration and if we wanted to deploy this in a server or send it to a friend, we would have to go through a very error-prone\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\/docker.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/docker.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/www.danielpradilla.info\/blog\/wp-content\/uploads\/2018\/05\/docker.jpg?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":1973,"url":"https:\/\/www.danielpradilla.info\/blog\/improve-sap-business-objects\/","url_meta":{"origin":2234,"position":4},"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":2224,"url":"https:\/\/www.danielpradilla.info\/blog\/pentaho-is-slow-for-servers-with-too-many-home-directories\/","url_meta":{"origin":2234,"position":5},"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":[]}],"_links":{"self":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2234","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=2234"}],"version-history":[{"count":0,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/posts\/2234\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/media?parent=2234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/categories?post=2234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.danielpradilla.info\/blog\/wp-json\/wp\/v2\/tags?post=2234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}