The SQL Query Generator retrieves column data of a compatible type from an external database by using a custom query. Please note, that the Generator retrieves the data that resided in the table before data population.
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.
Note:
If you need to insert the data that are to be generated, then you need to use the Foreign Key (manually assigned) Generator.