Get data from Mysql and generate Batch of Excel

Hi Team,

How can i do below fetch data from mysql database and create xls file in batch uipath.
Since i have Millions of data in my database need to create batch of 10000 Batch Naming will be having counter Batch_1 … Batch_N Please suggest

1 Like

You can connect to DB by using the data base activities, where you can retrieve the data by sending the SQL request,so you can get the output based on the query. Can you try sending the request as where rownum <= 10000; @abhiseky93

2 Likes

But not able to find mysql connector it is connected with ms sql . How can i generate batches of files into 10000 but all files should have header Please suggest ?

1 Like

Whatever it is, If you have DSN of your database, you can connect. Install UiPath.Database.Activities in uipath studio

And yeah, for the first time, use the rownum<= 10000, for the second rownum> 10000 and rownum < 20001 . It will fetch the data with headers

2 Likes

Thanks HareeshMR I am able to connect to mysql can you share some example for Batch generation

@loginerror can you help me out