SQL Query Generator

Last modified: June 26, 2023

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.

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.