Oracle SQL Connection

Kate_Tan · July 13, 2020, 7:53am

hi, does anyone know how to connect Oracle SQL developer in UIPATH and get it to read insert statements from excel?

Latika10011740 · July 13, 2020, 1:49pm

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.

Oracle_DB Conection & Querying.zip (28.8 KB)
Thanks
Latika

Kate_Tan · July 16, 2020, 6:28am

hi, may i know what are each variables inside the multiple assigns for?

Latika10011740 · July 16, 2020, 7:28am

@Kate_Tan

That variables i am reading the provider name connection string and query from input excel.

Kate_Tan · July 16, 2020, 7:40am

if i already have the insert statement in the excel cell, how do i read that and input into sql?

Topic		Replies	Views
How to connect oracle database by ODBC connection Help studiox , question , oracle	5	1779	November 27, 2020
How to make connection between uipath and excel to get data of excel from sql command Help	2	957	September 5, 2019
How to insert excel data to oracle database table using uipath Academy Feedback excel , database , studio , question	2	2188	November 23, 2020
How to insert a row in Oracle Sql developer Help uiautomation , activities	1	4508	December 1, 2017
Fetching table values from oracle database to Uipath Reboot Your Skills 2021 excel , database , oracle	16	4321	August 16, 2020

Oracle SQL Connection

Related topics