Previous Topic

Next Topic

Book Contents

Book Index

Configure Connections

Database connections in eDapter Toolkit can be added, removed or renamed by selecting Functions??ETK 5.0??Pool Configuration. In order to work on a database, we need to first configure it to get the connection. Once configured, the connection name appears in the eDapter Connection Manager under Connections as shown in Creating a Process_Figure 7.

Creating a Process_Figure 5: The eDapter Pool Configuration dialog box

In the eDapter Pool Configuration dialog box, we have a single menu, namely, Configure. The menus can also be accessed using the icons in the Toolbar as explained below:

Select a connection from the Connections link on the left pane of the eDapter Pool Configuration dialog box. Three tabs, namely, Basic, Advanced, and Maintenance displayed on the right pane as shown in the Creating a Process_Figure 5.

To add a new connection, click Fig-5.5-1

When clicked on new connection, a dialog box is displayed for new connection name as shown in the figure below

New Connection Name

If an existing name is given, it displays a message Connection Name already exists and no connection is created.

ConnectionExists

If no name is give, then No Name given message is displayed and no connection is created.

NoName

After giving new name and click ok and enter the following details under Basic tab:

Server Name/IP: Enter the server name

Port: Enter the port number

SID: Enter the database name

User: Enter the username authorized to access the database

Password: Enter the password for the username

Connection URL: The URL will be displayed automatically after entering the above details. If required they can be changed manually. It is the combination of protocol, IP address of the machine on which database instance is created, port number, and SID.

Example: Jdbc:oracle:thin:@192.168.0.13:1523:VIS5

Check Pool Enabled to display the connection name in the eDapter Connection Manager dialog box as shown in Creating a Process_Figure 7.

If Database Type is "MySQL", only User, Password, and Connection URL fields are enabled to fill.

ConfigureConnectons_DatabaseType_MySQL

For "SQLSERVER" database type,

ConnectionManager_SQLServerDatabaseType

Click Save to save the connection details.

If a new connection is created using existing connection details with different name then the following message will be displayed.

ConfigureConnections_2

Clicking on Yes will create new connection with new name. Clicking on No will reuse existing connection by increasing number of connections.

Test : When clicked, Triniti Message dialog box is displayed stating connection is Up/Down.

Clear : When clicked empties all the text entered in the fields.

When RAC Enabled is checked, user need to provide only User, Password and Connection URL fields. Rest all fields will be disabled.

Advanced Tab : When clicked, displays the below image.

Connection_AdvancedTab

Optimal Connections : Select the Minimum number of connection.

Maximum Connections : Select the Maximum number of connection.

Initial Connections : Select the Initial number of connection.

Maintenance tab : Check the checkbox in this tab and set time period for checking idle connections and invalid connections. The idle/invalid connections to the database are disconnected automatically after completion of the time period mentioned

Note : The user can restrict editing of the pool details by entering the password in Password field. When the pool details are restricted for a database connection then the Connection_EditEdit icons will be enabled and the other icons are disabled except Add, Refresh, and Exit as shown below.

ETK_Fig_4-5_icons

Fetch Connection Info : Will provide the details for that particular connection, as shown in the Figure below.

FetchConnectionInfo

Creating a Process_Figure 6:

The following are the icons provided to configure connections:

Create New Connection:

Click Fig-5.5-1 to create a new connection.

Save Connection:

Click Fig-4. to save the connection created.

Rename Connection:

Click Fig-7. to rename the display name of the connection. Select the database to be renamed and then click the rename icon.

Delete: Click to delete the connections from the tool. Once deleted, these connections will no longer be available for use.

Refresh: Click to refresh the connections

Start: Click to start connection to the database

Stop: Click to stop the connection

Restart: Click to restart the connection to the database

Edit: This icon is enabled for a connection, only when the pool details are restricted. Click ETK_Figure 4_5_Edit

to enter password for enabling the editable fields and functional tools that are restricted.

Exit: Click to exit eDapter Pool Configuration.

See Also

Configuring database connections

Connection Manager