NEW ADVANCED ETL PROCESSOR PROFESSIONAL:NEXT GENRATION OF ETL TOOLS FOR FAST DATA INTEGRATION

DB Software Laboratory announces “Advanced ETL Processor Professional 3.2.0”

[USPRwire, Mon Aug 23 2010] DB Software Laboratory, the world's leading innovator in data integration and management technologies, today announced the release of Advanced ETL Processor, the latest version of the Data transformation software for the Windows platforms. The application combines ETL and design capabilities all within one environment, significantly simplifying the design of complex data transformations.

Advanced ETL Processor is a comprehensive ETL tool for the high speed transfer of data from various data sources such as text files, Excel files, MS Access Databases, DBF Files or any ODBC source databases into Oracle 7-11g, MS SQL Server 7-2008, text file, Excel file, MS Access Database, DBF File or any ODBC database. Along with simple record transfer Advanced ETL Processor allows for complex data validations and transformations which can be streamlined by calculations including data formatting, values splitting and joining, sorting, deduplication etc. Unlike MS DTS, Advanced ETL Processor performs loading of multiple files and tables.

Advanced ETL Processor features a well-organized, straightforward program interface and simplified navigation, requiring no specialized programming skills in database deployment. By completely automating all stages of data processing, the application eliminates the need for any regular intervention and upkeep. Thanks to its usability and inexpensive pricing, “Advanced ETL Processor” has become the number one choice of ETL software for businesses and government organizations.

Below are some of the most significant “Advanced ETL Processor 3.2.0” features:
• Multiple source files and Tables
• 190 Validation Functions
• 37 Transformation Functions
• String Validation and Transformation
• Number Validation and Transformation
• Date Validation and Transformation
• Time Validation and Transformation
• Validation Against list of values
• Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
• Sorting
• Grouping
• Deduplication
• Translating coded values
• Deriving a new calculated value
• Joining together data from multiple fields
• Summarizing multiple rows of data
• Generating surrogate key values
• Transposing or pivoting
• Splitting a column into multiple columns
• Customized Transformation
• Multiple Data Targets
• Sql scripts execution before and after loading


Product page URL: http://www.dbsoftlab.com
Direct download link:
http://www.dbsoftlab.com/index.php/Download-document/30-Advanced-ETL-Processor-Pro.html