Transfer DATA from SAP HCP to sap GUI Database!

[former_member558346]

Hi experts!

I'm actually working on an IOT project using SAP HANA CLOUD PLATFORM. For the moment I've succeded in receiving the data from my sensors to the HCP server, and i'm wondering if there is a way to tranfer these data to a SAP GUI database? if yes, How ?

Regards,

[Ivan-Mirisola · Accepted solution]

Amine,

I suppose you are using IoT 2.0 and not the newer 4.0 that is available via CF instance. With version 2.0 your data will be bound to a Neo Database. In case you have used a HANA Database, than you could open the Web Based Workbench tools directly from the database options in the cockpit or you could use Eclipse with HANA Tools installed to connect to your database remotely. Both ways you would be able to browse the data and perform other operations via SQL if you want. If you have bound it to an ASE database, you will be needing to establish a database tunnel using the Neo SDK via command line and use the ASE tools to send SQL commands to it.

Regards,
Ivan

[former_member558346 · Accepted solution]

Thank you Ivan, I'll let you know if it helps 😄

[former_member558346]

Hi again,

After like 10 days of posting this Question and after reading many documentations, I succeded in writing my Abap program that consume data from the Hana Cloud Platform, & now I feel like sharing the main steps with you guys : (PS: Contact me for more details via : Benslalamine96@gmail.com).

1-After displaying your IoT Data on the SAP HCP you can get an HTTPs link that contains your data in a XML Form, as shown in the capture below.

2-We can call that link from our abap code and add filters to target only the data we need using concatenations. and of course you should use xml library methods to communicate with the server.

3-Another step which I consider mandatory, is that you should upload a SSL certificate to your on-premise system for security reasons (since we are using an HTTPs query). You can use transaction code STRUST.

Feel free to contact me for more details.

Cheers,