|Creating External (Shared) Database Connections|
|Linking External (Shared) Database Connections|
|Internalizing External (Shared) Database Connections|
External (shared) database connections are connections stored outside graphs, so they can be used in multiple graphs.
Only the connection configuration is shared. If two graphs use the same external (shared) connection, they use the same connection configuration, but each of them has its independent database connection.
Best practice is to place an external (shared) connections into the
To create an external (shared) database connection, select Connection subcategory. Open the item.→ → from the main menu. Expand the category and its
In the dialog, specify the properties of the external (shared) database connection in the same way as in the case of internal one. For detailed information about how database connections should be created, see Database Connection Properties.
When all properties of the connection have been set, you can validate your connection by clicking thebutton.
and choose the name for your external database connection file.
Finally, click .
Any linked external (shared) connection can be converted into an internal connection. The connection becomes a part of the graph, but the external configuration file does not disappear. In such a case, you would see the connection structure in the graph itself.
You can convert any external (shared) connection configuration file into an internal connection by right-clicking the linked external (shared) connection item in the Outline pane and using from the context menu.
You can even internalize multiple linked external (shared) connection configuration files at once.
To do this, select the desired linked external (shared) connection items in the Outline pane. You can select adjacent items when you press Shift and move the Down Cursor or the Up Cursor key. If you want to select non-adjacent items, use Ctrl+ at each of the desired items instead.
After that, the selected linked external (shared) connection items disappear from the Outline pane Connections group; but at the same location, newly created internal connection items appear.
However, the original external (shared) connection configuration files will remain
conn subfolder as can be seen in the Navigator pane.
The same is valid for both the database and JMS connections.
Figure 34.3. Internalizing External (Shared) Database Connection