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.
|
| 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. |
- 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
[{"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27021980