Manage Database Connections
In this section users are allowed to define database which is used to store data and this data is used to validate the values present in process files in Process Runner.
Database Connections displays the following details in tabular form.
| Options | Description |
|---|---|
Connection Name |
Displays the name of the database connection. |
Connection Type |
Displays the type of database. |
Server |
Displays the server information. |
Database Name |
Displays the name of the database that is setup. |
Add |
Allows addition of new database connection. |
Edit |
Allows modification of existing database connection. |
Delete |
Allows deletion of database connection. |
Export |
Allows to Export the selected Database Connection to the local system. Select here to know more on this. |
Import |
Allows to Import the selected Database Connection from the local system. Select here to know more on this. |
Add Database Connection
Add is used to add new database connection. Select Add. The Add Database Connection page appears.
Enter the following details on the page:
- Connection Name: Name defined by user for the database connection.
- Connection Type: Allows selection of the type of the database which is going to store the data. This data will be used for validation of the data present in process file. It has 'Sql Server' as the default value and the fields under Connection String change as per the selection. The other options available are 'Oracle' and 'Other'.
-
Connection String: The details of the database are entered here.
- Server: Input the Server IP address where the database is setup.
- Database: Input the name of the database that is setup.
- Authentication Mode:SQL Server Authentication and Windows Authentication options are available in the drop-down. Select appropriate option for your database connection. Note that for Windows Authentication user must have permission for that database.
- User Name / Password: For SQL Authentication, enter the user name and password to access the database.
- Test Connection: Allows to check if the connection is getting established to the database.On successful connection 'Test connection succeeded.' message is displayed. On failure message verify the details entered.
- Save: The details are saved and are displayed in Database Connections screen.
- Cancel: Closes currently opened window and Database Connections screen gets displayed.
The following screenshot displays Oracle as Connection Type.
- Connection String: The details of the database should be entered.
- Server: Input the Server IP/address.
- User Name / Password: Enter the login information to access the database.
The following screenshot displays Other as Connection Type.
Connection String: If the user is does not choose SQL server or Oracle, details can be specified by choosing 'Other' as the Connection Type. OLEDB provider of that database should be installed on that system. For example, Microsoft Access.
Edit Database Connection
Select the Edit icon to edit the selected database connection.
Admin Info
- Created By: Displays the name of the user who created the database connection.
- Created On: Displays the date and time when the database connection was added. The time displayed is as per user time zone settings.
- Changed By: Displays the name of the user who updated the database connection.
- Changed On: Displays the date and time when the database connection was last updated. The time displayed is as per user time zone settings.
Delete Database Connection
Select the delete icon to delete selected database connection.