NOTE! This site uses cookies and similar technologies.

If you not change browser settings, you agree to it. Learn more

I understand

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

Source data Here is the mapping we will use for it.

Mapping ExampleIs Number transformation functionWe press the "Magic Button"

Magic buttonAnd we can immediately see the result of transformation: record rejected 

Mapping Result failure

record passed the test Mapping Result success

It is also possible to enter the data directly into source grid and test it the transformation that way

Mapping Result success

Learn MoreDownloadBuy Now

This Article provides examples of complex and simple data. We recommend using   Advanced ETL Processor for working with complex data structures and Visual Importer ETL with simple, if in doubt please contact us and we will help you to choose.

Simple data example : Excel file.

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.

Simple excel fileSimple XML file:

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.

Simple XML

Complex XML message:

Structure is not stable, number of tags is different for different customer record, plus it uses attributes. This XML may need some additional transformations.

Complex XML

Complex Text file:

Data is split between different rows some empty rows should be ignored, some data must be taken from the header

Complex TEXT

Sql insert script:

Data can be easily extracted or generated using   Advanced ETL Processor

Insert Statement

Download Visual Importer ETL Enterprise Download Advanced ETL Processor Enterprise

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.

Our prices start only from 100 usd per licence.

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

Transformation sample


Download Visual Importer ETL Enterprise

Download Advanced ETL Processor Enterprise

Which ETL tool is right for me?

95 percent of the businesses are small and medium sized enterprises, All of them want to automate routine business processes so they can concentrate on what is important: running the business.

We offer Automation software which is easy to use and it works right now. There is no need to hire highly skill staff to deliver automation solution.

With our ETL software complex processes can be automated with days not weeks.

Current BI trends:

Everyone is taking about BIG DATA, as a result of it everything is geared up towards large corporations with big budgets. Most of the solutions are difficult to implement, use and support plus they require high end hardware and large BI teams. It is very expensive and difficult to implement something simple, like automatically sending price list updates to the customers.

Fork as ETL?

Our prices start only from 100 usd per licence.

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

Transformation sample


Download Visual Importer ETL Enterprise

Download Advanced ETL Processor Enterprise

Which ETL tool is right for me?

"Advanced ETL Processor is superior software... I highly recommend this to anyone who is building datawarehouse. I would and I  have recommended it to many colleagues and customers."

- Peter Jonson, Data Integration Consultant, MPI

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with