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.
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.