Pdf data to sql database

Help Studio
, ,
1

hi
i’ve need to extract pdf data and need to store the data in sql data base (under the already created table name)
i’ve extracted the pdf data using regex in the build data

11
11956×652 113 KB

12
12899×583 15.8 KB

can any one suggest me how to save this data into the sqldb

2

Hello @lakshmi3 ,

Correct me if am wrong, this is what I got from your question.
You want to extract some data from PDF, put into datatable and push that table to SQL database. If thats the case

  1. Connect UiPath Studio to SQL database, check this post.
    Connect to SQL Database - UiPath
  2. Use Insert Datatable activity which is in Uipath.Database.Activities

Regards,
Lakshmi

3

i’ve build the connection and tried moving the data using insert activity i’ve this error
imageDB_sequence.xaml (21.8 KB)
attached is my xaml

4

The datatable in uipath and database must have the same number of columns and matching datatypes. Please verify that.

5

ohh then do i need to re build the build data type because the coulmns are different in db

6

Or… write your own insert/update queries if the datatable and database table are not compatible 1 on 1.

Just loop through the dt with a for each and fire all the insert statetments, written by you to do the data coversions.

7

can u tell me clearly or can u send xaml if u have
please

8

I can’t send an example since I don’t have direct access to a database from my workspace (security restrictions), nor do I know the datamodel you are using.
But…
This is basically it:
image

Since you are directly accessing your database, I make the assumption that you know how to write an ‘INSERT INTO’ query. (If not you really shouldn’t be messing with this :slight_smile: )
Basically what you do is create a for each row in your source datatable, use the row information to write an insert statetement with the relevant row values as parameters, and execute it for each row.

Edit: seeing the post below… the example should indeed be execute non query instead of execute query. The latter is for select statements.

1 Like
9

Hi,

You can use for each loop to get the desired values from your data table and use execute non query activity → use inset into query and insert what are the values you want to insert into DB.

Regards,
Kirankumar.