List of supported bridges for Information Server Version 8.7

Product documentation


Abstract

Lists InfoSphere Metadata Integration Bridges that are supported for import and export and the types of metadata that they transfer.

Content

Use InfoSphere Metadata Asset Manager to import metadata into the metadata repository.

Use Import Export Manager to export metadata from the metadata repository.
The following bridges are supported by InfoSphere Information Server Version 8.7:
Bridges for import

Bridge name and version Assets transferred Bridge-specific software prerequisites
CA ERwin 4 Data Modeler
Imports logical data models and physical data models from files that are produced by CA AllFusion ERwin Data Modeler 4. To import .ER1 files, you must install the CA AllFusion ERwin Data Modeler COM/OLE API on the same computer that the bridge is installed on.To import XML files you must ensure that CA AllFusion ERwin Data Modeler is installed with the option to save XML files in the AllFusion Repository Format.
CA ERwin 7 Data Modeler (File) Imports logical data models and physical data models from .ERWIN or XML files that are produced by CA AllFusion ERwin Data Modeler 7. To import ERWIN files, you must install CA AllFusion ERwin Data Modeler 7 on the same computer that the bridge is installed on. The file that you want to import must exist on the same computer.
To import XML files, you must ensure that CA AllFusion ERwin Data Modeler is installed with the option to save XML files in the AllFusion Repository Format.
CA ERwin 8 Data Modeler (File)

NOTE: To use the bridge, you must install prerequisite software that is listed in the technote "Prerequisites for functionality added to Information Server, V8.7."
Imports logical data models and physical data models from .ERWIN or XML files that are produced by CA AllFusion ERwin Data Modeler, version 8.
To import ERWIN files, you must install CA AllFusion ERwin Data Modeler 8 on the same computer that the bridge is installed on. The file that you want to import must exist on the same computer.
To import XML files, ensure that CA AllFusion ERwin Data Modeler was installed with the option to save XML files in the AllFusion Repository Format. This option is not installed by default. If necessary, modify the installation to install the option. To create an XML file for import, open the ERWIN file in ERwin 8 and save it as an XML Repository file.
DBM File MetaBroker Imports analysis information and implemented data resources in DBM files that are created by InfoSphere Discovery, Version 4.1.1.6 or later.
Embarcadero ER/Studio Business Architect (via DM1) Imports logical data models and physical data models from Embarcadero ER/Studio Business Architect, Version 1.5.
Embarcadero ER/Studio Data Architect Imports logical data models and physical data models from Embarcadero ER/Studio Data Architect, versions 7 to 8.5.
IBM Cognos BI Reporting-Content Manager

NOTE: To use the bridge, you must install prerequisite software that is listed in the technote "Prerequisites for functionality added to Information Server, V8.7."
Imports a complete package of business intelligence (BI) models, BI reports, BI queries and related implemented data resources.
Supports Cognos BI Reporting Content Manager functionality in Cognos ReportNet and Cognos versions 8 to 8.4 and 10.1.
Metadata mappings from Cognos to InfoSphere Information Server
IBM Cognos 8 BI Reporting-Content Manager Packages NOTE: For best import and data lineage results, use IBM Cognos 8 BI Reporting-Content Manager bridge instead of the Packages bridge for imports from Cognos.
Imports business intelligence (BI) models and related implemented data resources from a package.
Supports Cognos 8 BI Reporting Content Manager functionality in Cognos ReportNet and Cognos versions 8 to 8.4. Also supports the equivalent of Cognos 8.4 functionality in Cognos 10. New functionality in Cognos 10 is not supported.
IBM Cognos 8 BI Reporting-Content Manager ReportStudio NOTE: For best import and data lineage results, use IBM Cognos 8 BI Reporting-Content Manager bridge instead of the ReportStudio bridge for imports from Cognos.
Imports BI reports and BI queries from a package.
Supports Cognos 8 BI Reporting Content Manager functionality in Cognos ReportNet and Cognos versions 8 to 8.4. Also supports the equivalent of Cognos 8.4 functionality in Cognos 10. New functionality in Cognos 10 is not supported.
IBM DB2 Warehouse Manager (via CWM XMI) Imports implemented data resources in XML files that are created by IBM DB2 Warehouse Manager, Version 7.2. The XML files must be compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format.
IBM InfoSphere Data Architect MetaBroker

