The MySQL data source selects data from a database in a MySQL server.
A MySQL data source has the following settings:
A standard connection string used to identify the MySQL server, the database and authentication.
Select a table
Databases in a MySQL server can contain multiple tables. You can access these tables directly by selecting Select a table as the query method, and selecting the table from the drop down list.
Join multiple tables
Using the 'Join multiple tables' query method you can combine data from multiple tables in the same database.
Most data sources are organized as tables. You can select data from multiple tables at once using this by selecting the option Join multiple tables and selecting the appropriate tables from the drop down list. See below.
For each selected table, you must specify the name of the table and the ID column.
The ID column is use to match rows in all tables.
Specify SQL statement
If you select Specify SQL statement as the query method you can specify custom queries. See SQL Quick Reference for a quick SQL reference and links to resources.
Using the MySQL data source is only possible after installing the MySQL database driver.
To install this driver, proceed with the following steps: