|
|
|
|
|
Execution-MiH ENCYCLOPEDIA →
Vendor- IT Tool Domain →
SECTION - Data Management Tools →
|
CHAPTER -
| Data Integration Tools |
|
DI tools will have sub-domains like ETL, Data Migration and Data Synchronization. These features will be supported by a robust and industrial strength processing and services-based architecture. Data Integration is not only a BI subject, but it touches the entire systems and IT landscape of an organization. Therefore the DI tools will need to address the OLTP as well as BI needs.
|
|
|
|
| |
Topics
|
|
Design & Analysis support and Wizards
|
Data Integration tools needs to have wizards should help you in accessing source systems, importing data, creating DI business rules, identifying and repairing quality issues, ETL design, identifying access structures etc...It should help you to analyze data lineage and do impact analysis on changes in structures of participating systems.
|
| |
|
Connectivity and Computing Support
|
Data Integration tools need industrial strength connectivity and computing capabilities
|
| |
|
Data Quality through Data Integration Tools
|
Data quality is core to data integration. Data Integration tools should be able to have embedded data quality controls in batch as well as real-time processes. Data Quality should include extensive data searching, matching, cleansing and augmentation capabilities. This can be combined with extensive reporting and exception handling features.
|
| |
|
Extraction, Transformation and Loading
|
ETL capability of a DI includes transformation routines library, wizards for creating ETL routines, programmer friendly language to create more complex routines, and ability to generate detailed logs and reports.
|
| |
|
Data Integration Metadata Management
|
Metadata management capabilities include capturing of metadata while designing and during operations, metadata creation wizards, wizards for importing & exporting metadata, supporting central and distributed metadata architecture. More details can be found in the Metadata tool evaluation.
|
| |
|
Data Integration- Migration, Synchronization, Federation
|
Migration, Synchronization and Data Federation are key elements of what data integration does. The DI capabilities includes metadata driven operation, any-to-any transformations & integration, using data-exchange standards, data cleansing done real-time, data federation across multiple sources, query optimization etc...
|
| |
|
Collaboration and Administration Support
|
This feature-set includes multi-user design environment, distributing data integration tasks, version management, central library, common administration console etc...
|
| |
|
|
|
|
|
|
|
All Chapters in "Data Management Tools." Section
|
|
|
|
| |
| |
| Back |
