Managing Database Connection Profiles

Database connection profiles allow specifying frequently used database connection details and storing them together with a profile name and a description in the repository for later use in EL and SQL Transformation projects.

Creating connection profiles supports faster and easier project design by applying the settings from a stored profile to respective project properties instead of entering them manually.

Projects can even hold a reference to stored profiles. Changing profile information automatically affects all projects referencing it when opened for design or execution, thereby supporting lifecycle management in these ways:

Testing against different databases can be accomplished by changing a profile for all projects instead of creating parameter sets for each project.
Switching from a development to a production environment can be accomplished by transferring the projects, given that the same profile with different settings exists on both repositories.

From the Sybase IQ InfoPrimer Development interface, select Tools > Connection Profile Manager.
The Connection Profile Manager shows a list of all defined connection profiles for a selected repository session and a Profile Details pane, which is populated with data when you select a connection profile and where a profile setting is edited.
Create a new connection profile.
- Select Profile > New or click the Add Connection Profile icon.
- Enter a name, description, and the other connection details.
- Click Test Logon.
- Click Save Connection Profile to create the connection profile.
The connection profile displays in the list.
To make changes to a profile, select it and edit it in the Profile Details pane. Click Save to save any changes or Revert to restore the original settings. To save it as a new profile select Save As.
To delete a profile, select the profile in the list, and click Delete.