Advanced ETL Processor Professional is a Codeless Automation Tool.

Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.

Advanced ETL Processor Professional supports complex enterprise environments including database , file, smtp, pop3 and ftp servers.

Since Advanced ETL Processor Professional is a codeless most of the tasks performed without writing a single line of code

Advanced ETL Processor Professional 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 Pro writes detailed message into the log and writes a record into rejected records file.

Advanced ETL Processor Professional is a codeless Automation tool with which users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis. By combining simple Package actions together, businesses and Fortune 100 companies can automate complicated business processes and everyday tasks.

Major Features:

1. It supports complex enterprise environments including database , file, smtp, pop3 and ftp servers. Since Advanced ETL Processor Professional is a codeless most of the tasks performed without writing a single line of code.
2. Advanced ETL Processor Professional 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.
3. Every package execution is logged,
4. If something went wrong Advanced ETL Processor Pro writes detailed message into the log and writes a record into rejected records file.

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

Whats new in this version: New transformation function "Previous value". Total number of transformation functions now is 37. we would like to thank John Larsson for the most useful feedback

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. The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file..

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

System Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

New features in this version:: Lookup Transformation Object can now pool data from the Database or File Splitter Object supports fixed width format

Advanced ETL Processor extracts data from any database, transforms, validates it and loads into another database automatically. It can help you extract data from an Excel file, validate date formats, sort data, deduplicate it and load it into any database, run stored procedure or SQL script, once loading is completed. Unlike Oracle SQL loader, DTS or SSIS, Advanced ETL Processor can add new and update old records based on the key defined by user.

Advanced ETL Processor 2.3.0 offers a great tool which can be used to move data between any databases automatically. The unique technology called "What You See Is What You Load" use in the software can help you to save a lot of time during testing and design of validation and transformation processes.

Major features

1. The program includes the following functions: extracting data from any database, tranforming, loading into another database automatically.
2. It shows you how the data will be transformed and loaded into the data warehouse or database without actually loading it.
3. At any time, you can press the Preview button and see what the results of an ETL flow would look like.
4. The application can help you to extract data from an Excel file, validate date formats, sort data, duplicate it and load it into the database, run stored procedure or SQL script, once loading is completed.
5. 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.
6. The application can also extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.
7. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Advanced ETL Processor 2.3.0.6 is a powerful software which offers you a professional tool to extract 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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Load, validate, transform, group, sort, deduplicate data without writing a single line of code.It works with any database or file format
2. High performance - hundreds of records per second
3. Comprehensive Error log
4. Rejected records file
5. Low OS Memory consumption

Enhancements: Various bug fixes

Requirements: Win98, WinME, WinXP, WinNT 4.x, Windows2000, Windows2003

Advanced ETL Processor 2.4.0.12 is the right choice if you want to extract 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.

Major Features:

1. 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.
2. The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.
3. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.
4. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Enhancements: Some spelling errors were corrected Minor bug fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

WareSeeker Editor

Advanced ETL Processor Professional is a Codeless Automation Tool.
Users can design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis
By combining simple Package actions together Advanced ETL Processor Professional helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks.
Advanced ETL Processor Professional supports complex enterprise environments including database , file, smtp, pop3 and ftp servers.
Since Advanced ETL Processor Professional is a codeless most of the tasks performed without writing a single line of code
Advanced ETL Processor Professional 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 Pro writes detailed message into the log and writes a record into rejected records file.

System Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

Enhancements: Minor bug fixes

Advanced ETL Processor Enterprise 3.2.0 is designed as a professional program that can allow you to design Data transformations and Sql script add them to the package together with report, file, ftp, email and many more actions and schedule them for execution on regular basis

By combining simple Package actions together Advanced ETL Processor Enterprise helps businesses and Fortune 100 companies to automate complicated business processes and everyday tasks. Advanced ETL Processor Enterprise supports complex enterprise environments including database , file, smtp, pop3 and ftp servers.

Since Advanced ETL Processor Enterprise is a codeless most of the tasks performed without writing a single line of code Advanced ETL Processor Enterprise 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 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.

Major Features:

1. Extracting data from:
   
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases + Multiple Tables
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Multiple Tables
2. And Loading it into:
   
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database
   • SQL server 7-2008
   • Any ODBC compliant database
3. Validation:
   
   • Deal With Dirty Data
   • Validate Post codes, Phone numbers,TAX Codes using regular expressions
   • Validate Date Formats
   • Validate Date and Time
   • Validate Numbers
   • Validate Strings
