Soft82.com » Windows » Developer Tools » Database » Administration » Advanced ETL Processor 5.2.0.11

View screenshots

Advanced ETL Processor Description

Advanced ETL Processor is designed to automate extracting data from ANY database

Advanced ETL Processor is designed to automate extracting data from ANY database, transform, validate it and load into ANY database . Typical usage of it would be extract data from Excel File,Validate Date Formats, Sort data, deduplicate it and load it into Oracle 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 primary key. Some examples of what our customers use this ETL tool for include:

Extract data from:

* Multiple Delimited or Fixed width Text files
* Multiple Excel files + Multiple Excel Spreadsheets
* Multiple MS Access Databases
* Multiple DBF Files
* Any ODBC source
* MS Sql Server
* Multiple Tables

And Load 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
* ODBC Source
* Oracle 7-11G database
* SQL server 7- 2005
* ODBC source

Other tasks are

* Add Records
* Update Records
* Delete Records
* Add New and Update existing Records
* Validate Post codes, Phone numbers,TAX Codes using regular expressions
* Check Date Formats
* Check Numbers
* Split, merge Fields
* Split data and load it into diffrent tables
* Add, replace, delete strings
* Deduplicate Data
* Sort Data
* Group Data
* Summarize Data
* Pivot and UnPivot Data
* Create surrogate keys
* Translate coded values
* Derive a new calculated value
* Run Sql script before and after loading data
* Filter Source Data
* Use Select Statement as a Data Source
* Run transformation script from the command line

If something went wrong Advanced ETL Processor writes detailed message into error log and writes a record into rejected records file.

Advanced ETL Processor Limitations

30 days trial; Nag screen

Advanced ETL Processor Version History

Advanced ETL Processor Download Button For Your Site

If you want to place a Download Button for Advanced ETL Processor on your website just insert the following code:

If you want a Link to this page you can use one of the logos bellow:

Advanced ETL Processor User Reviews

New Administration Software

Azure Cloud Director May 23, 2012 Single Click Deployment To Azure				STDU XMLEditor Portable May 22, 2012 STDU XML Editor is a lightweight editor of XML documents
DBEdit2 May 21, 2012 A database editor, suitable as front-end for all your relational databases				SQLite Manager May 16, 2012 A small program to manage SQLite databases
SqlDbx Personal Edition May 16, 2012 SqlDbx is a fast and easy to use database SQL development IDE for database administrators and...				SQL Cloud Backup Free May 16, 2012 Compress, encrypt and store your SQL Server backups on a local disk
MySQL Editor Software May 8, 2012 Sobolsoft offers a solution for MySQL editing				XBMC Cache Manager May 7, 2012 A Windows Service to manage a shared XBMC MySQL database and shared cache folder
DBF Commander Professional April 27, 2012 Easy-to-use and the most mighty DBF processing tool, including SQL queries				EMS SQL Manager for SQL Server April 19, 2012 Powerful graphical tool for SQL Server administration and development
Advanced ETL Processor April 13, 2012 Advanced ETL Processor is designed to automate extracting data from ANY database				iQ-SQL April 10, 2012 A SQL Query tool for SQL Anywhere
Access To MySQL Converter April 6, 2012 Convert your Access database to a MySQL database				DB Elephant PostgreSQL Converter April 3, 2012 Converts PostgreSQL to dbf, xls, pdf, doc, xml, csv, txt, sql
SQL To MySQL Converter April 2, 2012 Convert your SQL database to a MySQL database				ConnInfo March 22, 2012 Ensure that Project Server administrators maintain user roles and registry settings
Project Server Data Population Tool March 22, 2012 Load large amounts of custom outline codes, resources, projects and tasks				xSQL Object March 13, 2012 Compare and synchronize sql server databases - all objects, SQL Server 2000/2005
Access To PostgreSQL Converter March 13, 2012 Convert your Access database to a PostgreSQL database				Adminer March 12, 2012 A full-featured database management tool written in PHP

Last 7 Days Most Downloaded Administration Products

Navicat for MySQL 80 downloads Navicat - Admin tool for MySQL database management				Advanced ETL Processor 30 downloads Advanced ETL Processor is designed to automate extracting data from ANY database
Navicat Lite 23 downloads A fast, reliable and affordable Database Administration tool				SQLyog Community Edition 23 downloads SQLyog is a fas and compact Win32 Front End for MySQL
SQLite 13 downloads A simple command-line utility				SQLCE Viewer 11 downloads SqlCe Viewer is a database management tool
RazorSQL Portable 7 downloads Query, edit, browse, and manage all databases from one database client				Virtual PC 6 downloads With Microsoft® Virtual PC 2007, you can create and run one or more virtual machines, each with its...
SSIS Configuration Files Editor 5 downloads Configure and edit SQL Services integration services				ContactKeeper 5 downloads ContactKeeper is a free personal information manager to store contact information about your

All Time Most Downloaded Administration Products

Navicat for MySQL 17,552 downloads Navicat - Admin tool for MySQL database management				Advanced ETL Processor 1,035 downloads Advanced ETL Processor is designed to automate extracting data from ANY database
Navicat Lite 4,156 downloads A fast, reliable and affordable Database Administration tool				SQLyog Community Edition 1,505 downloads SQLyog is a fas and compact Win32 Front End for MySQL
SQLite 1,881 downloads A simple command-line utility				SQLCE Viewer 564 downloads SqlCe Viewer is a database management tool
RazorSQL Portable 780 downloads Query, edit, browse, and manage all databases from one database client				Virtual PC 3,575 downloads With Microsoft® Virtual PC 2007, you can create and run one or more virtual machines, each with its...
SSIS Configuration Files Editor 20 downloads Configure and edit SQL Services integration services				ContactKeeper 471 downloads ContactKeeper is a free personal information manager to store contact information about your