Working with Repository

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.

Provider Not Found Error Message

The user may receive the message above after installing 64 version of our ETL Software. This is because by default 64 bit OLE driver for MS Access is not installed on windows. Although it is possible to install 64 bit OLE driver for MS Access by using our software we strongly recommend against it. The best course of actions is to use a proper database as repository such as MS SQL Server or Oracle.

Installing MS Access Runtime

During setup, our software will install Access runtime if selected

Installing 64-bit Access runtime on the computer where 32-bit version of MS office is already installed will lead to problems working with MS office (Repairing MS Office installation error message).

Information about current repository connection can be seen in the window header

Creating Repository

Repository can be created by running script or by using repository creation wizard.
They are located in C:\Users\Public\Documents\DBSL\Repository Scripts.

To create 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, PosgreSQL. When the application first stars it connects to the default MS Access repository.

Connecting to different Repository

  1. Click Maintain tab
  2. Select the desired connection from the drop-down box
  3. Click reconnect.

Provided that you are using default settings all open objects will be saved and the application will connect to a different repository.

Creating new Repository

  1. Click Maintain tab
  2. Click create new
  3. Follow the wizard steps
  4. Once the repository is created connect to it

Creating new Repository connection

If you want to create new connection to the existing repository:

  1. Click Maintain tab
  2. Click options
  3. Click plus
  4. Fill all necessary details
  5. Test connection
  6. Click OK
Same dialogue can be used to amend exiting repository connections.

Backing up Repository

  1. Click Maintain tab
  2. Click backup
  3. Select the file to save data into
  4. Done

Restoring Repository

  1. Click Maintain tab
  2. Click restore
  3. Select the file to restore data from
  4. Done

To copy repository data from development to production environment

  1. Connect to the development environment
  2. Backup repository
  3. Connect to the production environment
  4. Restore repository

Repository objects synchronization

  • Run Repository Synchronization Wizard
  • Select source repository or repository backup
  • Select 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 target repository and update connections if necessary

Controlling size of Repository

While execution 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.

  1. Click Execution Log tab
  2. Click clear log button

Information above is relevant to both Advanced ETL Processor and Visual Importer ETL and some of of it to Active Table Editor

Unable to connect to the Repository

Default repository is MS Access. The important thing to understand that the 32-bit version uses 32-bit version drivers and it cannot use 64-bit drivers. Same apply to the 64-bit version. Before installing the 64-bit version you have to make sure that relevant 64-bit drivers, ODBC Drivers, OleDB Providers and Clients are installed.

Video Tutorials

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

  • knowledgebase/working_with_repository.txt
  • Last modified: 13/04/2019 17:26
  • by admin