How to extract data from the phpmyadmin SQL Database using Uipath?

Help
1

I am using Wamp server and i want to extract data from the table which I have created in Phpmyadmin and print that date in an Excel sheet. Please suggest me a solution or share a workflow for this.

1 Like
2

@Asmit_Anand1 From the attached file change db configuration and query

DbToCsv.zip (2.1 KB)

3

I am getting an Exception after making changes in this workflow that you shared with me .

Screenshot%20(3)
Screenshot%20(3)1600×900 97 KB

4

@Asmit_Anand1 Error in your db configuration check it

5

Main.xaml (6.1 KB)
If you don’t mind can u check my db configuration please.

6

@Asmit_Anand1 You can check by clicking configure connection → connection wizard → Choose data source->ok-> In the user or system data sorce name->choose Mysql->give uname and password if you have ->than click test connection

7

While configuring connection i am getting this error.

Screenshot%20(5)
Screenshot%20(5)1600×900 99.3 KB
Screenshot%20(6)
Screenshot%20(6)1600×900 103 KB

8

@Asmit_Anand1 - Do you get any solution regarding this issue ?

9

Check this -
DbToCsv.zip (2.2 KB)

Db_To_CSV.zip (2.0 KB)

Key point - Set the connection properly