Manage Database Configuration

Database Configuration allows users to define database to be used to build queries on. You can define database connections and how to connect to database. The data stored in back end will be available to user through list box in published files so that they can choose appropriate value for the fields. By default, Lookup Manager and User Level Lookup Configuration tab are disabled. Add at least one database connection to enable these tabs in Lookup Management.

Add Database Configuration

This section explains how to add a database configuration.

To add a database configuration,

1. Go to Lookup Management > Database Configuration.
2. Select Add. The Database Configuration page appears.
3. Enter Connection Name.
4. Enter Server Name.
5. Enter Database Name.
6. Select Authentication for the database.
7. Enter Username and Password if you have selected the authentication type as SQL Server Authentication.
8. Select Connection Timeout by which want the connection with the database to be terminated for a period of inactivity. Enter number of seconds for timeout in Sec(s) box. Alternatively, you can use the combo box to enter the seconds.
9. Select Save to add the database configuration.

Edit Database Configuration

Select Edit to edit the selected database configuration. This option can be used to alter the connection properties even after successful database creation. Moreover, Test Connection can be used to test the connection.

Delete Database Configuration

Select the Delete icon to delete selected database configuration.

Select Yes in the confirmation window.

Test Database Configuration

Select Test (Selected) to check if the connection is getting established to the database. On successful connection the Ping to SQL server was successful message appears. On failure, Verify the details entered message appears.