{{sidenavigation.sidenavigationExpandLabel}}
{{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 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
i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Database