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 |