Repository Database

The repository database is where our ETL Software users work is stored. The default repository database type is MS Access.

Supported repository types are:

• MS Access
• SQL Server
• Oracle
• PostgreSQL
• MySQL
• Interbase/Firebird

Creating new repository

• Click create new
• Follow the Repository creation wizard steps
• Connect to the newly created repository

Transferring data between repositories

• Connect to a source repository
• Backup repository
• Connect to a target repository
• Restore repository

Repository objects synchronization

• Run Repository Synchronization Wizard
• Select source repository or repository backup
• Select the target repository
• Drug and drop source repository objects on top of target repository objects to update target object
• Drug and drop source repository objects in the target category to add a new object
• Connect to the target repository and update connections if necessary

Knowledgebase Articles

• Repository Tables
• Configuring SQL Server Repository
• Configuring Interbase/Firebird Repository
• Configuring MySQL Repository
• Configuring PostgreSQL Repository

Video Tutorials