Advanced ETL Processor can connect to an existing repository after installation. Use this when the application has been installed on a new workstation or server, but the transformations, packages, connections, reports, SQL scripts, and settings already live in a repository database.
What You Will Learn
- Identify the existing repository database before connecting.
- Connect the new installation to the correct repository.
- Check that packages, transformations, and connections are visible.
- Avoid creating a blank repository when the existing one should be reused.
Before You Start
Confirm the repository location, database type, credentials, and backup status before changing connection settings. Guessing repository details is how duplicate empty repositories appear, and nobody enjoys that archaeology later.
Repository Connection Docs
The Repository Database documentation explains what the repository stores and which database types are supported. Review the repository database overview before connecting a new installation to shared work.
If this is a fresh installation, start with installing Advanced ETL Processor Enterprise and the requirements page. The application must have the required database drivers or client libraries before it can connect to some repository types.
For existing environments, repository connection work is usually safer after a backup. The repository holds connections, transformations, packages, SQL scripts, reports, and execution logs, so check repository backups before making changes.
If the application opens but reports a repository mismatch, use the wrong repository version troubleshooting page and the repository database update guides.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.