The SQL Server data source selects data from a database in an SQL server.
An SQL Server data source has the following settings:
A standard connection string used to identify the SQL server, the database and authentication.
Select a table
Databases in an SQL 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
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, as seen below:
For each selected table you must specify the name of the table and the ID column.
The ID column is used 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.