Download the trial version of Data Connector and install it to your SharePoint server.

Navigate to the site in which the Orders list is located.

In the upper right corner, click Settings and then click Site Settings.

On the Site Settings page, click Data Connector Settings under BoostSolutions Software section in the bottom right corner of the page.

On the Data Connector Settings page, click Create Job.

After clicking Create Job, you will enter the Edit Job page.

In the Job Name section, specify a unique name for the job, such as job-1.

In the Direction section, specify the direction for the data connection. Select From external data to list option which means we will sync data from the external data source to this SharePoint list.

In the List section, specify a SharePoint list or Document Library to which you want to sync data from the external data source. Select Choose an existing list option. Click to browse and select the Orders from the drop-down list.

In the External Data and Authentication section, configure the settings as following. Specify the external data type and database authentication. (Ensure the user account you specify has the appropriate permissions to access the external data source.)

External Data Type: Select MySQL as the external data type.

Host Name/IP: Enter the host name for the MySQL Server in which the MySQL database is situated or the IP address of the MySQL server.

Port Number: Enter the TCP/IP port number to connect to the database server (The default port number is 3306).

Username: Enter a MySQL user name. The user should have Write permission to the database.

Password: Enter the user’s password.

Click Connect to connect the MySQL Server we specified. If everything goes right, it will show Connection successful below the Connect button. And the databases existed on the specified MySQL server will be populated to the dropdown list as shown in the picture above.

Database: Select a database name, here we select test.

In the Data Settings section, specify which external data will be connected to the SharePoint list. Select Specify a table/view to filter option, and select orders (the table orders stored in the test database as we described in the sample data section) from the drop-down list as following.

In the Column Mapping section, map the fields in the external database to the columns in the SharePoint list as following.

By default, the database fields which have the same name and type with that of the columns in the SharePoint list will be automatically mapped.

Click Add a column mapping to add a column mapping manually.

In Column in List, select Order No.; and in Column in External Data, select NO..

And then select Order No. as the key. A “key column” is one that uniquely identifies records and can be used to compare data sources.

Keep other settings as default and click Save to save the settings.

And then you will find that the job has been created on the Data Connector Settings page, the job-1.

Click the Run button for the job-1 and waiting for the job to be run completely.

After the job run completely, click Close. And navigate to the SharePoint list Orders list, and you will find that the data stored in the table “orders” in the MySQL database “test” have been synced to the SharePoint list successfully as following.