Configuring Dynamic Connections
A dynamic connection is a group of connection properties that can be used to override the original data source connections in a catalog. The server administrator can modify some of the original catalog connection properties, and then save these modified properties as a dynamic connection property. For a dynamic connection, the administrator can define a database user mapping table which is a table containing the columns: SID, database user, and database password. Logi JReport Server manages the dynamic connections in the server system database.
When running a report or scheduling a report to run, if there are multiple dynamic connections available to the log-in user, the user needs to select one. Then the server will pass the changed connection properties of the selected dynamic connection into the report engine. The report engine will merge the changed properties with the other original catalog connection properties to setup the database connection.
Dynamic connections are categorized at the organization level. If the system administrator creates a dynamic connection, the connection maps to no organization. If an organization administrator creates a dynamic connection, the connection maps to the organization. If a dynamic connection is defined in an organization, all users/groups/roles must be from the same organization. If a connection is defined in non-organization, all users/groups/roles must be from non-organizations. System administrator can define, view and edit all the dynamic connections.
Developer users can also use API to apply dynamic connections.
Below is a list of the sections covered in this topic:
- On the Logi JReport Administration page, select Configuration on the system toolbar and select Dynamic Connections from the drop-down menu to open the Configuration - Dynamic Connections page.
- Select the New Dynamic Connection link. The New Dynamic Connection dialog appears.
- Select Browse to select a catalog in the Select Catalog dialog.
- From the Data Source Name drop-down list, select a data source available in the selected catalog.
- From the Connection Name drop-down list, select a connection to connect to the data source.
- Select Properties to expand the properties table. To change a property's value, first select the checkbox beside it, and then enter a value in the text box or select a value from the drop-down list as required.
- Select Add Database User Mapping to define the mapping relationship between SID and database user/password. A mapping row will be added in the mapping table. From the SID drop-down list, select a user, role, or group name. Double-select in the text box of Database User and Database Password and you can then type in database user name and password. Then select Test Connection to test whether the user name and password can connect to the database.
Within a dynamic connection, make sure that an SID is mapped to only one pair of database user and name.
Select OK to create the dynamic connection. It is then added in the dynamic connection table which consists of the following columns.
Column Name Description Catalog Displays the catalogs of the dynamic connections with the full resource path, for example,
Data Source Displays the data source names of the dynamic connections in the catalog. Connection Name Displays the dynamic connection names. You can select a connection name to edit the dynamic connection. SID Displays the security identifiers (SID). An SID can be a group, a role, or a user in the Logi JReport Server security system. Organization Name Shows the organizations that the SIDs belong to. The column is available to system admin when the Organization feature is enabled. Database User Displays the database user names of the dynamic connections. Null means using the default database user name. Database password Displays the database passwords of the dynamic connections. The passwords are masked.
All columns in the table are sortable except for Database Password. To sort the table by certain column, select on the column name. By Default the table is sorted by Connection Name.
You can perform the following tasks on the dynamic connections in the dynamic connection table:
Searching for a dynamic connection
First select a search category from the drop-down list, then type the text in the text box and select to start the search. The x button in the text box is used to clear the input text. After the results are filtered, to return to the state before search, select x in the text box.
There are the following search categories:
Searches for catalogs.
- Connection Name
Searches for connection names.
Searches for SIDs.
- Database User
Searches for database users.
For example, in order to find the dynamic connections which use the catalog SampleReprts.cat, you can select Catalog from the search category drop-down list and input sam as the keyword. Logi JReport will search for sam in the Catalog column and the dynamic connections whose catalogs contain the text will be kept in the dynamic connection table.
Editing a dynamic connection
In the dynamic connection table, select the connection name to open the Edit Dynamic Connection dialog, in which you can edit the properties of the dynamic connection as you want.
Deleting dynamic connections
In the dynamic connection table, select the checkboxes ahead of the dynamic connections and then select Delete. To delete all the dynamic connections at a time, select the checkbox on the column header and then select Delete.
One user can have multiple dynamic connections for one catalog data source. When running a report, if there are multiple dynamic connections for the log-in user:
- For advanced run, the user needs to select a dynamic connection from the available ones.
- For schedule run, if the selected dynamic connection cannot be found when running reports, then the first available dynamic connection will be applied.
- For direct run, link reports, API run, getting parameter values from the database, and getting filter values from the database, the first available dynamic connection is applied automatically.