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

forum

#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.


#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 .


#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.