{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
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 Clear Reports/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 |
