Data Extraction from pdf to oracle database

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

You need connect UiPath with oracle first

How to setup a connection to Oracle Database with UiPath

I could create the connection successfully. The above error was due to an additional space in the connection string in tnsnames.ora file…:joy: Steps followed are: Download oracle instant client (basic and odbc driver) - 32 bit Extract content of both to one folder Add the path of instant client folder to System variables (Path and TNS_ADMIN) Install instant client by running odbc_install.exe in instant client folder Create the tnsnames.ora file inside the instant client folder. **If u h…

Then convert data table in UiPath to database in oracle

1. Add UiPath.Database.Activities to your UiPath solution through package manager.
2. Add a Read Range to read your excel to a datatable
3. Use the database connection activity and create the connection to the database
4. Use a for each row activity to loop through the datatable
5. Within the loop, use the execute query activity.
6. Configure this activity to accept the datarow returned from the row variable of the for each row.
7. Write the query to insert it into your table
   You can try