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

Note:  Active Table Editor uses the same repository creation wizard

Database specific repository articles

More information

We have 254 guests and one member online