How to use SAP HANA database table in R script?

[former_member1373826]

TLDR: What is the best way to deploy an application on SAP BTP Neo Cockpit to use data from an SAP HANA database table, compute the result with an R script, and show the result on the app (and save the result on another SAP HANA database table) ?

Hi, I'm trying to build an application that is to be deployed on SAP BTP Neo Cockpit - HTML5 Applications.

I already built the app, and a separate R script that is capable of importing a CSV file from my computer, make the necessary computations, and generate a graph with the computation results.

Now what I need is to make it so that the R script uses data that is in an SAP HANA database table instead of a local CSV file, so I thought about :

- using the SAP HANA Database Explorer but I was told to do it differently

- using a flowgraph, but I don't what kind of output I would need to select

- using ODATA, if I understood it correctly, it makes a link between the SAPUI5 app and a specified database, but I don't know how to connect both together

So how can I use data from an SAP HANA database table in an R script?

And how can I use this R script inside an SAP BTP Neo Cockpit - HTML5 Application?

PS: I did a lot of research and just can't figure out what the best way (best practice) is...

Thanks for your time and answer