Meta Integration® Works (MIW) Desktop Toolset
"Metadata Management" Solution
Tutorial
Metadata Management Tutorial
The need for more sophisticated and precise metadata management is a growing concern
for most large organizations. Nearly all components that comprise modern information
technology, from CASE tools, ETL engines, Warehouses, BI, EAI environments, as well
as metadata repositories, contain, and often derive their processing from, metadata.
The metadata for these environments is distributed and duplicated, often times active,
and generally represented in a variety of methodologies, depending upon the underlying
technology they represent.
Meta Integration Technologies, Inc. with the Model Bridge (MIMB), Repository (MIR)
and Works (MIW), provide strikingly expanded set of capabilities in many facets of
metadata management, including:
-
Metadata comparison, integration, and mapping
-
Version and configuration management
-
Data life cycle related metadata management
-
Lineage and impact analysis
-
Enterprise architecture development, management and deployment.
This document is the culmination of seven years of experience in supporting the
enterprise metadata management and integration requirements of numerous clients.
It presents in detail and with supporting tutorials Meta Integration's vision,
metadata management process and methods, best practices, as well as, many strategic
scenarios that leverage the Meta Integration suite. These examples are comprehensive
and directed at real-world examples tied to business-oriented goals and return on
investment. In all, anyone who completes the exercises in this document should find
it straight-forward to implement and deploy an effective and comprehensive Meta
Integration based management environment.
Data Movement Tutorial
This document intends to provide a tutorial on the Meta Integration Works (MIW)
toolset through multiple labs. It complements the user guide by progressively
presenting all the capabilities of Meta Integration's data movement solutions.
This document is divided into four parts as follows:
-
The first part (composed of the first four sections of this tutorial)
describes the data movement process and all the data and metadata
(also known as models) involved in solving these problems.
The fourth section gives a few definitions, conventions, and
vocabulary specifically related to the Meta Integration toolset.
-
The second part (composed of the sections five to seven)
presents three exercises (known as labs) on data movement
between relational databases (RDBMS).
- The RDBMS Lab1 (described by section five)
is a single source data movement, allowing the user
to get started with the process and the toolset.
- The RDBMS Lab2 (described by section six)
is a more complex multi-source data movement.
- Finally the RDBMS Lab3 (described by section seven)
is a typical case of support for change in one of the databases,
requiring mapping migration in order to produce a new data movement solution.
-
The third part (composed of the sections eight and nine)
presents six more labs involving XML instead of RDBMS as the source or destination of the data movement. The section eight provides basic labs on XML in order to get started with this technology:
- XML Lab1 "eAddressBook": Publish the CRM address book of all customers
- XML Lab2 "eReporting": Report all PO(s) that have been shipped late.
- XML Lab3 "eBusiness": Import online orders to the CRM database.
The section nine provides more advanced XML based labs
- XML Lab4 is based on Customer Relationship management (CRM) version 1.0,
followed by a Version 2.0 on "eAlert":
Setup triggers on PO's order date and shipment date to receive alerts"
- XML Lab5: Human Resources (HR)
-
The fourth part (composed of the Appendix A)
provides a solution perform this entire tutorial using NCR Teradata
as the primary RDBMS database.
The sections described how to use the bridges migrating all the
demo/lab databases from MS Access (as delivered) to NCR Teradata.
Availability
Each of these tutorials is available as part of the
Metadata Lifecycle Management
product. Please contact us for more information.
![]() |
![]() |
Copyright © Meta Integration Technology, Inc. 1997-2008 All Rights Reserved.
Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
All other trademarks, trade names, service marks, and logos referenced herein belong to their respective companies.
http://www.metaintegration.com
|