Imports logical data models and physical data models from InfoSphere Data Architect versions 7.5.1 through 7.5.3, and 7.6 through 9.1.1.
NOTE: To use the bridge with versions 7.6 through 9.1.1, you must install prerequisite software that is listed in the technote "Prerequisites for functionality added to Information Server, V8.7."
IBM InfoSphere Warehouse / Cubing Services for OLAP   Imports BI models and implemented data resources from IBM InfoSphere Warehouse / Cubing Services for OLAP, Version 9.
Metadata mappings from DB2 Cube Views to InfoSphere Information Server
Microsoft SQL Server Analysis Services (File) Imports business intelligence models from Microsoft SQL Server Analysis Services, Version 9.
MIcrosoft SQL Server Database Imports implemented data resources including database schemas from Microsoft SQL Server versions 7 to 10.
Establishes a JDBC connection with a physical database to import schemas.
Microsoft SQL Server Data Source View Imports implemented data resources and BI models from Microsoft SQL Server Data Source View, versions 9 and 10. Imports XML files with the DSV or XMLA extension.
MIcrosoft SQL Server Reporting Services (File) Imports BI models and BI reports from files that are created by Microsoft SQL Server Reporting Services, versions 9 and 10.
MicroStrategy Imports business intelligence models and related implemented data resources from MicroStrategy Intelligence Server, versions 7 through 9.
Metadata mappings from MicroStrategy to InfoSphere Information Server
A supported version of MicroStrategy that can open the metadata to be imported must be installed on the same computer that the bridge is installed on.
ODBC 3.0 MetaBroker For best import results, users of InfoSphere Metadata Asset Manager should use the ODBC connector instead of the ODBC 3.0 MetaBroker.
Imports implemented data resources including schemas and tables from databases that support the ODBC 3.0 protocol. Does not support import from Microsoft Access.
OMG CWM 1 XMI 1 Imports implemented data resources from XML files that are compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format, versions 1 to 1.1.
Oracle Business Intelligence Enterprise Edition

NOTE: To use the bridge, you must install prerequisite software that is listed in the technote "Prerequisites for functionality added to Information Server, V8.7."
Imports BI models, BI reports, and related implemented data resources from Oracle Business Intelligence Enterprise Edition versions 10 and 11 (formerly Siebel Analytics).
Metadata mappings from OBIEE to InfoSphere Information Server
Meet the following prerequisites before you use the bridge to import metadata.
  • Ensure that the user name that you specify to connect to the presentation server has the necessary permissions to access the objects that you want to import.
  • The Oracle BI Administration tool stores metadata in a Repository RPD file that you must convert to XML format for version 11 and to UDML format for version 10.
  • For version 11 take these steps to prepare the XML file.
    1. Run bi-init.cmd on Microsoft Windows or bi-init.sh on UNIX or Linux to launch a command prompt or shell window that is initialized to your Oracle instance. The files are located in the following directory: ORACLE_INSTANCE\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.
    2. Use the biserverxmlgen command line utility to generate XML: biserverxmlgen -R file_path_and_name.rpd -P password -O file_path_and_name.xml -8. The option -8 is required.
      The bridge uses the generated XML file as input.
  • For version 10, prepare the UDML file by running the following command with nQUDMLGen command line utility: $OracleBIHome$\server\Bin\nQUDMLGen.exe -U Administrator -P Administrator -R file_path_and_name.rpd -O file_path_and_name.udml -N -Q -8. The options -N, -Q, and -8 are required.
    The bridge uses the generated XML file or UDML file as input. You must upload the file to either the metadata interchange server or the local client computer before you run the import.
