SQL Query generator

The SQL Query generator retrieves column data of a compatible type from an external database by using a custom query. Note that the generator retrieves the data that resided in the table before data population. In the Fill settings section, you can set up basic and custom settings.

Custom settings

Connection: Select a server connection.

Database: Select a database you want to retrieve data from.

SQL Query: Type a SQL statement that returns a single column with a compatible data type. If the query returns multiple columns, choose the required one in the Column list.

Column: Select a column you want to retrieve data from.

Note

If you need to insert the data to be generated, use the Foreign Key (manually assigned) generator.

Preview of the column data generated by the SQL Query generator