SQL Query Generator

Last modified: October 8, 2024

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.

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.