Product Documentation
Abstract
A list of all supported bridges and connectors that can be used with InfoSphere Metadata Asset Manager.
Content
The list of supported bridges and connectors and the functionality of particular bridges can sometimes change between releases. This document contains the most up-to-date information about which bridges and connectors are supported for importing and exporting metadata by using InfoSphere Metadata Asset Manager.
This topic has the following sections:
- Supported import bridges
- Supported export bridges
- Supported connectors
- Supported bridges for prior versions
For instructions on importing metadata by using InfoSphere Metadata Asset Manager, see Importing metadata.
For a list of bridges that are no longer supported at version 9.1, or whose names have changed, see Import bridges that are no longer supported.
Additional prerequisites must be met before you can import or export by using bridges. For details, see InfoSphere Metadata Integration Bridges Version 9.1 system requirements at http://www.ibm.com/support/docview.wss?&uid=swg27035749.
The following table lists supported import bridges by source-tool vendor or organization.
Table 1. Supported import bridges for Version 9.1 of InfoSphere Information Server
Tool vendor or organization | Import bridge | Imported metadata |
CA Technologies | CA Erwin 4 Data Modeler | Logical data models and physical data models from files that are produced by CA AllFusion ERwin Data Modeler 4. You can choose to create database schemas from physical data models. |
CA Technologies | CA ERwin 7 Data Modeler (File) | Logical data models and physical data models from files that are produced by CA AllFusion ERwin Data Modeler 7. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
CA Technologies | CA ERwin 8 Data Modeler (File) | Logical data models and physical data models from files that are produced by CA AllFusion ERwin Data Modeler, version 8. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
CA Technologies | CA ERwin 9 Data Modeler (File) | Logical data models and physical data models from files that are produced by CA AllFusion ERwin Data Modeler, version 9. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Embarcadero Technologies | Embarcadero ER/Studio Business Architect (via DM1) | Logical data models and physical data models from Embarcadero ER/Studio Business Architect, Version 1.5. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Embarcadero Technologies | Embarcadero ER/Studio Data Architect | Logical data models and physical data models from Embarcadero ER/Studio Data Architect, versions 5.1 to 9.6. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
IBM | IBM Cognos BI Reporting - Content Manager | Business intelligence (BI) models, BI reports, and related implemented data resources, such as database schemas and database tables. The bridge supports Cognos 8 BI Reporting Content Manager functionality in Cognos ReportNet and Cognos versions 8 to 8.4 and 10, including 10.2. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. Metadata mappings from Cognos to InfoSphere Information Server |
IBM | IBM DB2 Cube Views | BI models and related implemented data resources from IBM DB2 Cube Views, Version 8. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. Metadata mappings from DB2 Cube Views to InfoSphere Information Server |
IBM | IBM DB2 Warehouse Manager (via CWM XMI) | BI models and related implemented data resources in XML files that are created by IBM DB2 Warehouse Manager, Version 7.2 to 8. The XML files must be compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
IBM | IBM InfoSphere Data Architect MetaBroker | Logical data models and physical data models from InfoSphere Data Architect, versions 7.5.1 through 7.5.3, and versions 7.6, 8.1, 8.5, and 9.1. You can choose to create database schemas from physical data models. NOTE: To import from version InfoSphere Data Architect V.8.5 or V.9.1, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
IBM | IBM InfoSphere Discovery MetaBroker | Implemented data resources and analysis information. The bridge imports DBM files that are created by InfoSphere Discovery, Version 4.1.1.6 or later. |
IBM | IBM InfoSphere Streams | Endpoints from endpoint description files that are exported from InfoSphere Streams. |
Microsoft | Microsoft SQL Server Analysis and Reporting Services (Repository) | BI models, BI reports, and the implemented data resources that the reports source data from, such as database tables. Imports from versions 9.0 (2005) and 10.5 (2008 r2) of Microsoft SQL Server Analysis Services (SSAS) and Microsoft SQL Server Reporting Services (SSRS). NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Microsoft | Microsoft SQL Server Analysis Services (File) | BI models from Microsoft SQL Server Analysis Services versions 9 to 10.5. |
Microsoft | Microsoft SQL Server Database | Implemented data resources from Microsoft SQL Server versions 7 to 10.5. |
Microsoft | Microsoft SQL Server Reporting Services (File) | BI models and BI reports from Microsoft SQL Server Reporting Services, versions 9 through 10.5. |
MicroStrategy | MicroStrategy | BI models, BI reports, and related implemented data resources from MicroStrategy Intelligence Server, versions 7 to 9. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. Metadata mappings from MicroStrategy to InfoSphere Information Server |
Object Management Group | OMG CWM 1 XMI 1 | BI models and related 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. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
ODBC | ODBC 3.0 MetaBroker | Implemented data resources from databases that support the ODBC 3.0 protocol. |
Oracle | Oracle Business Intelligence Enterprise Edition | BI models, BI reports, and related implemented data resources from Oracle Business Intelligence Enterprise Edition versions 10.1 to 11.g. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. Metadata mappings from OBIEE to InfoSphere Information Server |
Oracle | Oracle Hyperion Application Builder (via CWM XMI) | BI models and related 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. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Oracle | Oracle Warehouse Builder (via CWM XMI) | BI models and related 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. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
SAP | SAP BusinessObjects Repository | BI models, BI reports, and related implemented data resources from versions 11 through 12.4 of SAP BusinessObjects Designer and BusinessObjects Desktop Intelligence, BusinessObjects Crystal Reports, and BusinessObjects Web Intelligence. The XI 4.0 and 4.1 versions do not support BusinessObjects Desktop Intelligence. NOTE: For the latest bridge version, and to import from BusinessObjects XI 4.0 or 4.1, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. Metadata mappings from BusinessObjects to InfoSphere Information Server |
SAS | SAS Data Integration Studio (via CWM XMI) | BI models and related implemented data resources 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. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Sybase | Sybase PowerDesigner CDM | Logical data models in CDM XML files that are created by Sybase PowerDesigner versions 7.5 through 16. CDM files in binary format are not supported. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Sybase | Sybase PowerDesigner LDM | Logical models in LDM XML files that are created by Sybase PowerDesigner versions 15 and 16. LDM files in binary format are not supported. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Sybase | Sybase PowerDesigner PDM | Physical data models in PDM XML files that are created by Sybase PowerDesigner versions 7.5 through 16. PDM files in binary format are not supported. You can choose to create database schemas from physical data models. NOTE: For the latest bridge version, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1. |
Supported export bridges
The following table lists supported export bridges by source-tool vendor or organization.
Table 2. Supported export bridges for Version 9.1 of InfoSphere Information Server
Tool vendor or organization | Export bridge | Exported metadata |
IBM | IBM InfoSphere Data Architect MetaBroker | Logical data models and physical data models to InfoSphere Data Architect, versions 7.5.1 through 7.5.3, version 7.6, and version 8.1. NOTE: Use Import Export Manager for exports with this bridge. |
Object Management Group | OMG CWM 1 XMI 1 | Implemented data resources to XML files that are compliant with the Object Management Group (OMG) Common Warehouse Metamodel (CWM) XML Metadata Interchange (XMI) file format. NOTE: Use InfoSphere Metadata Asset Manager for exports with this bridge. |
Supported connectors
The following connectors are supported for importing metadata by using InfoSphere Metadata Asset Manager.
Connectors import implemented data resources, including database schemas and database tables. See your connector documentation for more information.
- Greenplum connector (NOTE: To import with the Greenplum connector, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1.)
- IBM DB2 connector
- IBM Netezza connector
- JDBC connector (NOTE: To import with the JDBC connector, you must install prerequisite software that is listed in the technote Prerequisites for functionality added to InfoSphere Information Server, V9.1.)
- ODBC connector
- Oracle connector 10g
- Oracle connector 11g
- Teradata connector
Supported bridges for prior versions
Supported bridges for version 11.3: http://www.ibm.com/support/docview.wss?uid=swg27042029
Supported bridges for version 8.7: http://www.ibm.com/support/docview.wss?&uid=swg27021980
Supported bridges for version 8.5: http://www.ibm.com/support/docview.wss?&uid=swg27018056
Supported bridges for versions 8.1 and 8.1.2: http://www.ibm.com/support/docview.wss?uid=swg27012944
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg27025125