Advanced ETL Processor v.3.8.1.7

Advertisement
Advertisement
Editor's Review
Integrate Data Very Easily With The Help Of Advanced ETL Processor
 
What Advanced ETL Processor Does?
One of the best software that will help to automatically extract, validate, transform data from any database and load it into any other database is Advanced ETL Processor. The main usage of the software will be to extract data from excel files and then validate the date formats. Then the software will sort out the, de-duplicate it and will finally load it into a database. After the loading is complete, you will be able to run the stored Sql script and the Advanced ETL Processor tool will provides you with the option of adding new records or even update the old records depending on the primary key. Advanced ETL Processor is an effective data consolidation application program which will endorse the integrating data with just about any data format including Flat files, MS Access, DBF, Excel,  Oracle, MySql, FoxPro, PostgreSQL, Firebird, Interbase, POP3 + SSL and so on. Advanced ETL Processor is a perfect product for metamorphosing information in any endeavor. Everything can be easily and quickly accomplished without composing a single channel of code. A few of the basic functions that you will be able to undertake employing this software package are: Load data from files into blob and multiple fields, perform difficult and multifaceted data substantiation and alteration, export the data from the database, obtain, process as well as hurl e-mails, arrange and de duplicate data as well as load the data into the database from various file formats that are available today.

Exciting Features
The data consolidation action can oftentimes appear overpowering, because of the huge amount of mass, complicated, and high-priced enterprise integrating application program available in the market. Advanced ETL Processor offers its clients data integration potentialities constructed into a direct graphical user interface. At any level user may press the "Magic Button" and check the outcome of shift without really loading the information. Advanced ETL Processor permits you to easily incorporate data from manifold data sources or divide data from one data source into numerous ones. Multiple data source could be defined by back up for wildcard types and it can be enforced to the files or tables or sheets. Advanced ETL Processor also grants you to employ computations in file names as parameters in your information consolidation projects. For instance you will be able to use it to load information from today's files alone. Whatever you are influencing with an Oracle, text file or Access database, Advanced ETL Processor metamorphoses information based on data definition irrespective of the inexplicit content. This entails that you will be able to reprocess your information integration maps over and over again as your business information alters. Just right mouse click on the information proofreader or information writer and pick out Properties to get at connection settings dialog to convert your information source and, accordingly, the data source or target area of your information integration project. Advanced ETL Processor permits you to easily connect target and source information constructions employing drag and drop functionality. A huge inbuilt library of boosted data processing filters and procedures is accessible addition you will be able to compose your own translations utilizing powerful information transformation language in harder data integration scenarios.

Information integrating tasks a great deal demand a definite measure of data handling - the intromission of information action procedures, filters, constants, or different manipulators to establish the information expendable by the target arrangement. Advanced ETL Processor software allows for illogical features that enable you to execute composite information substantiations and transmutation. The software package has 191 filters and stipulations, fifty-two information transformation uses, mighty information transformation language and a great deal more. Functions, filters, and constants can be got at in the Advanced ETL Processor thru drop down tool bar. Every function is grouped into families like String, Time substantiation procedures; number, steady expressions, Date, and information transformation functions. Chained transformations enable you to produce convoluted maps in which the end product of one mapping converts to become the input signal of another. A few complex transformations are precisely difficult to interpret, this powerful feature lets you to contrive and debug complicated transformations one little step at the time. Each chained ingredient converts into a standard entity in a mutually beneficial transformation chronological sequence, providing changeovers to be arrived at on-the-fly. Chained transformations can be produced employing any amount of map ingredients attached to one or many data writer components.

Pros
• Saves a lot of your time during designing and testing of validation and transformation processes.
• Capable of transforming the data into database directly without loading it.  
• Easy to set up and maintain and is very simple to use.
• Help and the support feature is really excellent.

Cons
Mastering the Advanced ETL Processor tool for a novice user is not that easy and you will also be required to scan through a lot of the packages in order to find the best features of the software.

Final Verdict
If you need to manage different databases very easily and effectively, then Advanced ETL Processor software will be the best featured loaded and functional tool that will help you in interpreting the data in plenty of ways and with any of the file formats that is available today.


Publisher's Description

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, SQLite, QVD, QVX, Salesforce, Brightpearl,RSS Google Spreadsheets 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.

Move data between any database automatically. 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.

etl, powerful etl tool, oracle, ms sql server, bcp, sql loader, odbc, data transformation, extract transform load, business automation

 
  • Advanced ETL Processor
  • 3.8.1.7
  • 26 Aug 15
  • DB Software Laboratory
  • WinXP, Windows2000, Windows2003, Windows Vista, Win98, WinME, WinNT 4.x
  •  
  • Shareware
  • 8.32 Mb
  • 1481
  • $340.00
 
 
