Managing Database Connection Profiles in EL and SQL Transformation Projects

The database connection profile created using the Connection Profile Manager can be used in EL and SQL Transformation projects. The settings from a profile can be applied to related project properties. You can also save settings from the database configuration windows of the EL and SQL Transformation projects as a new profile.

The database configuration windows of EL and SQL-T projects include a Profile list with stored connection profiles. To subscribe to a profile select it from the list. Alternatively, open the Connection Profile Manager, which when opened from the database configuration windows of EL and SQL-T projects shows an additional Subscribe button providing an alternate and advanced way of selecting a profile.

The Subscribe button is enabled only if the profile details displayed in the Profile Details pane is not modified, stored in the same repository as the project, and the interface is supported in the project.

When a project has a subscription to a profile the Profile list shows the respective entry selected. The connection setting project properties are populated with the current content from the stored profile and appear disabled.

Select None from the Profile list to unsubscribes and make the fields editable.

Database connection settings used in a project can be saved as a profile by opening the Connection Profile Manager. The Profile Details pane is populated with the current project property values and can be saved after a name and an optional description have been provided.

Note: When opening a project, which is subscribed to a non-existing profile, which is either deleted or not yet transferred, an initialization error message appears, and the project is unsubscribed.