{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}}
{{helpModel.downloadHelpPdfDataStatus}}
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/i-net HelpDesk/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 |