The SQL Query Generator retrieves column data of a compatible type from an external database by using a custom query.
The dialog box of the SQL Query Generator contains Basic Settings and custom settings. You can customize the generator by changing the basic and custom settings.
Connection
Select a server connection.
Database
Select a database you want to retrieve data from.
SQL Query
Type an SQL statement that returns a single column with a compatible data type. If your query returns multiple columns, choose the required one in the Column box.
Column
Select a column you want to retrieve data from.