4. Transformation:
   
   • Split, merge Fields
   • Split data and load it into diffrent tables
   • Add, replace, delete strings
   • Run custom transformations
   • Translate coded values
   • Derive a new calculated value
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases + Multiple Tables
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Multiple Tables
5. Automation:
   
   • Load Data into ANY database
   • Export Data from ANY database
   • FTP Downloads and Uploads
   • Create or Delete directories on FTP server
   • Rename or delete files on FTP server
   • Send Emails with attachments
   • Receive Emails with attachments
   • Save attachmets
   • Compress files
   • Decomress zip files
   • Copy, move, rename, merge, delete files
   • Compare files using MD5, size or creation date
   • Check if file exist
   • Generate Reports
   • Execute Different part of package depending of the day of the week
   • Schedule packages for execution
   • Run bat files or execute any windows application
   • Edit and run SQL Scripts
   • Execute Packages from the command line
   • Add Records
   • Update Records
   • Delete Records
   • Add New and Update existing Records
   • Deduplicate Data
   • Sort Data
   • Group Data
   • Summarize Data
   • Pivot and UnPivot Data
   • Create surrogate keys
   • Run Sql script before and after loading data
   • Filter Source Data
   • Use Select Statement as a Data Source
   WareSeeker Editor
   

Enhancements:

This version works up to 30 percent faster comparing to the previous release More information:

• Full support for unicode
• Support for sql functions and oracle sequences
• It is now possible to pull data directly from Oracle database without ODBC.
• Various bug fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

WareSeeker Editor

Advanced ETL Processor 2.4.0.2 is a useful tool which is designed to provide help with extracting data.

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Extraction:
   
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracle
   • Multiple Tables
   • Full support for ODBC connection strings
2. Validation:
   
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
3. Transformation:
   
   • 38 Transformation Functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • Sorting
   • Grouping
   • Deduplication
   • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
   • Deriving a new calculated value (e.g., sale amount = qty * unit price)
   • Joining together data from multiple fields
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
   • Generating surrogate key values
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customised Transformation
4. Loading:
   
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database (using OCI API)
   • Full support for Oracle Instant Client
   • SQL server 7-2008 (using BCP API)
   • Any ODBC compliant database (Using ODBC API)
   • Full support for ODBC connection strings
5. Oracle
   
   • There are two ways of loading available:
   • Oracle direct path loading
   • Conventional path
6. SQL server
   
   • This software uses the same API as Microsoft DTS service.
7. Also:
   
   • High performance - thousands of records per second
   • Comprehensive Error log
   • Rejected records file
   • Low OS Memory consumption

Enhancements:

• This version works up to 30 percent faster comparing to the previous release
• Full support for unicode
• Support for sql functions and oracle sequences
• It is now possible to pull data directly from Oracle database without ODBC
• Various bug fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003

WareSeeker Editor

Advanced ETL Processor 2.4.0.16 is an effective utility which will allow you to reduce the time and energy you spend where you are managing your database data.

Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Therefore, it is an all-in-one software that will be very useful in your work, no matter what it is related to.

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Data Sources
   • Multiple Delimited or Fixed width Tet files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases + Multiple Tables
   • Multiple DBF Files
   • Any ODBC Compliant Database
   • MS SQL Server
   • Oracle
   • Multiple Source Files
   • Multiple Source Tables
   • SQL Select Statement as a Data source
2. Data Targets
   • Oracle 7-11g database
   • MS Sql Server 7-2008
   • Any ODBC Compliant Database
   • Delimited or Fixed width Tet file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Multiple Data Targets
3. Loading method
   
   • Adding Records
   • Updating Records
   • Deleting Records
   • Adding new and Updating old Records
   • Adding new Records only
   • User definable date formats
   • Transformation Functions
   • Execution of Sql script Before the loading
   • Execution of Sql script After the loading
4. Transformations
   
   • 38 transformation functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
   • Deriving a new calculated value (e.g., sale amount = qty * unit price)
   • Joining together data from multiple fields
   • Generating surrogate key values
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customized Transformation
5. Validation
   
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
6. Additional Transformations
   
   • Sorting
   • Grouping
   • Deduplication
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
7. Other useful features
   
   • Full Support for Unicode
   • Rejected Records File
   • Transformation Log
   • Command Line interface
   • Data Preview
8. Repository
   • MS Access
   • MS Sql Server
   • Oracle 7-11
   • MySql
   • Interbase
   • PostgreSQL
9. Advanced Objects
   
   • Projects
   • Directories
   • ODBC Connections
   • SQL Server Connections
   • Oracle Connections
   • SMTP Connections
   • POP3 Connections
   • Data Transformations
   • Email Templates
   • Sql Scripts
   • Reports Designer
   • Scheduler
   • Execution Logging
   • Packages
   • Backup Repository
   • Restore Repository
