How to connect a shiny app with sap hana directly


#1

Is there a way to connect sap hana directly to R shiny so that I can create a shiny dashboard on cloud.

One of my friend asked me to do it. and I don't know any driver to connect it to sap. So far I don't know if it's hana or oracle or anything similar.

But I just want to know what are ways to connect to database DB2, MS SQL, Oracle or HANA.


#2

I know at least MS SQL and Oracle drivers work with Shiny Server Pro.

https://www.rstudio.com/products/shiny-server-pro/


#3

I am in India.

It's a very small firm and He is paying me less than a 1000 dollar (60,000 rs.)to make one; which will include the cloud cost as well. And Shiny server pro is like 10,000 dollar per year.

How can I even think of going pro??


#4

I'm guessing there are other configurations you can set up without that direct integration, I was just answering your question with the information I had -- which, clearly, didn't include the full picture of your use case.


#5

Are you aware of any other configuration please because that would help a lot