Dealing with the repository is a popular topic on our support forum; this article combines all the information about the repository database into one place.
What is a repository anyway?
The repository is a database that 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: The default repository database is MS Access. It is not recommended to use MS Access as a repository in a 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 a repository manually and using the 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 a 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 a repository
- Using MS SQL Server as a repository
- Using MySQL Server as a repository
- Using Interbase/Firebird as a repository
- Using PostgreSQL server as a repository