10. Package Objects
    
    • Data Transformations
    • Exports
    • Sql Scripts
    • Check Files
    • Compare Files (creation date, file size or MD5)
    • File Operations (copy,delete,rename,etc)
    • External applications
    • Email Notifications
    • Ftp operations Uploads, Downloads, Create Remote directory, Delete File
    • Zip (zip and unzip with password)
    • Pop 3 Email receiver
    • SQL Data Check
    • FTP Operations
    • Backup Repository
    • Pause
    • Check Date
    • Reports
      

Enhancements

• Some spelling errors were corrected
• Minor bug fixes

Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets. Therefore, it is an all-in-one software that will be very useful in your work, no matter what it is related to.

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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables. It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database. If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Extracting data from:
   
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Multiple Tables
2. And Loading it into:
   
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database
   • SQL server 7- 2005
   • Any ODBC compliant database
3. Validation:
   • Deal With Dirty Data
   • Validate Post codes, Phone numbers,TAX Codes using regular expressions
   • Validate Date Formats
   • Validate Date and Time
   • Validate Numbers
   • Validate Strings
4. Transformation:
   • Split, merge Fields
   • Split data and load it into different tables
   • Add, replace, delete strings
   • Run custom transformations
   • Translate coded values
   • Derive a new calculated value
5. Automation:
   • Load Data into ANY database
   • Export Data from ANY database
   • FTP Downloads and Uploads
   • Create or Delete directories on FTP server
   • Rename or delete files on FTP server
   • Send Emails with attachments
   • Receive Emails with attachments
   • Save attachments
   • Compress files
   • Decompress zip files
   • Copy, move, rename, merge, delete files
   • Compare files using MD5, size or creation date
   • Check if file exist
   • Generate Reports
   • Execute Different part of package depending of the day of the week
   • Schedule packages for execution
   • Run bat files or execute any windows application
   • Edit and run SQL Scripts
   • Execute Packages from the command line
   • Add Records
   • Update Records
   • Delete Records
   • Add New and Update existing Records
   • Deduplicate Data
   • Sort Data
   • Group Data
   • Summarize Data
   • Pivot and UnPivot Data
   • Create surrogate keys
   • Run Sql script before and after loading data
   • Filter Source Data
   • Use Select Statement as a Data Source

Enhancements:

• Some spelling errors were corrected
  
• Minor bug fixes

Requirements: Microsoft Windows 98/ME/NT 4.0/2000/XP/2003/Vista

Advanced ETL Processor 2.4.0.11 is an effective software which 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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Data Sources
   
   • Multiple Delimited or Fixed width Tet files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases + Multiple Tables
   • Multiple DBF Files
   • Any ODBC Compliant Database
   • MS SQL Server
   • Oracle
   • Multiple Source Files
   • Multiple Source Tables
   • SQL Select Statement as a Data source
2. Data Targets
   • Oracle 7-11g database
   • MS Sql Server 7-2008
   • Any ODBC Compliant Database
   • Delimited or Fixed width Tet file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Multiple Data Targets
3. Loading method
   
   • Adding Records
   • Updating Records
   • Deleting Records
   • Adding new and Updating old Records
   • Adding new Records only
   • User definable date formats
   • Transformation Functions
   • Execution of Sql script Before the loading
   • Execution of Sql script After the loading
4. Transformations
   • 38 transformation functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
   • Deriving a new calculated value (e.g., sale amount = qty * unit price)
   • Joining together data from multiple fields
   • Generating surrogate key values
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customized Transformation
5. Validation
   
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
6. Additional Transformations
   • Sorting
   • Grouping
   • Deduplication
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
     
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
7. Other useful features
   
   • Full Support for Unicode
   • Rejected Records File
   • Transformation Log
   • Command Line interface
   • Data Preview
8. Repository
   • MS Access
   • MS Sql Server
   • Oracle 7-11
   • MySql
   • Interbase
   • PostgreSQL
9. Advanced Objects
   
   • Projects
   • Directories
   • ODBC Connections
   • SQL Server Connections
   • Oracle Connections
   • SMTP Connections
   • POP3 Connections
   • Data Transformations
   • Email Templates
   • Sql Scripts
   • Reports Designer
   • Scheduler
   • Execution Logging
   • Packages
   • Backup Repository
   • Restore Repository
10. Package Objects
    
    • Data Transformations
    • Exports
    • Sql Scripts
    • Check Files
    • Compare Files (creation date, file size or MD5)
    • File Operations (copy,delete,rename,etc)
    • Eternal applications
    • Email Notifications
    • Ftp operations Uploads, Downloads, Create Remote directory, Delete File
    • Zip (zip and unzip with password)
    • Pop 3 Email receiver
    • SQL Data Check
    • FTP Operations
    • Backup Repository
    • Pause
    • Check Date
      
    • Reports
11. Execution AgentRuns as Windows service

Advanced ETL Processor Professional 3.1.4 is a smart program which can extract 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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Extraction:
   
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracle
   • Multiple Tables
   • Full support for ODBC connection strings
