IBM InfoSphere Discovery MetaBroker

You can use IBM InfoSphere Discovery MetaBroker® to import DBM (database model) files from InfoSphere® Discovery into the metadata repository of InfoSphere Information Server. The files can contain implemented data resources and analysis results.

The bridge imports DBM files that are created by InfoSphere Discovery, Version 4.1.1.6 or later.

Use IBM® InfoSphere Data Architect MetaBroker to import DBM files from InfoSphere Data Architect.

It is not necessary to install InfoSphere Discovery to import a DBM file by using IBM InfoSphere Discovery MetaBroker.

Important: Use IBM InfoSphere Discovery MetaBroker to import files that contain tables from a single database, not tables from multiple databases. You must enter the host computer name, database name, database management system (DBMS), and DBMS instance name as parameters for the import.

IBM InfoSphere Discovery MetaBroker supports the three model types that are produced by InfoSphere Discovery : generic SQL, IBM DB2®, and Oracle.

IBM InfoSphere Discovery MetaBroker does not import categories and terms or references to categories and terms.

You can import the following types of assets into the metadata repository when you use IBM InfoSphere Discovery MetaBroker:

Implemented data resources:
- host computers
- databases
- database schemas
- stored procedures
- database tables
- database columns
- foreign keys
- candidate keys
- indexes
Analysis assets:
- table analysis properties
- column analysis properties
- data classification codes
- inferred candidate keys
- inferred foreign keys

The following table lists the product modules that can view and work with the implemented data resources and analysis assets that are stored in the metadata repository:

Table 1. Product modules that work with metadata that is imported by using IBM InfoSphere Discovery MetaBroker
Product module	Types of metadata that you can work with
InfoSphere Information Analyzer	Implemented data resources and analysis assets
InfoSphere DataStage® and QualityStage®	Implemented data resources with annotations that include analysis information
InfoSphere Information Governance Catalog InfoSphere FastTrack	Implemented data resources Table analysis summaries and column analysis summaries Inferred keys displayed as attributes of analysis summaries

Scenario for importing and using DBM files

A user of InfoSphere Discovery highlights relationships between database tables that comprise a data set in a project. By choosing the Export to Optim™ option, the user creates a DBM file that contains the data set.

A data analyst uses IBM InfoSphere Discovery MetaBroker to import the file into InfoSphere Information Server.

Working in InfoSphere Information Analyzer, the data analyst assesses the data quality and provides reports and annotations to subject matter experts and developers. The analyst also establishes data rules for ongoing validation.