Windows Data Transformation Software combines ETL and design capabilities.
Share:
Press Release Summary:
Advanced ETL Processor v2.4.3 allows for high-speed transfer of data from sources such as text files, Excel files, MS Access Databases, DBF files, or any ODBC source databases into Oracle v7-10, MS SQL Server v7-2005, text or Excel file, MS Access Database, DBF File, or any ODBC database. It performs loading of multiple files and tables and allows for complex data validations and transformations. No specialized programming skills are required and program automates all stages of data processing.
Original Press Release:
New Advanced ETL Processor
Next Generation of ETL Tools for Fast Data Integration
DB Software Laboratory announces "Advanced ETL Processor 2.4.3"
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 2.4.3 is the product of several years of development based on our own data warehousing experience and customers' feedback. It is one of the most complete Windows-based ETL systems on the market today," said Mike Renwick, head of marketing department at DB Software Laboratory. "It is directly in line with our vision for data integration optimization, already helping hundreds of our clients improve their integration projects so that they can be delivered on time, within budget and with the maximum business value."
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-10, MS SQL Server 7-2005, 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 2.4.3" features:
Multiple source files and Tables
190 Validation Functions
48 Transformation Functions
String Validation and Transformation
Number Validation and Transformation
Date Validation and Transformation
Time Validation and Transformation
Validation Against list of values
XML
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
