Home >Database >Mysql Tutorial >How to connect Datafactory data generation to mysql database

How to connect Datafactory data generation to mysql database

黄舟
黄舟Original
2017-08-04 15:46:241809browse

Now when performing performance testing, generally there is no relevant data in the project, so you can only input a large amount of data into the database through other methods, so that the performance will be better for database processing. We are also working on the data returned in the page, and for related performance, we use Datafactory to generate data.

1. Since you need to connect MySQL data, you need to install the myodbc driver on your computer now. Only in this way can you connect MySQL data. First, open the Datafactory data generation tool. Then select the ODBC option in select connoction and click Next.

How to connect Datafactory data generation to mysql database

2. Then enter the options of the connection information page. If you cannot connect to the MySQL database directly, , can only be connected through the computer's data source, click the DBC Administrators button.

How to connect Datafactory data generation to mysql database

3. After entering the ODBC data manager interface on the computer, you need to add the MySQL data source Add it to the data source so that Datafactory can connect to MySQL, so click the "Add" button.

How to connect Datafactory data generation to mysql database

4. To create a new data source, you need to add the corresponding driver and select the driver you want to use. Find the MySQL ODBC 3.51 Driver in the list of installed data source drivers, you can connect to MySQL data, and then click Finish.

How to connect Datafactory data generation to mysql database

5. This will pop up the data driver you just installed MySQL. You need to log in in connectors. In the data source name, enter the name to be created, in the server, add the data connection address, fill in the MySQL data user name, and in the database, select the name of the data table to connect to.

How to connect Datafactory data generation to mysql database


##6. This will directly log in to ODBC In the Data Explorer, the data source driver just created is added to the user data source. You can select it and click "OK".

How to connect Datafactory data generation to mysql database

7. This will directly return to the connection information page interface, and then perform ODBC connect in the data source Select the data source you just created, and you need to enter the data user name in username.

How to connect Datafactory data generation to mysql database

8. Enter the add tables page interface and find the data to be inserted in the available list. table, move the available data table to included. After the addition is completed, you can click the "Next" option.

How to connect Datafactory data generation to mysql database

9. Enter the name page and the data that needs to be generated in Datafactory will be displayed in the Datafactory table nickname. option, you need to enter the nickname, you can directly enter the nickname in name.

How to connect Datafactory data generation to mysql database

10. In this way, you can directly enter the Datafactory interface and display the data table you just added. , indicating that if Datafactory is successfully connected to the MySQL database, a large number of inserts can be made into the database.

How to connect Datafactory data generation to mysql database


The above is the detailed content of How to connect Datafactory data generation to mysql database. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn