Repository Database

Repository Database Overview

The repository database is where all user data, configurations, and project details are stored for our ETL Software . The default repository database type is MS Access.

It is not recommended to use MS Access as a repository in a production environment, as it tends to get corrupted over time.

Supported Repository Types:

MS Access
SQL Server
Oracle
PostgreSQL
MySQL
Interbase/Firebird

The repository must be created first.

Creating a New Repository

Click Create New.
Follow the Repository Creation Wizard steps.
Connect to the newly created repository.

Transferring Data Between Repositories

Connect to the source repository.
Backup the repository.
Connect to the target repository.
Restore the repository.

Repository Objects Synchronization

Run the Repository Synchronization Wizard.
Select the source repository or a repository backup.
Choose the target repository.
Drag and drop source repository objects onto target repository objects to update them.
Drag and drop source repository objects into the target category to add new objects.
Connect to the target repository and update connections if necessary.