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