SAP HANA Connection & Query execution

Help
, , , ,
1

Hi,

I am trying to connect to a view in SAP HANA with UiPath Studio, to extract data into a CSV.

I was able to establish SAP HANA connection via “Dsn=HDBODBC;uid=MYID;pwd=MYPASSWORD” ODBC connection string.

However, when I try to execute a simple “Select * From “MI”.“APR”” query with the ODBC connection, I am getting an error “Compile error(s) encountered processing expression Select * From “MI”.“APR”. Expression expected.”.

This is strange to me because I am able to execute the query without errors in HANA, and it is relatively a simple query just grabbing all data from a HANA view.

Does anyone have experience in using UiPath Studio to connect to SAP HANA view and exporting results from it to a CSV ?

Thanks,

2 Likes
2

hi~
did you solve the problem?
and how to connect sap hana by uipath studio,could please tell me ?
if there is a step-by-step file will be very helpful.
thanks!

3

HI @seele.yang

Check this post, where people are discussing the usage of Queries

Best regards, Lev

1 Like
4

hey , thanks for your reply, i will check this site right now
thanks a lot ~
(๑•̀ㅂ•́)و✧

5

Hi @seele.yang ,
were you able to achieve this? I am also having same scenario but facing issue in connecting. Can you please help if its resolved