Working with Repository

The repository database stores all the information about connections, transformations, packages, SQL scripts, reports and execution logging. This is where the results of ETL designer hard work is stored and obviously, no one wants to lose it.

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 performing “compact and repair” using MS Access. For heavy production environments for example, when we want to run packages every minute in parallel we recommend using something else like MS SQL Server or Oracle.

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 a 64 bit OLE driver for MS Access by using our software we strongly recommend against it. The best course of action is to use a proper database as repositories such as MS SQL Server or Oracle.

During setup, our software will install Access runtime if selected

Installing 64-bit Access runtime on the computer where the 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

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.

When software is installed default repository connections are created such as MS Access, Oracle, SQL Server, MySQL, PostgreSQL. When the application first starts it connects to the default MS Access 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.

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

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

  1. Click Maintain tab
  2. Click options
  3. Click plus
  4. Fill in all necessary details
  5. Test connection
  6. Click OK
Same dialogue can be used to amend exiting repository connections.
  1. Click Maintain tab
  2. Click backup
  3. Select the file to save data into
  4. Done
  1. Click Maintain tab
  2. Click restore
  3. Select the file to restore data from
  4. Done
  1. Connect to the development environment
  2. Backup repository
  3. Connect to the production environment
  4. Restore repository
  1. Connect to the development environment
  2. Backup repository
  3. Connect to the production environment
  4. Right-click on the object tree and restore the project
  5. Select the project to restore and click OK

  • 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 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.

  1. Click the Execution Log tab
  2. Click the 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 error

The default repository is MS Access. The 64-bit setup offers the option to install the 64-bit version of access drivers. Without them, the 64-bit version of our software will not be able to work with access or use it as a repository. We do not recommend using MS access as a repository in a production environment. The important thing to understand that the 32-bit version uses 32-bit version drivers and it cannot use 64-bit drivers. The same applies 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.

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: 01/08/2022 14:46
  • by admin