Database

A Database series will execute a SQL statement via a Database connection and uses the resulting table as parameters. Each row represents one set of parameters. Specific JDBC drivers are required to connect to a database and have to reside in the lib directory of the installation.

On macOS the alternative system path /Library/Application Support/INETAPP/lib should be created and used.

The following parameter fields are required for the configuration:

  • JDBC URL: connection URL for the database
  • Username: the user to connect with
  • Password: the password of the user to connect with
  • SQL Query: the SQL statement that will be executed

Example

Here are some sample values for the MS SQL server:

JDBC URL jdbc:inetdae7:yourservername?database=northwind
Username sa
Password 12345678
SQL Query select * from customers