This topic describes how you can use the New Dynamic Connection dialog box to create a dynamic connection.
Server displays the dialog box when an administrator selects New Dynamic Connection in the Administration > Connection > Dynamic Connections page on the Server Console.
Specify the catalog in which you would like to create a dynamic connection. Select Browse to select a catalog in the Select Catalog dialog box, or type the catalog path in the text box, for example,
Data Source Name
Select the data source in which you would like to create a dynamic connection in the catalog.
Select a connection to connect to the data source.
Properties of the database connection. You can select it to expand or collapse the property table.
Add Database User Mapping
Select to add a new database user mapping.
Select to delete the selected database user mappings.
Database user mapping table
After you select the database user mappings, you can then delete them if you do not want them. You can select the checkbox on the column header to select all database user mappings.
Select the security identifier (SID). A SID can be a group, role, or user in the Logi Report Server security system. You can define at most one database user mapping for an SID within a dynamic connection.
- Organization Name
Double-click the text box, and then select an organization. You can first specify the organization and then the SID. The column is available to system admin when the Organization feature is enabled.
- Database User
Double-click the text box, and then type the database username. Null means using the default database username.
- Database Password
Double-click the text box, and then type the database password. Server masks the password.
Select Test Connection to test whether the connection configuration works using the database username and password.
Select to create the dynamic connection and exit the dialog box.
Select to close the dialog box without creating a dynamic connection.
Select to view information about the dialog box.