Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103

Warning: Undefined array key 1 in /home/tools/www/www/wiki/lib/plugins/note/syntax.php on line 103

Repository Database

The repository is the most important database our ETL Software users work with it everyday because this is where everything is stored. The default repository database type is MS Access.

It is not recommended to use MS Access as a repository in a production environment, it tends to get corrupted over time

Supported repository types are:

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

The repository must be created first
  • Click create new
  • Follow the Repository creation wizard steps
  • Connect to the newly created repository
  • Connect to a source repository
  • Backup repository
  • Connect to a target repository
  • Restore repository
  • 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

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • aetle/repository_database.txt
  • Last modified: 12/01/2023 07:45
  • by admin