Oracle Hyperion Application Builder (via CWM XMI) Imports implemented data resources in XML files that are created by Oracle Hyperion Application Builder. The XML files must be compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format.
Oracle Warehouse Builder (via CWM XMI) Imports implemented data resources in XML files that are created by Oracle Warehouse Builder, Version 9i. The XML files must be compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format.
SAP BusinessObjects Data Integrator
Imports physical models from XML files that are exported from BusinessObjects Data Integrator, Version 11.7.
SAP BusinessObjects Designer (File) NOTE: For best import and data lineage results, use SAP BusinessObjects Repository bridge instead of the Designer bridge for imports from BusinessObjects.
Imports business intelligence models and their related implemented data resources from versions 5 through 12.2 of BusinessObjects Designer.
Connects to a specific universe file.
A supported version of BusinessObjects Designer must be installed on the same computer that the bridge is installed on.
SAP BusinessObjects Designer (Repository) NOTE: For best import and data lineage results, use SAP BusinessObjects Repository bridge instead of the Designer bridge for imports from BusinessObjects.
Imports business intelligence models and their related implemented data resources from versions 5 through 12.2 of BusinessObjects Designer.
Connects directly to the Designer repository.
A supported version of BusinessObjects Designer must be installed on the same computer that the bridge is installed on.
SAP BusinessObjects Desktop Intelligence (File) NOTE: For best import and data lineage results, use SAP BusinessObjects Repository bridge instead of the Desktop Intelligence bridge for imports from BusinessObjects.
Imports business intelligence reports from versions 5 through 12.2 of BusinessObjects Reporter or BusinessObjects Desktop Intelligence.
Imports a document file.
Use the repository version of this bridge instead if you want to run data lineage or impact analysis reports on the imported assets.
BusinessObjects Reporter or Desktop Intelligence must be installed on the same computer that the bridge is installed on.
SAP BusinessObjects Desktop Intelligence (Repository) NOTE: For best import and data lineage results, use SAP BusinessObjects Repository bridge instead of the Desktop Intelligence bridge for imports from BusinessObjects.
Imports business intelligence reports from versions 5 through 12.2 of BusinessObjects Reporter or BusinessObjects Desktop Intelligence.
Reads a document from the repository.
BusinessObjects Reporter or Desktop Intelligence must be installed on the same computer that the bridge is installed on.
SAP BusinessObjects Repository Imports business intelligence reports, business intelligence models, and related implemented data resources from versions 5 through 12.2 of BusinessObjects Designer and BusinessObjects Desktop Intelligence.
Metadata mappings from BusinessObjects to InfoSphere Information Server
Supported versions of both BusinessObjects Designer and BusinessObjects Reporter must be installed on the same computer that the bridge is installed on.
SAP BusinessObjects Web Intelligence NOTE: For best import and data lineage results, use SAP BusinessObjects Repository bridge instead of the Web Intelligence bridge for imports from BusinessObjects.
Imports business intelligence reports from versions 11 thorugh 12.2 of BusinessObjects Web Intelligence.
The BusinessObjects Web Intelligence API must be installed on the same computer that the bridge is installed on.
SAS Data Integration Studio (via CWM XMI) Imports implemented data resources and business intelligence models in XML files that are created by SAS Data Integration Studio, Version 9. The XML files must be compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format.
Sybase PowerDesigner CDM Imports logical data models from CDM XML files that are created by Sybase PowerDesigner versions 7.5 through 15.
Sybase PowerDesigner PDM
version 6.1
Imports implemented data resources in PDM files that were created by Sybase PowerDesigner Data Architect, Version 6.1.
Sybase PowerDesigner PDM
versions 7.5 to 15
Imports implemented data resources in PDM files that were created by Sybase PowerDesigner versions 7.5 through 15.
User Information MetaBroker Imports comma-separated values (CSV) files that contain users who can be designated as stewards of assets in the metadata repository. These users can be assigned no other roles.
Note: The following import and export bridges have been replaced by the OMG CWM 1 XMI 1 bridge:
  • Adaptive Repository & Foundation (via CWM XMI) version 4.x
  • ASG Rochade (via CWM XMI) version 6.x to 7.x
  • Business Objects Data Integrator (via CWM XMI) version 6.x to 11.x

Bridges for export

Bridge name and version Assets transferred
Altova XMLSpy Exports implemented data resources.
SAP Business Objects Metadata Manager (via MIR XMI) Exports implemented data resources.
IBM DB2 Warehouse Manager (via CWM XMI) Exports implemented data resources.
IBM InfoSphere Data Architect MetaBroker Exports logical and physical data models from
InfoSphere Data Architect versions 7.5.1 through 7.5.3
Informatica Metadata Manager (via MIR XMI) Exports implemented data resources.
Meta Integration Repository (MIR) XMI file Exports implemented data resources.
OMG CWM 1 XMI 1 Exports implemented data resources.
Oracle Hyperion Application Builder (via CWM XMI) Exports implemented data resources.
Oracle Warehouse Builder (via CWM XMI) Exports implemented data resources.
SAS Data Integration Studio (via CWM XMI) Exports implemented data resources.
SAS Data Integration Studio (via MIR XMI) Exports implemented data resources.
SAS Information Map Studio (via MIR XMI) Exports implemented data resources.
SAS Management Console (via MIR XMI) Exports implemented data resources.
Sybase PowerDesigner XSM Exports implemented data resources.
User Information MetaBroker Exports information on suite users.
W3C XML Schema 1.0 (XSD) Exports implemented data resources.

Additional prerequisites must be met before you can import or export by using bridges. For details, see InfoSphere Metadata Integration Bridges Version 8.7 system requirements at http://www.ibm.com/support/docview.wss?&uid=swg27021981.
Supported bridges for versions 8.1 and 8.1.2: http://www.ibm.com/support/docview.wss?uid=swg27012944
Supported bridges for version 8.5: http://www.ibm.com/support/docview.wss?&uid=swg27018056

Rate this page:

(0 users)Average rating

Document information


More support for:

InfoSphere Information Server

Software version:

8.7

Operating system(s):

Windows

Reference #:

7021980

Modified date:

2014-06-16

Translate my page

Machine Translation

Content navigation