Why it is important to know how to work with the repository.
The repository database stores all the information about connections, transformation scripts, packages, SQL scripts, reports, and execution logging. This is where the results of ETL designer hard is stored and obviously, no one wants to lose it.
Default repository.
The default repository is MS Access. This type of repository works fine for development and for a small production environment. From time to time we recommend to perform “compact and repair” using MS Access. For heavy production environment for example when we want to run packages every minute in parallel we recommend using something else like MS SQL server or Oracle.
Note:
Information about current repository connection can be seen at the window header
Creating a repository.
The repository can be created by running a script or by using the repository creation wizard.
They are located in C:\Users\Public\Documents\DBSL\Repository Scripts.
To create a new MS Access repository copy
C:\Users\Public\Documents\DBSL\Repository Scripts\Repository\ Repository.mdb into the different directory and connect to it.
Default Repository connections.
When software is installed default repository connections are created such as MS Access, Oracle, SQL Server, MySQL, PostgreSQL. When the application first stars it connects to default MS Access repository.
Connecting to a different repository.
- Click Maintain tab
- Select the desired connection from the drop-down box
- Click reconnect.
Provided that you are using default settings all open objects will be saved and the application will connect to the different repository.
Creating a new repository.
- Click Maintain tab
- Click create new
- Follow the wizard steps
- Once the repository is created connect to it
Creating a new repository connection
If you want to create a new connection to the existing repository:
- Click Maintain tab
- Click options
- Click plus
- Fill all necessary details
- Test connection
- Click OK
The same dialogue can be used to amend existing repository connections.
Backing up repository
- Click Maintain tab
- Click backup
- Select the file to save data into
- Done
Restoring repository
- Click Maintain tab
- Click restore
- Select the file to restore data from
- Done
To copy repository data from development to production environment
- Connect to the development environment
- Backup repository
- Connect to the production environment
- Restore repository
Controlling the size of the repository
While executing scheduled tasks the size of the repository is constantly growing. From time to time it might become necessary to clear execution log tables otherwise it might have a negative impact on performance.
- Click monitor tab
- Click the clear log button
The information above is relevant to both Advanced ETL Processor and Visual Importer ETL and some of it to Active Table Editor
