ETL Version Control why you need it

We do a lot of consutancy work and we decided to introduce version control after one of our customers modified transformations beyond use. Version control helped us to restore project to it's original state. Another situation when version control is very usefull is a large project with multiple developers.

Advanced ETL Processor version control tab

More about ETL-Tools

Latest ETL Software changes

+ New Version control tab was introduced
+ Version control can submit several objects now
+ Version control dialogue can delete multiple objects now
- Various bug fixes

Choosing right ETL tool

We have two ETL products Visual Importer ETL and Advanced ETL Processor.

Which one to choose depends on the complexity of the data and now you want to work with it

This article provide some examples of complex data

If you just want to load data from table, delimited file or simple XML file choose Visual Importer ETL.

If you work with complex data and require data validation, transformation or sorting and on top of it you also want to be able to generate the data select Advanced ETL Processor.

Both Advanced ETL Processor and Visual Importer ETL have 3 editions:

Standard Edition is designed for desktop user who just wants to run data load or transformation manually.

Professional Edition is designed for user who wants to execute business automation processes manually (Developers).

Enterprise Edition is designed for user who wants complete automation of business processes.

Selecting ETL Software

Download Visual Importer ETL Standard      Download Advanced ETL Processor Standard     
Download Visual Importer ETL Professional Download Advanced ETL Processor Professional
Download Visual Importer ETL Enterprise    Download Advanced ETL Processor Enterprise   

We made it easy to get support for etl software

Simple ways of getting support for ETL software.

In this article we are going to show you how easy it is to get support for our products.

First of all there are several ways of getting support.

  • Support Forum
  • Email To: This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Online Contact Form

If you are stuck we can call you and connect remotely.
It is very important to provide as much information as possible first time.

  • Software name
  • Version number
  • Steps to reproduce the problem
  • Screen shots
  • Scripts to create the tables
  • Actual data example
  • Repository

Our support team is very fast and quite often they resolve the problem within one hour.

The software is designed in such a way that it is easy to contact support.

For Advanced ETL Processor click “Help” and then click “Email repository and Log Files to support” than the default email client will open and the use can enter additional information and attach more files. Using same menu the use can send email to support team or visit support forum.

Getting Support for Advanced ETL Processor

Using same menu the user can send email to support team or visit support forum.

Same principle works for Visual Importer ETL and Active Table Editor.

Getting Support for Visual Importer ETL

Getting Support for Active Table Editor

We encourage you to use our support forum first, so other users will benefit as well. If your issue is urgent contact us, We are always happy to connect remotely and assist.


SSIS excel problem

Solving SSIS problems with loading data from Excel

We have the following situation:

Imagine that you are working for large finance organization and would like to load the year end balances into SQL Server database. The excel file look like this.

Excel File

So we create a simple SSIS package using Excel connector and Ole DB destination, before loading the data we hit preview button.

SSIS Preview Result

For some reason last 3 lines have null values, This is because our connection string has not got IMEX=1

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DEMO\Excel\mixed_data_types.xls;Extended Properties="EXCEL 8.0;HDR=YES";

We correct it

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DEMO\Excel\mixed_data_types.xls;Extended Properties="EXCEL 8.0;HDR=YES;IMEX=1";

SSIS Preview Result

That looks much better so we load the data. Later same day, the finance manager says that the balance is wrong you look at the data and there are some null values again.

Why we have null in the database?

Read more...

More Articles...

"I've been very impressed with Advanced ETL Processor. It is extremely powerful and can validate and transform practically any data set you work with."

David Gig,
Director of Information Technology

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
Databases we work with