Advanced ETL Processor Enterprise 5.7.2.2

Build Complex Data warehouses and Automate Entire Business Processes

Transfer Data 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, ETL Task scheduler and comprehensive logging. Work with: Text, XML, Excel, Access, DBF, Foxpro, ODBC, OLE DB, MS Sql Server, Oracle, MySql, PostgreSQL, Firebird, Interbase, SQLite, POP3, SMTP, File System, FTP, SSL, Unicode, RSS, Windows Event Log, Google Spreadsheets, SalesForce, BrightPearl and QlikView.

Since Advanced ETL Processor Enterprise by DB Software Laboratory is a codeless most of the tasks performed without writing a single line of code

Advanced ETL Processor Enterprise 5.7.2.2 is designed to automate everyday routine tasks. Typical usage of it would be extract data from 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 send email to the administrator.

Every package execution is logged, If something went wrong Advanced ETL Processor Enterprise [advancedetlprocessorenterprise5.7.2.2.exe] writes detailed message into the log and writes a record into rejected records file.

The Enterprise version includes execution agent, which can be run as a Windows service.
For immediate release
December 20, 2008
Company: DB Software Laboratory
NEW Advanced ETL Processor Enterprise - 21.08MB:
NEXT GENERATION OF ETL TOOLS FOR FAST DATA INTEGRATION
DB Software Laboratory announces “ Advanced ETL Processor Enterprise 5.7.2.2 3. 2. 0”
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