How to Create a Database Target

From Jitterwiki

If you have not already done so, open the Integration tab by selecting Integration from the View menu.

Make sure you have opened the appropriate project in which you want to create the new target.

There are several ways you can start to create a new target:

• Select New in the File menu, then choose New Target from the sub-menu; or
• Click the down arrow next to the file icon in the toolbar, then choose New Target from the sub-menu; or
• Right-click on Targets in the hierarchical tree in the Integration tab in the left pane of the screen, then choose New Target from the popup menu.

Your new target appears in its own New Target tab in the right pane of the window.

1. Enter an appropriate name for your new target in the Name field.
2. Choose Database from the Type dropdown menu.
3. Select the appropriate database driver from the Driver dropdown menu. Depending upon the driver you select, different fields may become enabled or disabled.

(Optional) If you want to set a limit for how long to wait for a successful connection to the database, enter the number of seconds in the Timeout field.

4. Enter the database server name (either name or IP address) you want to access into the Server Name field.
5. Enter the name of the database you want to access into the Database Name field.
6. Enter a valid username that will allow access to your database into the Login field, then click the Password button and enter the appropriate password.

(Optional) If there are any additional parameters that you want to add to your database connection string (such as a non-default port ID), enter them in the Additional Connect String Parameters field.

7. Click the Save button in either the main toolbar or the target's toolbar.

(Optional) If you want to test whether your new target can connect with the specified database, click the button in the target's toolbar.