getting started and Insert table data

[zalex]

Dear community,

i am currently trying to get started with SAP cloud platform, so my question is if anyone could give me some related articles to learn how to solve the following task:

I have got an excel file with a table I would like to import into a cloud database and then display using UI5.

Also since I am new in this area and I am a backend web developer (mainly PHP) normally, is there only JAVA to use or is the node.js version viable. And are there options I don't see?

Best regards
Alex

[Ivan-Mirisola · Accepted solution]

Hi Alex,

I would use the OData protocol to expose the cloud database tables and then link the source in excel using the URL data feed as Data Base Connection. For the Excel part there is plenty of documents you could search on google. Here is one I've found that may be able to help you with that particular task. On the other hand, there are several options to expose data from your cloud database. For instance, if the database is NOT HANA, then I would recommend you doing it using Spring Boot + JPA + Olingo. There are two blogs that will cover this task (this and this one). Both do indeed use HANA as database, but there isn't much to it that couldn't be done with other databases as well. On the other hand, a HANA database can provide you with several other options. To mention a couple: the XS Classic version (available on SAP Cloud - Neo) you can achieve this by simply creating an artifact with the xsodata. Or you could develop your own REST service with with a XSJS (which is basically a lot like a NodeJS application with additional extensions from SAP to interact with the HANA DB).

Now for the last and coolest part of the answer: Cloud Foundry! Yes, SAP Cloud Platform has this landscape as an option and this brings in the BYOL concept to the table. You may as well start running your very own PHP or Python application or choose a plain old NodeJS app.

The best part comes now: if you choose CF as your deployment option together with a HANA HDI Container, you will be able to build your OData service without even coding the entire OData service yourself. Most of the development effort will reside on the data model definition - which you can do directly on Web IDE with the aid of CDS syntax. If you are interested, please have a look at the new Cloud Application Programming model where you will also find a tutorial with step-by-step procedure.

Good luck!

Best Regards,
Ivan

[zalex · Accepted solution]

Thank you very much so far. I am not sure if am missing something but do I get to insert some data into hana db? i managed to create a UI5 application that displays it, but I now need the hana part.

[Ivan-Mirisola · Accepted solution]

ODATA already provides CRUD. So, yes, you are able to both read and write to the database.

[zalex · Accepted solution]

To be honest I actually don't understand your answer. I just want to show a table using UI5. Ok OData i get that one, but where do I set it up? How do I import a simple CSV File into my trial Handa database?

[gregorw · Accepted solution]

Please check out the tutorial Time Series Forecasting with SAP HANA APL (Automated Predictive Library) which is part of the series: Build an SAP Fiori app that consumes OData services, external mapping APIs and supports multiple lan...

[zalex · Accepted solution]

Thank you very much. Good information!

[SergioG_TX]

hi alex,

if you have a cloud platform account, you could benefit from BYOL as Java and nodejs both are supported. here is a page with tutorials for your learnings https://www.sap.com/developer/topics/cloud-platform.tutorials.html#tutorials

[zalex]

Thank you for your answer!