Configure Data Source Connection

This topic describes the procedure for configuring the Data Source Connection with different databases.

To configure a new data source connection,

1. In Process Runner DB, select the Home tab > Manage Data Source. The Data Source Configuration dialog appears.
2. Select New. The Data Source Detail dialog appears.
3. In the Data source list, select your data source.
   • For MS SQL Server data source, specify the following details:

     

     Name: Enter the connection name

     Server: (<hostname or IP>). For example:-192.168.100.45

     Database: Enter the database name

     Auth. Mode: Select the authentication mode

     User name: Enter the user name

     Password: Enter the password

   • For Oracle data source, specify the following details:

     

     Name: Enter the database name

     Server: (<hostname or IP>)(:<port>)(/<database service name>) For example:- 192.168.100.45:1521/example.com

     User name: Enter the user name

     Password: Enter the password

   • For MySql data source, specify the following details:

     

     Name: Enter the name to use for this database connection

     Server: (<hostname or IP>) Eg:-192.168.100.45

     Database: Enter the database name

     User name: Enter the user name

     Password: Enter the password

   • For ODBC data source, specify the following details:

     

     Name: Enter the name to use for this database connection

     DSN: Enter/select the DSN name which is created in ODBC Data Source Administrator

     User name: Enter the valid username that is used in the database server.

     Password: Enter the password for the user.

     Field/table Identifier: Set Field or Table identifier for respected database.

     Option	Description
     '[]'	Identifier is used for MS-SQL, DB2, MS-Access type of database.
     " "	Identifier is used for Oracle, Sysbase type of database.
     ' '	Identifier is used for My SQL

   • For OLEDB data source, specify the following details:

     

     Name: Enter the name to use for this database connection

     Connection: Enter the connection string.

     Field/table Identifier: Set Field or Table identifier for respected database.

     Option	Description
     '[]'	Identifier is used for MS-SQL, DB2, MS-Access type of database.
     " "	Identifier is used for Oracle, Sysbase type of database.
     ' '	Identifier is used for My SQL

4. Optionally, select Test Connection.
5. Select OK. The connection name appears in the list of data source.