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 repository anyway?
The 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
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 PosgreSQL server as a repository
More information
- Wrong repository version
- Repository structure changes
- Switching from production to development environment
- Repository structure
Direct link, no registration required.