Advanced ETL Processor

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. A unique technology called "What You See Is What You Load" saves a lot of time during testing and design of validation and transformation processes. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

Advanced ETL Processor can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into the database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, BCP, DTS or SSIS, Advanced ETL Processor can also add new and update old records based on the key defined by user.

Advanced ETL Processor works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

Another benefit of using Advanced ETL Processor its unique ability to load data from multiple files or even tables using mask

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Features

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.

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.
- 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.