Advanced ETL Processor - Overview

Advanced ETL Processor is a Code-less ETL tool - only $340

Advanced ETL Processor is a powerful data integration application with support for integrating data with virtually any formats including Flat files, Excel, MS Access, DBF, FoxPro, ODBC, JDBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, POP3 + SSL, IMAP4 + SSL, SMTP + SSL, SalesForce, BrightPearl, Windows Event Log, File System, XML, QVX and QVD files. Advanced ETL Processor is an ideal product for transforming data in any enterprise. All this can be achieved without writing a single line of code.

   

Complex Data Integration made simple

The data integration process can often seem overwhelming, because of the vast number of large-scale, complex, and costly enterprise integration applications available on the market. Advanced ETL Processor gives our customers data integration capabilities built into a straightforward graphical user interface. At any stage user can press the "Magic Button" and see the result of transformation without actually loading the data.

Data integration in Advanced ETL Processor

Advanced ETL Processor allows you to easily associate target and source data structures using drag and drop functionality. A vast built-in library of advanced data processing filters and functions is available plus you can write your own transformations using powerful data transformation language in more complex data integration scenarios.

Integrating Data from/into Multiple datasources

Advanced ETL Processor lets you easily integrate data from multiple datasources or split data from one datasoure into many. Multiple datasource can be specified through support for wildcard characters (e.g., ? or *) and it can be applied to the files/tables or sheets.
Advanced ETL Processor also allows you to use calculations in file names as parameters in your data integration projects. for example you can use it to load data from today's files only.

mt_ignore

Maps once use everywhere

Advanced ETL Processor introduces new concept called "Universal Data Reader and Writer".

Whatever you are working with an Oracle, text file or Access database, Advanced ETL Processor transforms data based on data definition regardless of the underlying content. This means that you can re-use your data integration mappings again and again as your business data changes.

Simply right click on the data reader or data writer and choose Properties to access connection settings dialog to change your data source and, consequently, the data source or target of your data integration project.

Data Manipulation

Data integration projects often require a certain amount of data manipulation - the insertion of data processing functions, filters, constants, or other operators to make the data consumable by the target system.

Advanced ETL Processor provides intuitive features that enable you to perform complex data validations and transformation. These include 191 filters and conditions, 52 data transformation functions, powerful data transformation language and much more.

Functions, filters, and constants can be accessed in the Advanced ETL Processor via drop down tool bar. All functions are grouped into categories for example: String, Number, Date, Time validation functions, regular expressions, lookups and data transformation functions.

Chained Transformations

Chained transformations enable you to create complex mappings in which the output of one mapping becomes the input of another. Some complex transformation are very hard to understand, this powerful feature allows you to design and debug complex transformations one small step at the time. Each chained component becomes a modular entity in an interdependent transformation sequence, allowing for conversions to be made on-the-fly.
Chained transformations can be created using any number of mapping components connected to a one or several data writer components.

Chained Transformations example

By using native API for Oracle(OCI), MS Sql Server(BCP), ODBC, MySQL, PostgreSQL, Interbase/Firebird Andvanced ETL Processor gives the users great performance thousands of records per second.

In the event of an error, Advanced ETL Processor generates a detailed and explanatory report, giving the user ultimate control of accuracy of the database.

Recommended product for desktop users who require advanced data transformation and validation

Advanced ETL Processor Screenshots

Click on thumbnail to see the screenshot

Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots
Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots
Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots Advanced ETL Processor Screenshots

Advanced ETL Processor runs on Microsoft Windows XP/2003/2008/2012/Vista/Win7/Win8

Visit Support Forum Learn More Download Buy It
We found Advanced ETL Processor remarkably easy to use and DBSL support team provides outstanding value and service.

David Thomson
Marketing Manager

Our customers

BP

BBC

HSBC

Orange

CAT

SEPA
emc
NHS
Australian Rugby Union
xerox
Databases we work with