SAP HCP / HANA DB connected by Boomi Cloud & Bonitasoft (via REST)

[azael_navarro]

Dear experts,

It is a pleasure to share a great "practical" tips after implementing this vision with middlewares like: TIBCO, HCI, PI, PO, MuleSoft but now with Bonitasoft & Boomi, so for example you will find different point of views about the impact of results like how to extract information from HCP and share it to S/4 HANA, for example...

Business Vision:

• As i said, now a days you will require to extract information from SAP PaaS to some other SAP SaaS, PaaS or on-premise applications like  S/4 HANA even that apply to connect different No SAP Cloud Proposals like Dell, Azure, Amazon, etc...

HANA DB / HCP:

In simple ideas, you need to follow next general steps:

• Implement your HANA DB and deploy it in SAP HCP (just the next topic as main recomendation),

Using the SAP HANA Developer Edition or SAP HANA Cloud Platform

• Use the next github code:

iotmmsxs

• Implemen your XSODATA, in order to extract your information,

oData Create/Update/Delete Support in SAP HANA SPS6

• Implement your own HANA & Odata Service:

Test your REST Design:

Before to implement in your middleware, test the performance of your Odata services:

• First use Postman,

Learning OData on Postman

• Then use SOAPUI,

Dell Boomi:

Now you can implement your integration via Boomi, consuming your REST Service, just in this case be carefull because is need it to tune the Authorization Issue, after ending this flow:

• Implement your flow and test it:

• The configuration used, was:

• Next steps: it is important to solve the issue: Invalid value for HTTP header

BonitaSoft:

As you did with Boomi, you can implement your rest proposal with REST Connector and in this case, the next challenge to you will be to get the data in a "variable" to mange row by row:

• Implement your BPM:

• Install REST Connector:

bonita-connector-rest

• Configure with SAP HCP / XSODATA information:

• Test the connectivity:

• Nex steps, you need to recover the information in a variable to transfer the information to another technologies or flows....

References:

You can follow next references, but please, even review my last posts because there are more related information:

• http://documentation.bonitasoft.com/6.x-7.2/web-rest-api-overview


• https://github.com/Bonitasoft-Community/bonita-connector-rest


• http://northwind.servicestack.net/customers.json


• https://github.com/SAP/iot-starterkit/tree/master/src/apps/xs/consumption/iotmmsxs


• http://go.sap.com/developer/tutorials/hana-xsodata.html


• https://www.youtube.com/watch?v=c41anxrDleg


• http://hana.info/?page_id=261


• http://www.odata.org/getting-started/learning-odata-on-postman/


• http://www.ateam-oracle.com/invoke-fusion-cloud-secured-restful-web-services/


• http://help.sap.com/saphelp_hanaplatform/helpdata/en/c0/1fc0f5d38c47c69204d84a700d0ca7/content.htm


• https://www.boomi.com/