Common Properties

Property

Description

Connection Name

Enter a unique name for the connection.

Note: Once you save the connection, you cannot update the connection name later.

Provider

Select the database provider name from the list.

Max Rows

Specify the maximum number of rows to be fetched from the dataset.

Username

Enter the username used to open the connection.

Password

Password for the connection.

Blank: If username and password are not required to connect to the database.

Runtime: To provide username and password when he/she tries to access database (for example, to generate a report or to open SQL Editor, etc.).

Connection URL

It is an auto-generated connection string to connect to the database.

Mask Connection String

If the field is selected, the connection string is masked.

Charset Encoding

Select UTF-8 if the database is created or started with UTF-8 encoding. Otherwise, keep it blank.

Is Default

Select this checkbox to use this connection as the default data connection to fetch report data.

Is Repository

Select this checkbox to use this connection as the application default repository to fetch and store meta data.

Is Staging

Select this checkbox to use staging database (in case of H2 database) to store intermediate results for optimization purpose.

Read Only

Select this checkbox to make sure only SQLs having read operations are executed using this connection.

Pool Settings

Initial Connection(s)

Specify the number of pool connections that must open initially.

The number of default initial connections are 5.

Incremental Size

Specify the number of connections that will open when all the open connections are consumed.

The default incremental size is 5.

Resubmit Time

Specify the waiting time in seconds before generating a re-submit request.

The default resubmit time is 30 seconds.

Max. Connections

Specify the maximum number of connections that can be opened to the selected database at a time.

The default maximum connections are 30.

Database Time Zone

Select time zone to receive output of date / time fields as per time zone in which the data was entered in database

Get Configuration File

Select this to get the configuration file of the report server in encrypted format.

Cache

Enable Metadata Caching

When you select this option, the list of table names with column names (or other data source objects) from this connection will be pulled and stored locally for populating in SQL Editor or respective query designer screens.

MetaData Cache Purge Frequency

Use this field to define the time when the cached metadata (table names, field names, etc.) for the selected connection should be deleted and refreshed.

Never: The application will never delete and refresh the metadata.

Boot Up: If the frequency is set to Boot Up, metadata for this data connection will be deleted and refreshed every time the server is booted.