Advanced ETL Processor 2.1.1

Publisher:	DB Software Laboratory	Date Added:	2007-12-28
Rating:		Downloads:	81
File Size:	3.23MB	Price:	$300 USD
License:	Shareware	Screenshot:	Screenshot

Free Trial

Advanced ETL is a business intelligence tool that provides solution for Extracting, Validating, Transforming and Loading data between different data sources and targets.

Extraction:

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

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

Transformation:

* 36 Transformation Functions
* String Transformation
* Number Transformation
* Date Transformation
* 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

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
* ODBC source (Using ODBC API)
* Oracle 7-10G database (using OCI API)
* SQL server 7- 2005 (using BCP API)
* ODBC source (Using ODBC API)

HOT TAG: using odbc api, source using odbc, odbc source using, fixed width text, odbc source, width text, using odbc, source using, odbc api, multiple rows, multiple excel,

---

Relate Software Downloads

001Micron Outlook Password Viewer Tool - Outlook express password exposer software unmask masked and misplaced passwords

@promt Professional Translator En-Ge - @promt Professional 7.8 - powerful easy translation software for business users.

@promt Professional Translator En-Sp - @promt Professional 7.8 - powerful easy translation software for business users

ABC Colouring Book - Part I - Animals - Nice colouring book for 2-4 years kids. 50 animals pictures inside.

Action Ball 2 - Can you handle the hottest brick-busting action you ve ever seen?

Advanced ETL Processor - business intelligence tool that provides solution for Extracting and Validating

Arcade Classic Arcade Pack - Play Asteroids, PacMan, Frogger, Hexxagon, Pong, Snake, Space Invaders, Tetris.

Atrise Foggy Autumn - High quality 1280*1024 photo wallpaper selection tool

Auction Inquisitor(TM) - Scan auctions for common signs of fraud before bidding.

Auktionatrix - Klick mich! Ich mach s ... UMSONST! Vollständige Verwaltung von Auktionen.