|
Category: Internet/Servers/Database-Utils
Advanced ETL Processor 2.2.1
Download: http://www.dbsoftlab.com/dmdocuments/AdvancedETL.zip
Operation System: Windows All
License:
Size: 6.26 MB
Date: 2008-03-19 02:10:12
Advanced ETL Processor descriptionThis application 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.
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)
Limitations:
· 30 days trial period
· Nag screen
crackzplanet.com/get_269594_Advanced.ETL.Processor.v2.2.1.0-iNViSiBLE_crack.html
|
|
| |
