Internal Database Connections
Internal database connections are part of a graph, they are contained in it and can be seen in its source tab.
Creating Internal Database Connections
To create an internal database connection, right-click Connections in the Outline pane and select Connections > Create DB connection.
You can also open the dialog by selecting some DB connection item in the Outline pane and pressing Enter.
For detailed information about how a database connection should be created and configured, see Database Connection Properties.
When all attributes of the connection have been set, you can validate your connection by clicking the Validate connection button.
To create the internal database connection, click Finish. The new internal database connection is a part of the graph.
Externalizing Internal Database Connections
Each internal database connection can be externalized, i.e. converted to the external one. Thus, you would be able to use the same database connection for more graphs, i.e. more graphs would share the connection.
You can externalize an internal connection by right-clicking the internal connection item in the Outline pane and selecting Externalize connection from the context menu. A new window will open. The dialog offers the conn
folder of your project as the location for this new external (shared) connection configuration file.
A configuration file name is created from the database connection name; however, it can be changed. Click OK to finish externalization.
The internal connection item disappears from the Outline pane Connections group; but at the same location, there appears already linked the newly created external (shared) connection configuration file. The same configuration file appears in the conn
subfolder of the project. The file can be seen in the Project Explorer pane.
Externalizing Multiple Connections
You can externalize multiple internal connection items at once.
To do this, select them in the Outline pane. Right-click and select Externalize connection from the context menu. A new window will open in which the conn
folder of your project will be offered as the location for the first of the selected internal connection items. Finally, click OK.
The same window will open for each of the selected connection items until they are all externalized. The name of any configuration file can be changed. If you want or if the file with the same name already exists, you can change the offered name of any connection configuration file.
You can choose adjacent connection items when you press Shift and move the Down Cursor or the Up Cursor key. If you want to choose non-adjacent items, use Ctrl+Click at each of the desired connection items instead.
The same is valid for both the database and JMS connections.
After that, the internal file disappears from the Outline pane connections folder; but at the same location, a newly created configuration file appears.
The same configuration file appears in the conn
subfolder in the Project Explorer pane.
Exporting Internal Database Connections
Exporting is similar to externalizing an internal database connection. You create a connection configuration file that is outside the graph in the same way as an externalized connection, but such a file is no longer linked to the original graph. Subsequently, you can use such a file in other graphs as an external (shared) connection configuration file as mentioned in the previous sections.
You can export an internal database connection into an external (shared) one by right-clicking one of the internal database connection items in the Outline pane and selecting Export connection from the context menu. The conn
folder of the corresponding project will be offered for the newly created external file. The name of the file can be changed. Click Finish to create the file.
After that, the Outline pane connection folder remains the same, but in the conn
folder in the Project Explorer pane the newly created connection configuration file appears.
You can even export more selected internal database connections in a similar way as it is described in the previous section about externalizing.
Updated 9 months ago