Latest Versions History
Version Date Released Release Notes
3.7.0.9 06.05.2013 - Addressed problems with "If in List" Function
3.7.0.7 19.04.2013 + Addressed problems with updating Oracle blob fields + Addressed some grouper issues + Undo/Redo Functionality was improved + Documentation update
3.7.0.3 04.04.2013 + IF Functions were introduced + Total number of functions now 500+ + Comments were added to Literal function + Various bug fixes and interface improvements + Documentation update - Addressed some regular expressions bugs
3.6.3.3 02.03.2013 + Added align left, align top, align right, and align bottom buttons + Dedupicator, Lookup and InLinst functions are up to 20 percent faster + Ability to link output fields was introduced + Hints were added to Lookup object + Better object selection for mappings - Various bug fixes
3.6.2.8 13.02.2013 + Added Keep Characters Function + Added Epoch to Date Function + Added Date to Epoch Function + Interface improvements + Documentation update - Various bug fixes
3.6.2.0 10.01.2013 + Support for BDE and Paradox was introduced - Various bug fixes
3.5.1.3 14.10.2012 + Support for Stored procedures as data targets was introduced for OleDB connection - Various bug fixes
3.5.1.0 14.09.2012 + Added new object Log which can be used to analyze data quality issues + Reader Parameter Object was renamed to Metadata object + Ability to extract package name, OS user name, computer name, transformation name and Application name was introduced + Documentation Update - Various bug fixes
3.4.4.3 21.07.2012 - Various bug fixes
3.4.4.0 04.07.2012 + Massive performance improvement up to 10+ times for some data sources/targets - Various bug fixes
3.4.1.0 29.04.2012 + Support for loading data from RSS, Google spread sheets and windows event logs was introduced + Dynamic Excel sheet names + 10+ performance increase when working with Excel files - Various bug fixes
3.4.0.3 06.04.2012 + New arithmetical functions were added Add,Subtract,Divide,Multiply,Max and Min + Documentation update
3.3.1.0 20.02.2012 + Read and write QlikView QVX files + Support for QVX_QV_DUAL fields type was introduced - Addressed some issues related to working with MS Sql Server Compact edition - Various bug fixes
3.3.0.9 09.01.2012 + After and Before transformation functions + Added support for CRC16,CRC24,CRC32,Adler32,CRC64,eDonkey,eMule,MD4,MD5,RIPEMD160,SHA1,SHA224,SHA256,SHA384,SHA512,Whirlpool checksums + Documentation update - Various AV fixes - Addressed problem with arranging objects
3.3.0.0 22.10.2011 + On win64 can now access 3 gb of memory + Support for themes + Documentation update - Text writer unicode fixes - Various bug fixes
3.2.6.2 04.09.2011 Added Support for XSLT transformations Added Get Variable, XML XSLT transformation, Validate XML function Interface Update Various bug fixes
3.2.5.6 26.07.2011 Improved support for spaces in table names and SQL reserved words Added clear log check box to transformation progress dialog Added open open execution log button Added Clone Row, Base64 Encode, Base64 Decode, GUID, Random transformation functions Various bug fixes
3.2.4.1 26.05.2011 Transformation editor Fixes Various Bug Fixes
3.2.3.6 12.03.2011 Fixed number of problems related to working with InList and Lookup functions Fixed number of problems related to working with uniqueidentifierfileds in sql server
 
 

Review Advanced ETL Processor

  • captcha
 

Other software of DB Software Laboratory
  • Active Business Intelligence Portal  v.3.2.0Active BI Portal is business intelligence software that provides an integrated solution for designing and deploying reports and web forms over the internet and intranet. Active BI Portal works with all major commercial and open source databases.
  • Advanced ETL Processor Enterprise  v.5.8.2.6Build Complex Data warehouses and Automate Entire Business Processes, Transfer data from ANY Database into ANY Database or file,Use FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, Task scheduler and comprehensive logging.
  • Advanced ETL Processor Pro  v.4.2.4.3Advanced ETL Processor Professional is a Codeless Automation Tool. It transfers from any database into any database or file. Complete automation of business processes such as FTP, Email: POP3 and SMTP, File operations, SQL scripts, Zip and Unzip, ...

New Database Management software
  • Excel Add-in for Oracle  v.2.5Devart Excel Add-in for Oracle allows you to use powerful Excel capabilities for processing and analysis of data from Oracle database, editing external data as usual excel spreadsheets and saving data changes back to the Oracle database ...
  • Advanced Data Generator  v.4.0.2.29Comprehensive test data generator tool with data library to generate life like data. Ability to generate complex data for volume testing, demo data for presentations or performance testing.
  • Aglowsoft SQL Query Tools  v.10.0Extract database schemas, build and run SQL queries, visualize data relationships in your databases, all with a single software package.