User Guide › Design › Data Acquisition › Adapters › Adding Adapters › Add an SQL Adapter › Data Source Interface Step

Data Source Interface Step

SQL adapters can be used to retrieve data from databases using an SQL statement. The SQL interface defines the connection to the database and the queries used to retrieve the data.

When creating SQL adapters, or when editing existing ones, the user has the ability to manage data sources in the Data Source Interface step by:

• Saving the data source as a template (click )
• Setting an existing data source interface as default (click )

For more information, see Managing Predefined Data Sources.

In the Data Source Interface step:

1. In Select statement, type a select statement that is executed on the source database or click Open Query Builder to open the query builder tool that helps in creating the select statement.
   1. In the Main section, double-click on desired elements that are located to the right. The elements are opened in the Main section.
   2. In each element select the desired fields. The select statement is shown in the area below the Main section.
   3. Click on the Test Query button to check that the select statement is correctly written. The test result is shown in the area below button.
   4. Click OK. The select statement is updated to the Data Source Interface step.
2. If you typed the select statement and did not use the Query builder tool, click the Test Query button to check that the select statement is correctly written. The test result is shown in the area below button.
3. In No. of key fields, set the number of key fields.
4. In Query key fields, click Auto Select to set the query key fields automatically.
5. If you are an advanced user, click Advanced to configure advanced parameters related to the Data Source Interface step. The Data Source Advanced Settings window is displayed.
   1. In the General tab, set information about the query to be performed. For more information, see General Tab.
   2. In the Query key fields tab, set information about the query key. For more information, see Query Key Fields Tab.
   3. In the Test Connection String tab, perform a test of the connection string.
   4. In the Notes tab, type any relevant comments. For more information, see Notes Tab.
6. Click Next. The Adapter Wizard page Mapping step is displayed.