(icon-home)Home

If you are struggling with the amount of data you have to process every day you came to the right place

2008-12-31T07:56:51Z

Our objective is to design user friendly ETL software, which easy to deploy, can be used without training and works immediately after the installation. Our ETL software can be used by non-technical staff and there is no need to ask IT department for assistance

With our ETL software any business small and large can automate routine process and concentrate on what is important: growing the business.

Simplicity is the answer:

Have ever tried to explain over the phone to an accountant how to load data from excel file using SSIS?

Our ETL software removes burden of support from IT departments. It is designed in such a way even if there is a problem it is very easy to get support from us.

All our products are compatible with each other and they can share same repository. For example if the user creates a connection in Visual Importer ETL it can be used in Active Table Editor as well. That cuts the development time and cost.

Today most of BI software vendors concentrate on large companies’ demands helping them to process terabytes of data. The solutions they create are unaffordable to start-ups and small business. They require expensive hardware and highly qualified staff. The fact is 95% of all businesses are small businesses and our ETL software can help any business to achieve their goals.

Here are the some examples of what our software can do for you today:

{multithumb enable_thumbs=1 num_cols=4}Screenshots
Click on thumbnail to see the screenshot

Used by thousands of happy companies and individuals worldwide

Testimonials

2011-08-06T00:00:00Z

What our customers say:

"Currently we are using Visual Importer Ent to import our client’s customer RMA data into our SQL server for further processing and export same data to their ftp server.
We Process 3000 files daily, 24h x 365d"
C Gandhi, Nesa-Canada

"Our prior imports were done using VB. Our VB expert retired. No one in my group knows VB. So Visual Importer ETL was the answer to the lack of VB skills problem my group experienced."
Ron Bradshaw,IT Reporting Manager, ConAgra Foods / Lamb Weston

"Advanced ETL Processor ETL it is the only software which treats our POP3 server as a database server."
Tom Barker Director of Information Technology

"Using Advanced ETL Processor made me realise my time is important and it is expensive. I have wasted a week trying to make SSIS work correctly with Excel. Than I found Advanced ETL Processor and since than no more problems..
Mark Boulton,Datawarehouse Architect

Feedback from the customer

2012-04-30T00:00:00Z

This is a part of real email with all names removed

I wanted to share this with you.
This is the software we will be using to export XML from MYOB access, FTP upload XML file to server, FTP download order files from server, process order files, and write to our MYOB database.
http://www.etl-tools.com/etl-tools/advanced-etl-processor-enterprise/overview.html

This software is absolutely amazing, and is very reasonably priced. You can do just about anything with it, and the support from Mike that I have had in setting up the program is just as amazing as the product itself. He has promptly answered all my queries and spent a lot of time helping me configure it specifically for our requirements.

I hope you can maybe even find a use for this for yourself at work or in your future private contracts. Please also forward the link on to anyone who you know who may have a use for it. I really want to support Mike with getting his product out there, as honestly I am blown away with the help he has given me and I feel indebted to him for his service.

Differentia Consulting becomes a partner of ETL-Tools.com

2012-03-09T00:00:00Z

Differentia Consulting are Elite QlikTech partners offering development, installation, training and support for QlikView Business Intelligence software.

Differentia Consulting has provided consulting, solutions, resourcing, support and training services to many different clients since 2002. We are long standing partners of IBM and Oracle, and a QlikView Elite Solution Provider with QlikView customers from all sectors and core technologies (Oracle, SAP, Infor, IFS, Microsoft, SAGE, Siebel, SalesForce, SugarCRM etc). Differentia Consulting has an ERP heritage; however, the company has expanded into the agile analytics space both from a software resale and value add consulting perspective

Differentia Consulting has an excellent reputation for enabling organisations to improve their performance primarily through the analysis of existing business problems and the development of plans for improvement utilising disruptive and Lean IT tools such as QlikView.

Creating QVX files

2012-03-27T09:17:30Z

Latest version of Advanced ETL Processor can create 14000 QVX records per second, approximately 1 million records per minute.

This is 10 x increase comparing to the previous version!

There are two ways of creating QVX files using packages or from the transformation. It is possible to save all tables in the database into QVX files with several clicks. And it is also possible to perform complex data transformations.

Using dynamic SQL for ETL transformations

2012-03-09T00:00:00Z

Based on users feedback in latest version of Advanced ETL Processor and Visual Importer ETL we have made it possible to edit Insert/Update/Delete/Count SQL statements manually.

To enable this option

Click Data target/Writer properties
Select Transformation tab
Tick "Use user defined SQL" check box
Edit every SQL statement individually.

