Online Help > Entry Types > Sessions > Others

Database

Description

 

This entry is used to define and configure a Database session. Database sessions will not be very useful on it's own as they only serve as a holder for a connection string. Add Data Report session to unlock its full potential.

 

Auto Login

Copy Password

Credential Repository

 

Embedded Mode

Show Opened Session

Support Logging

 

Settings

 

Database - General tab

Database - General tab

OPTION

DESCRIPTION

Source

Choose between:

Default: The connection string is defined within the session.

Credential entry: Use a linked Connection String credential entry for the connection string.

Inherited: Navigate down the inheritance graph of the object to find the connection string.

Prompt: At open connection time, the system will prompt the user to select the desired Connection String credential entry.

Data source

Contains the data source type like ODBC, OLEDB or native. This value is read only and is extracted from the connection string.

Data provider

Specify the provider used for the database access. This value is read only and is extracted from the connection string.

Connection string

This value contains the database connection string and it can be hidden/encrypted for a better security.

Host

Contains the connection server name. This value is read only and is extracted from the connection string.

User name

Contains the username used to access the database. This value is read only and is extracted from the connection string. The field is blank when using Windows Authentication.

Password

Contains the username used to access the database. This value is read only and is extracted from the connection string. The field is blank when using Windows Authentication.

 

Workflow

 

To create a Database session using a default data source, click on the ellipsis button next to the Connection String to define your connection string.

 

Connection Properties

Connection Properties

 

Make sure you select the appropriate data provider for the database you wish to connect to. Click the Change... button.

 

Change Data Source - Data Provider

Change Data Source - Data Provider

 

Example:

 

SQL Server - Microsoft SQL Server, .NET Framework Data Provider for SQL Server

Oracle - Oracle Database, .NET Framework Data Provider for Oracle

 

Specify the sever name, database name and all other required information for the chosen data provider.

 

Once you have a Database session you can add a child Data Report session and set the data source as Inherited.

 

Troubleshooting

 

While setting up the connection use the Test Connection button of the connection properties window to make sure he connection is properly configure.