How to Create an Database Source

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 store the new source.

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

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

Your new source appears in its own New Source tab in the right pane of the window.

1. Enter an appropriate name for your new source 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. <li>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 Connection String Parameters field.

(Optional) The Construct Connection String manually checkbox is unchecked by default. If you would like to define this string yourself, check this check box. You must then enter the string in the corresponding text field. For more information, see Manual connection string .

6. Click the Save button in either the main toolbar or the source's toolbar.

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