|
Etl - A Key and Effective Data Integration B2b Strategy
By
Denish Gupt
Article Word Count: 267 [View Summary] Comments (0) |
|
Etl is powerful middleware applications that automates and execute vital integration processes particularly for creating and populating data marts from a range of internal or external database sources. Data conversion is an another important feature of ETL tools which solve any to any conversion like XML to CSV, Any Database to XML,XML to EDI, HIPAA to XML, HL7 to XML etc.
The basic objective etl tools is extracting, transforming and loading of records from database source to another and accelerate enterprises data integration process fast. Here are the 3 main components of Etl Tools are:
- Central Repository : Where all the business rules and mapping objects are saved
- Design Studio : Offers wizard-driven, graphical ability to document business rules as they relate to validations, mapping
- Run-time Execution Engine:Where the mapping rules and flow transactions are executed on incoming files and messages
- Data Mapper : Should be web-based, graphical design tool that makes it really easy to specify conversion, validation and cleansing rules to process the incoming records.
- Data Schemas and Transport : Support processing of data in any format whether it is Text or CSV, XML, any Databases (such as Oracle, MySQL, SQL Suite, DB2, Sybase), EDI, HIPAA, ACORD AL3, any Fixed-Length file format, or any other format currently running processes can be monitored
|
Author has more than 5 years of experience in ETL Software & data mapping technology currently working for Adeptia. For more information about ETL Tools please download free. Article Source: http://EzineArticles.com/?expert=Denish_Gupt |
|
This article has been viewed 14 time(s).
Article Submitted On: November 05, 2009
-
MLA Style Citation:
Gupt, Denish "Etl - A Key and Effective Data Integration B2b Strategy." Etl - A Key and Effective Data Integration B2b Strategy. 5 Nov. 2009 EzineArticles.com. 24 Nov. 2009 <http://ezinearticles.com/?Etl---A-Key-and-Effective-Data-Integration-B2b-Strategy&id=3212461>.
-
APA Style Citation:
Gupt, D. (2009, November 5). Etl - A Key and Effective Data Integration B2b Strategy. Retrieved November 24, 2009, from http://ezinearticles.com/?Etl---A-Key-and-Effective-Data-Integration-B2b-Strategy&id=3212461
-
Chicago Style Citation:
Gupt, Denish "Etl - A Key and Effective Data Integration B2b Strategy." Etl - A Key and Effective Data Integration B2b Strategy EzineArticles.com. http://ezinearticles.com/?Etl---A-Key-and-Effective-Data-Integration-B2b-Strategy&id=3212461