Advanced ETL Processor
| | Advanced ETL Processor is a Codeless ETL tool
It can load, validate, transform, group, sort and deduplicate data without writing a single line of code. It works with ANY database or file format, including unicode
Download a Free Trial or get the latest version today from only $340. Read Advanced ETL Processor FAQ , Watch Online Flash Demo , Read Product Documentation (PDF). | What can Advanced ETL Processor Do? | 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 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 primary key. Some examples of what our customers use this ETL tool for include:
| | Extract data from:
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
- Oracle 7-11g database
- SQL server 7- 2005
- Any ODBC compliant database
Save time by automating Everyday tasks: | | | | In the event of an error, the Advanced ETL Processor generates a detailed and explanatory report, giving the user ultimate control of accuracy of the database. | | Online Flash Demos and Tutorials | | | | Key Facts | | Extraction:
Validation: Transformation: Loading: Oracle There are two ways of loading available: - Oracle direct path loading
- Conventional path
More Information... SQL server This software uses the same API as Microsoft DTS service. Also: - High performance - thousands of records per second
- Comprehensive Error log
- Rejected records file
- Low OS Memory consumption
Advanced ETL Processor runs on Microsoft Windows 98/ME/NT 4.0/2000/XP/2003/Vista | Advanced ETL Processor Screenshots | | Click on thumbnail to see the screenshot
|
|