Format Conversion, ETL
ETL:
Extraction, Transformation and Loading. Activities required to populate data warehouses and OLAP applications with clean, consistent, integrated and probably summarized data.
From: www.olapreport.com/glossary.htm
Extract/Transform/Load: This is the process of extracting data from their operational data sources or external data sources, transforming the data which includes cleansing, aggregation, summarization, integration, as well as basic transformation and loading the data into some form of the data warehouse (ODS, enterprise data warehouse, data mart). ETL can also refer to the vendor software that performs these processes.
From : it.csumb.edu/departments/data/glossary.html
DataMonkey
DataMonkey is a powerful and flexible windows data translation and conversion application.
Features:
- Input from ASCII file, ODBC database, SQL Query or user defined ActiveX object
- Output to ASCII file, ODBC database, Screen dump, XML File or user defined ActiveX object
- User extensible (via ActiveX objects) set of commands to manipulate data (requires code to be written)
- Automatic import of ODBC tables and records to define Input Schemas or Output Schemas
- Step by step wizard to help you create an import format
- Any import project can be saved as a template to the wizard to facilitate creation of similar import projects
- A single Input Schema can map to multiple output Output Schemas
- All projects and schemas are in readable plain-text format
- Extensive error reporting to help you understand where and why something didn't work
- Easy to use interface on top of a powerful and flexible parser
- Open Source
visit
DataMonkey
DataMonkey was visited : 69 times
Loading .....