Data Extraction from pdf to oracle database

[Mariam_Saeed]

Can someone help me with data extraction from pdf to database with babystep because i am new to UiPath

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Mariam_Saeed ,

Can you share your PDF file?
Or check your link

UiPath Document Understanding: Extract Tables Out of PDFs

3. How to Insert Data in Database with UiPath || Excel to Database in UiPath | Database Automation

Flow step:
get data table from PDF
convert data table to database
Regards,
LNV

[Mariam_Saeed]

1st video is of data extraction from pdf to excel and i have done that
2nd is of excel to pdf and i want to transfer from pdf to db

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi,
2nd is convert data table to database, pls check

[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

[Mariam_Saeed]

how to connect UiPath to oracle?

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

You can flow step

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…

[Mariam_Saeed]

have done this and now how to extract data from pdf to oracle DB

[Nguyen_Van_Luong1 (Nguyen Van Luong)]

Hi @Mariam_Saeed
it goes back to the original question?
I showed you how to get data table from pdf
I showed you how to connect oracle with UiPath
I also showed you how to change from data table UiPath to database
please see previous comments
Regards,
LNV

[Mariam_Saeed]

I didn’t understand that answer of how to change from data table UiPath to oracle database can you please send me any tutorial of this

[Mariam_Saeed]

and the video you recommended me is not for oracle database it’s for SQL database