Advanced ETL Processor 2.1.1
Advanced ETL Processor description
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)
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)
Other software by DB Software Laboratory
- Visual Importer 3.0.60-Imports data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- Visual Importer Professional 6.2.38-Imports data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- Active Business Intelligence Portal 3.1.6-Active BI Portal creates Web Reports and Web forms
- DEWizardX 3.2.7-ActiveX to transfer data between various databases/datasources
- Data Exchange Wizard 3.2.7-Transfers data between various databases/datasources
[More
software from DB Software Laboratory]
related software to Advanced ETL Processor
- Data Exchange Wizard Transfers data between various databases/datasources
- DEWizardX ActiveX to transfer data between various databases/datasources
- Visual Importer Enterprise Imports data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- Visual Importer Imports data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- Visual Importer Professional Imports data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- VImpX Loads data into Oracle,SQL Server,ODBC, from flat files, cross tables or ODBC.
- Waha! Transformer Lite Transform the data to fit your needs and load it into your database.
- Database Viewer Plus View and Synchronize Ms Access,xls, Oracle,any ODBC enabaled database with palm.
Most popular software
Copyright © 2001-2008 Softforall.com . All Rights Reserved .
