DB Software Laboratory

Transform all your data today

Easy to use, fast and powerful ETL tools

Work with: Text, XML, Excel, Access, DBF, Foxpro, Clarion, Paradox, ODBC, BDE, OLE DB, MS Sql Server, Oracle, MySql, MariaDB, PostgreSQL, Greenplum, Firebird, Interbase, SQLite, POP3, IMAP4, SMTP, HL7, HTTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl, Slemma, Tableau and QlikView.

Built-in scheduler, business rules designer, package designer, report designer, data browser. Powerful data transformation language, regular expressions and more...

Advanced ETL Processor is a Code-less ETL tool

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.

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

PRODUCTS

Advance ETL Processor Standard

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database completely automatically. At any time, you can press the "Preview" button and see what the results of an ETL flow would look like.

Advance ETL Processor Standard – Single License

Price:280.00 EUR
secure.avangate.com/order/checkout.php

Advance ETL Processor Professional – Single License

Advanced ETL Processor Pro transfers data from ANY Database into ANY Database or file. Full automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ETL Task scheduler and comprehensive logging. Works directly with Excel, MS Access, DBF and Text files, Oracle, MS SQL Server, Interbase/Firebird, MySQL, PostgreSQL or any ODBC compliant database.

Price:380.00 EUR
secure.avangate.com/order/checkout.php