2. Validation:
   
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
3. Transformation:
   
   • 38 Transformation Functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • Sorting
   • Grouping
   • Deduplication
   • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
   • Deriving a new calculated value (e.g., sale amount = qty * unit price)
   • Joining together data from multiple fields
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
   • Generating surrogate key values
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customised Transformation
4. Loading:
   
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database (using OCI API)
   • Full support for Oracle Instant Client
   • SQL server 7-2008 (using BCP API)
   • Any ODBC compliant database (Using ODBC API)
   • Full support for ODBC connection strings
5. Oracle
   
   • There are two ways of loading available:
   • Oracle direct path loading
   • Conventional path
6. SQL server
   This software uses the same API as Microsoft DTS service.
   
7. Also:
   
   • High performance - hundreds of records per second
   • Comprehensive Error log
   • Rejected records file
   • Low OS Memory requirements

Requirements: Microsoft Windows 98/ME/NT 4.0/2000/XP/2003/Vista

WareSeeker Editor

Advanced ETL Processor 2.3.0.6 is the best solution if you want to 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.

The program can extract data from multiple delimited or fixed width text files, multiple Excel files and multiple Excel spreadsheets, multiple MS Access databases, multiple DBF files, any ODBC compliant database, MS SQL Server or multiple tables.

It can load data to multiple data targets, delimited or fixed width Text file, MS Access database, Microsoft Excel file, DBF file, Oracle 7-11g database, SQL server 7- 2005, and any ODBC compliant database.

If data format is incorrect, Advanced ETL Processor writes a detailed message into the error log and writes a record into rejected records file.

Major Features:

1. Extraction:
   
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracle
   • Multiple Tables
   • Full support for ODBC connection strings
2. Validation:
   
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
3. Transformation:
   
   • 38 Transformation Functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • Sorting
   • Grouping
   • Deduplication
   • Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the warehouse stores M for male and F for female)
   • Deriving a new calculated value (e.g., sale amount = qty * unit price)
   • Joining together data from multiple fields
   • Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
   • Generating surrogate key values
   • Transposing or pivoting (turning multiple columns into multiple rows or vice versa)
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customised Transformation
4. Loading:
   
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database (using OCI API)
   • Full support for Oracle Instant Client
   • SQL server 7-2008 (using BCP API)
   • Any ODBC compliant database (Using ODBC API)
   • Full support for ODBC connection strings
5. Oracle: There are two ways of loading available:
   
   • Oracle direct path loading
   • Conventional path
6. SQL server
   This software uses the same API as Microsoft DTS service.
   
7. Also:
   
   • High performance - thousands of records per second
   • Comprehensive Error log
   • Rejected records file
   • Low OS Memory consumption

Enhancements: Various bug fixies

Requirements: Microsoft Windows 98/ME/NT 4.0/2000/XP/2003/Vista

WareSeeker Editor

Major Features:

1. Extraction:
   • Multiple Delimited or Fixed width Text files
   • Multiple Excel files + Multiple Excel Spreadsheets
   • Multiple MS Access Databases
   • Multiple DBF Files
   • Any ODBC compliant database
   • MS Sql Server
   • Oracle
   • Multiple Tables
   • Full support for ODBC connection strings
2. Validation:
   • 190 Validation Functions
   • String Validation
   • Number Validation
   • Date Validation
   • Time Validation
   • Validation Against list of values
   • Regular Expressions: Post codes, Phone Numbers, VAT Numbers ETC
3. Transformation:
   • 38 Transformation Functions
   • String Transformation
   • Number Transformation
   • Date Transformation
   • Multiple Date Formats
   • 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 (turning multiple columns into multiple rows or vice versa)
   • Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)
   • Customised Transformation
4. Loading:
   • Multiple Data Targets
   • Sql scripts execution before and after loading
   • Delimited or Fixed width Text file
   • MS Access Database
   • Microsoft Excel File
   • DBF File
   • Oracle 7-11g database (using OCI API)
   • Full support for Oracle Instant Client
   • SQL server 7-2008 (using BCP API)
   • Any ODBC compliant database (Using ODBC API)
   • Full support for ODBC connection strings
5. Oracle: There are two ways of loading available:
   • Oracle direct path loading
   • Conventional path
6. SQL server: This software uses the same API as Microsoft DTS service.
7. Others:
   • High performance - thousands of records per second
   • Comprehensive Error log
   • Rejected records file
   • Low OS Memory consumption

Enhancements:

• This version works up to 30 percent faster comparing to the previous release
• Full support for unicode
• Support for sql functions and oracle sequences
• It is now possible to pull data directly from Oracle database without ODBC.
• Various bug fixes

Requirements: Win98,WinME,WinXP,WinNT 4.x,Windows2000,Windows2003