Is there any way to work with smaller sets of ODBC-based data?

ODBC Data Sources can be configured to accept parameters which are included as part of the data-retrieval SQL. Parameters should be placed in {{ braces }} for example:

SELECT * FROM customers WHERE name LIKE '%{{Name}}%' LIMIT {{No Of Records}}

This will create two parameters that user can change: “Name” and “No Of Records”.  Up to five can be specified.

The values for these parameters will be prompted for when:

  • Pressing the ‘Execute’ button on the ‘ODBC Data Source Configuration’ dialog
  • The first time this data source is opened on a different machine

The parameters can also be changed by pressing the (i) button at the bottom of the panel.

In addition to this, defaults can be supplied for parameters as follows:

SELECT * FROM customers WHERE name LIKE '%{{Name:Type part of a name here}}%' LIMIT {{No Of Records: No of records needed}}