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:
o Frequently available on data modeling and model design tools (e.g. Erwin Data Modeler)
o Available in some ETL tools to source/target data stores, but not for data transformations (e.g. Informatica PowerCenter)
o Rarely available on Business Intelligence design tools (e.g. SAP BusinessObjects Designer)
o 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):
o Data Integration (DI) tools (for ETL Transformations), such as:
- Microsoft SQL Server Integration Services (SSIS)
- Oracle Warehouse Builder (OWB)
o Business Intelligence (BI) design tools, such as:
- Microsoft SQL Server Analysis Services (SSAS)
- SAP BusinessObjects Designer