How to Extract the data from MYSQL database

Learn Academy Feedback
,
#1

Hello UIpath Avengers, :innocent:
I want to extract data from the MySQL database but hear we have to read directly from the MySQL I don’t want to store in excel sheet from there only I want to read the data.

For Example, I have 3 columns Column 1- Name, C2-Email-ID, C3-Date
Hear robot want to read the date column and compare today date if its compare it has to send the email to his Email-ID(C2 Column) how to read the data without stored in excel

I already Connect the UIpath to the database and execute the query also

ScreenShoot below

image
image1365×606 67.5 KB

image
image481×737 19.2 KB

I hope I get the solution from the Uipath Avengers.

Thanks
Chethan P

#2

Can you manipulate the options above the grid to set the output to text or csv.

And then automate the export button to save results to a text /csv file?

I remember doing this in DBeaver for PostgreSQL data .

#3

The Execute Query activity outputs the resulting data as a Datatable, which could be saved as an Excel or CSV file but does not have to.
Simply use the For Each Row activity to iterate through your results of your output variable and use the data of each row as you need.

2 Likes
#4

thanks for your reply I will check.

thanks
Chethan p

#5

I got a solution to thank you very much…

Thanks :beers:
Chethan P

1 Like
#6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.