Limitations on Export Bridge's Merge/Update Capabilities

The export bridges generally depend upon the tool receiving the metadata to integrate the metadata correctly, i.e., provide compare, merge and integrate capabilities. Such capabilities are:

  • Frequently available on data modeling and model design tools (e.g. Erwin Data Modeler)

  • Available in some ETL tools to source/target data stores, but not for data transformations (e.g. Informatica PowerCenter)

  • Rarely available on Business Intelligence design tools (e.g. SAP BusinessObjects Designer)

  • In order to accommodate these limitations in the destination tool, the following MIMB export bridges offer "limited" metadata update capabilities (Please see the bridge parameter tooltips for more details):

  • Data Integration (DI) tools (for ETL Transformations), such as:

  • Microsoft SQL Server Integration Services (SSIS)

  • Oracle Warehouse Builder (OWB)

  • Business Intelligence (BI) design tools, such as:

  • Microsoft SQL Server Analysis Services (SSAS)

  • SAP BusinessObjects Designer