Repository

Dealing with repository is a popular topic on our support forum; this article combines all the information about repository database into one place.

What is repository anyway?

Repository is a database which stores information about connections, objects, schedule and execution details. Some of the data is encrypted.
The repository structure is the same for all relevant products. This allows sharing and reusing the data.

Following products use repository database:

•  Visual Importer ETL Professional
•  Visual Importer ETL Enterprise
•  Advanced ETL Processor Professional
•  Advanced ETL Processor Enterprise
•  Active Table Editor
•  Database Browser

Supported repository types

• MS Access
• SQL server
• SQL server compact
• Oracle    
• PostgreSQL
• MySQL
• Interbase/Firebird

Note: Default repository database is MS Access. It is not recommended to use MS Access as repository in production environment, because it tends to get corrupted over time

Creating repository

Before "Repository" can be used it must be created and tables inside the repository must be created. There two ways to create repository manually and using repository creation wizard

Note:  Once installation is completed user may find all the scripts in C:\Users\Public\Documents\DBSL\Repository Scripts\Repository

VIDEOS

• • Creating Repository database
  • Working With Repository Backups
  • Performing repository synchronisation

Note:  Active Table Editor uses the same repository creation wizard

Database specific repository articles

• Using Oracle database as repository
• Using MS SQL Server as repository
• Using MySQL Server as repository
• Using Interbase/Firebird as repository
• Using PosgreSQL server as repository

More information

• Wrong repository version
• Repository structure changes
• Switching from production to development environment
• Repository structure