How to connect my flowchart to Mysql database?

database
studio
sql

#1

How to connect my flowchart to Mysql database?


#2

#3

"


My connection string is

“Server=localhost;port=3306;Uid=root;Pwd=root;Database=db”;

but when i running i get this exception


#4

Did you try caps P
https://www.connectionstrings.com/mysql/


#5

Main.xaml (23.1 KB)

yes i try all the combination but still getting error

is there any driver required for connectivity ?

i attach my xaml file here


#6

Hi

You can use connect to MYSQL database using UIPath, by installing Mysql-ODBC connector of 32-bit(x86) and creating a system/user DSN.

I have tried and it is working fine.

Please revert for any clarifications.


#7

Rajat,

I am getting issue after installing odbc connector


#8

Hi @thakurashish55525

Please elaborate, and if you can post the exact issue that would be great.

Regards

Rajat


#9

Thanks for asking.

I have MySQL installed on my local machine as well as UiPath on the same
machine.
I have also installed MySQL connector, while testing ODBC connection using
connector , i am able to access my database.
But while doing the same in UiPath then getting error, i am not sure it i
am using correct option.
Below is the error i am getting at last point.


Is it possible to connect to mysql database using uipath? If yes? How to connect to MySQL Database?
#10

Hi @thakurashish55525

Apologies for the delay in response, but this may be helpful for some facing the same issue.

The issue as mentioned, has a mismatch of architecture between the driver and UiPath application as it seems you have installed the 64-bit version of the driver whereas, UiPath is compatible with the 32 bit version(x86).

I have listed the links for the explanation regarding the same on Technet and also the link to download the mysql - 32 bit:

  1. Technet: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/702f0d9b-6cb9-49cf-9953-80d059711e60/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-application?forum=sqlgetstarted

  2. Mysql 32-bit: https://dev.mysql.com/downloads/file/?id=406107

Regards

Rajat


#11

How to extract data from MySql database to CSV?


#12

Hi @Snehal1

Once you are connected to the Database, you can use Mysql Execute Query and fetch the data from the database, for example in the provided snapshot, I use select query using execute query activity and the output is stored in the datatable, which is stored in a csv file using Write CSV activity.

Please revert for clarifications.

Regards

Rajat


#13

Thank you @rajat.pandey :slightly_smiling_face:


#14

Hi @rajat.pandey,how to store data scraping data directly from web to database.
Thanks in advance.