Hi Everyone… I have a sql server where I have to connect through Ui path and have to Extract a Table as Csv or Excel. I have tried using DataBase connect activity and also Installing MySQL ODBC connector but it is not connecting. Could anyone please help me on this…!!!
Thanks !!!
Hi @saikumar,
You need to configure connection string with MySQL ODBC driver.
using Connect activity–>click Configure–>select Other–> from below dropdown select “.Net Framework dataprovider for ODBC”–>Ok
In the connection properties, select “use Connection string”–>Build.
On select Datasource, click on Machine datasource, where you should find your MySQL Datasource driver.If you dont find one, Click on new and follow guided steps to create one. You can follow below documentation for that.
https://dev.mysql.com/doc/visual-studio/en/visual-studio-making-a-connection.html
once back at select datasource page, input username and password and test connection and you are done!!!
Thanks,
Neelima.