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



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.


@Asmit_Anand1 From the attached file change db configuration and query (2.1 KB)


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


@Asmit_Anand1 Error in your db configuration check it


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


@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


While configuring connection i am getting this error.