How to connect oracle database by ODBC connection

[ANDSamuel (Samuel Serak)]

Hello,

How can I connect to the oracle database by ODBC connection to import excel sheet to it

Thanks

[Latika10011740 (Latika V N Durga Bhavani)]

Hi @ANDSamuel

Please find the attached workflow to connect Oracle DB and Querying from Excel.

For this Please install oracle Express edition and Create a Connection string and test it manually in oracle db after that you can use that connection string in UIPATH.

Install below package in uipath studio,

Oracle_DB Conection & Querying.zip (28.8 KB)

Thanks
Latika

[ANDSamuel (Samuel Serak)]

Thank you @Latika10011740 so much for your useful help.
but it should be install oracle XE or it’s ok with Oracle client ?

Thanks,

[Latika10011740 (Latika V N Durga Bhavani)]

you can install oracle client as well, I used oracle XE.

Thanks
Latika

[ANDSamuel (Samuel Serak)]

Thanks for your reply @Latika10011740,

is this excise’s action that export excel sheet from table in database not import, right ?

thanks.

[ANDSamuel (Samuel Serak)]

and also i’ve got this error i don’t why ?

[Connect] Keyword not supported: ‘dsn’. using uipath