Note

To regenerate the SQL statements clear it and open it again.

Keep the fields order same and in there are any changes with target table structure, regenerate everything again

New Year with New Business intelligence software

2008-12-02T17:26:25Z

Today we are proud to announce that after several months of hard work and intensive testing new versions of Visual Importer ETL, Advanced ETL Processor, Active Table Editor and Database Browser are finally live. They bring to the users enormous number of useful changes, usage improvements and bug fixes.

Parallel Processing
Highly optimised code
Execution agent is now only 5 mb (compare this to some java etl tools)
Schedule for execution Packages, Transformations and SQL scripts
Application Notes
Notes for Directories and Connections.
Connection testing for FTP,SMTP and POP3
Mutiple SMTP, POP3, and FTP connections
CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,
MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,
Whirlpool checksums
Package Debugging
Multiple SQL editors
New repository structure compatible with Database browser,
Advanced ETL Processor and Active Table Editor
Design and Generate Reports
Easy agent management

Run Packages, Transformations, Import scripts and SQL scripts
from the command line
300 data transformation and validation functions
Edit lookup data
Simplified Repository management
Execution log has Execution time percentage
Schedule package execution directly from the package designer
Same for sql scripts and data transformations
Schedule for execution on specific computer
Schedule for execution using agent only as option
Easy agent management
Simplified Repository management
Agent status logging and current agent tasks grid
Documentation update
Support for themes
After and Before transformation functions

Have an Idea? Let us know and we will implement it for you.
Do not know how to transfom the data, let us know and we will help you.

Please use our support forum to provide us with feedback, we are are always happy to assist anyone having problems

Working with QVX files

2008-12-02T17:26:25Z

Those people who work with QlikView know that it requires direct connection to the database to pull the data from, which is not possible to implement in some situations. One of the solutions is to use QVD files but again there is no way to create them without using QlikView.

In version 10 QlikView has introduced support for QVX files.

QVX (QlikView data eXchange) is a new file/stream format for high performance data input into QlikView. A QVX formatted file contains metadata describing a table of data and the actual data. In contrast to the QVD format, which is proprietary and optimized for minimum transformations inside QlikView, the QVX format is public and requires a few transformations when exporting data from traditional data base formats.

Adavanced ETL processor and Visual Importer ETL allow the user to export entire data warehouse into QVX files just with in few click and no programming

Data can be generated from virtually any data source.

Note

All data is exported as UTF8 text using row delimiter

Here is the link to file format specification.

http://community.qlikview.com/servlet/JiveServlet/previewBody/2677-102-1-2852/QlikView%20QVX%20File%20Format.pdf

Online tutorial.

How to save entire datawarehouse into QVX files with just s few cliks

Visual Importer ETL version 8 is ready for testing

2008-12-02T17:26:25Z

After several months of hard work Visual Importer ETL version 8 is finally available for download. It introduces enormous amount of useful changes, improvements and bug fixes:

Dowload Professional or Enterprise version

New repository structure compatible with Database browser,
Advanced ETL Processor and Active Table Editor
Mutiple SMTP, POP3, and FTP connections
Design and Generate Reports
Easy agent management

Package Debugging
Parallel execution
Highly optimised code
Application Notes
Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

Annoncing Active Table Editor - Version 5

2008-12-02T17:26:25Z

After months of hard work Active Table Editor version 5 is available for download. It introduces enormous amount of useful changes, improvements and bug fixes:

New repository structure compatible with Database browser,
Advanced ETL Processor and future release of Visual Importer ETL
Individual menu item sorting

Linked Reports
Ability to print individual records
Various bugs fixes and improvements

Upgrading Reposistory

Support will provide assistance to existing customers who pay for support and maintenance.

Reporting problems

Please use our support forum to provide us with feedback. we are currently looking for beta testers and will be happy to assist anyone having problems

(icon-home)Home

If you are struggling with the amount of data you have to process every day you came to the right place

Testimonials

What our customers say:

Feedback from the customer

Differentia Consulting becomes a partner of ETL-Tools.com

Creating QVX files

Using dynamic SQL for ETL transformations

New Year with New Business intelligence software

Have an Idea? Let us know and we will implement it for you.Do not know how to transfom the data, let us know and we will help you.

Working with QVX files

Online tutorial.

Visual Importer ETL version 8 is ready for testing

Upgrading Reposistory

Reporting problems

Annoncing Active Table Editor - Version 5

Upgrading Reposistory

Reporting problems

Have an Idea? Let us know and we will implement it for you.
Do not know how to transfom the data, let us know and we will help you.