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.
The default repository is MS access. This type of repository works fine for development and for 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.
Information about current repository connection can be seen at the window header
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 in to different directory and connect to it.
When software is installed default repository connections are created such as MS Access, Oracle, SQL Server, MySQL, PosgreSQL. When application first stars it connects to default MS Access repository.
Provided that you are using default settings all open objects will be saved and application will connect to different repository.
If you want to create new connection to the existing repository:
Same dialogue can be used to amend exiting repository connections.
Advanced ETL Processor has a lot of useful features designed to make the life of Business intelligence consultants easier. One of it is "Magic Button". At any time the user can press it and see the result of data transformation or validation without actually loading the data.
Here is data sample we want to check if customer id is numeric and reject it if not
It is also possible to enter the data directly into source grid and test it the transformation that way
Data has stable structure and there is only one value in the cell. Most database tables and delimited files can be considered as simple data. except when single field has multiple values or holds xml data.
XML tags are in the same order, number of tags is always the same and there are no attributes, This XML does not require any additional transformation and can be easily loaded into the database.
Structure is not stable, number of tags is different for different customer record, plus it uses attributes. This XML may need some additional transformations.
Data is split between different rows some empty rows should be ignored, some data must be taken from the headerAdvanced ETL Processor
Advanced ETL Processor Enterprise runs on Microsoft Windows 2008/2012//Vista/Win7/Win8/Win10
With our ETL software you can automate your business processes in couple of hours, than you can concentrate on what is important: running the business.
Today 95 percent of the businesses are small and medium size companies. Most of ETL and business automation software is designed for large companies, it requires highly skilled staff, difficult to support and far too expensive.
Our ETL software was especially designed for ordinary users.
It takes seconds to install it, works straight out of the box, easy to use and easy to support. The trial is fully functional for 30 day and if necessary the trial period can be extended.
Our support team is always happy to connect remotely and assist
|Download Visual Importer ETL Enterprise|