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:
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 |