Table of Contents
1. Overview
- Metadata Harvesting required for Metadata Management (MM) applications, including metadata harvesting from live databases (or big data), Data Integration (DI, ETL and ELT) , and Business Intelligence (BI) software.
- Metadata Integration required for tool integration in the software development life cycle, including all necessary forward and reverse engineering steps to update each other tools: for example between Data Modeling (DM), Data Integration (DI), and Business Intelligence (BI) design tools.
- Metadata Conversion required for legacy migration from an older design tool to a new one.
2. Copyright Notice
Copyright © Meta Integration Technology, Inc. 1997-2022.
All Rights Reserved.
Meta Integration® is a registered trademark of Meta Integration Technology, Inc.
Other product and company names (or logos) mentioned herein may be the trademarks of their respective owners.
http://www.metaintegration.com
3. Release Changes
Disclaimer on Beta Bridges::As part of its continuous research and development, MITI may develop prototypes of new bridges. Such bridges may be provided as beta bridges [i.e. marked as "(beta)" or "beta bridge"] to the MIMB OEM Software for the sole purpose of proof of concepts and customer feedback. Such beta bridges are not officially supported, and MITI reserves the rights to discontinue such beta bridges.
v11.1.0 (12/31/2022 - release date and features are subject to change)
-
DATA / RELATIONAL DATABASES (RDBMS, Big Data / Hadoop Hive, etc.):
-
Hadoop Hive JDBC import bridges major improvement for fast incremental harvesting (up to 10x faster) based of the Metastore Listener technology.
- Apache Hadoop Hive Database import bridge: new support for metastore listener
- Cloudera Data Platform Hadoop Hive Database import bridge: new support for metastore listener
- Cloudera Hortonworks Data Platform Hadoop Hive Database import bridge: new support for metastore listener
- Databricks Delta Lake Hadoop Hive Database import bridge: new support for metastore listener
- Google Cloud Platform (GCP) Hadoop Hive Database import bridge: new support for metastore listener
- HPE Ezmeral Data Fabric (MapR Data Platform) Hadoop Hive Database import bridge: new support for metastore listener
-
Hadoop Hive JDBC import bridges major improvement for fast incremental harvesting (up to 10x faster) based of the Metastore Listener technology.
-
DATA / FILE SYSTEMS (Object Stores, Data Lake, Flat Files / CSV, etc.):
- TBD
-
DATA / NoSQL DATABASES (JSON, etc.) :
- TBD
-
DATA INTEGRATION (DI/ETL/ELT/Scripts):
-
Databricks platform extended support through enhanced and new bridges:
- Databricks Collaborative Notebooks / Spark import bridge: new beta bridge
- Databricks Unified Data Services / Spark import bridge: major new enhancements
- Microsoft SQL Server Integration Services (SSRS) Server (on prem) import bridge: support for version 15.x (2019 and newer)
- Talend Data Integration import bridge: major improvements including support for numerous new data connectors and transformations, as well as new support for dynamic jobs loading metadata (schema, table, DDL, SQL) from external tables/files.
-
Databricks platform extended support through enhanced and new bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
Microsoft Analytics tools major improvements:
-
Microsoft Power BI (PBIX or PBIT) File (PowerQuery M language based) import
bridge,
Microsoft Power BI Report Server (Repository) import bridge, and
Microsoft Azure Power BI Service (Repository) import bridge: major improvements pending Microsoft's progress in the metadata access (API and file formats) to its Power BI technologies. - Microsoft SQL Server Analysis Services (SSAS) XMLA file import bridge: major improvements to support new Microsoft API
- Microsoft Azure Analysis Services (based on SSAS) import bridge: support for version 15.x (2019 and newer)
- Microsoft SQL Server Analysis Services (SSAS) Server (on prem) import bridge: support for version 15.x (2019 and newer)
- Microsoft SQL Server Reporting Services (SSRS) Server (on prem) import bridge: support for version 15.x (2019 and newer)
-
Microsoft Power BI (PBIX or PBIT) File (PowerQuery M language based) import
bridge,
-
Microsoft Analytics tools major improvements:
-
BUSINESS APPLICATION (ERP, etc.):
-
MIMB CUSTOM IMPORT BRDGE SDK:
allowing developers to build their own custom import bridges from Data Stores, Data Integration, Business Intelligence and Business Applications, including to ability to build their own:- custom metamodel / profiles derived from the Meta Integration Repository (MIR) Metamodel,
- custom Meta Integration Model Bridge (MIMB) import bridge.
-
MIMB THIRD PARTY SOFTWARE UPDATES:
- All third party & open source software has been upgraded to their latest versions for bug fixes, improvements, and better security vulnerability protection. For more details, see the published MIMB's Third Party & Open Source Software Usage and LICENSES.
v11.0.0 (01/31/2022)
-
DATA / HIERRACHICAL STRUCTURES AND ARRAYS (JSON, etc.):
Major improvements of JSON file modeling (metamodel/profile) including new support for root object types, arrays, and more.
Consequently any use of JSON in the following import bridges has been redesigned, and therefore requires a full import (i.e. without incremental harvesting):-
FILE SYSTEMS (Object Stores, Data Lake, etc) with JSON files inside:
- File Systems (JSON)
- Apache Hadoop Distributed File System (HDFS Java API)
- Amazon AWS Simple Storage Service (S3) File System
- Microsoft Azure Data Lake Storage Gen2
- Microsoft Azure Blob Storage File System
- Google Cloud Storage (GCS) File System
- Confluent Kafka File System (API and Schema Registry)
- OpenStack Swift Object Store File System
- NoSQL databases based on JSON:
- ETL/ELT/DI/BI bridges reading/writing JSON file based data stores, such as the following import bridges:
-
FILE SYSTEMS (Object Stores, Data Lake, etc) with JSON files inside:
-
DATA / COMPLEX TYPES (Arrays, Structures):
New support for complex types (arrays and structures) often on tables implemented/externalized as JSON files, on some import bridges:-
Databases supporting complex types implemented as external files, such as the following import bridges:
- Apache Hadoop Hive Database (HCatalog and Metastore via JDBC)
- Cloudera Data Platform Hadoop Hive Database (HCatalog and Metastore via JDBC)
- Databricks Delta Lake Hadoop Hive Database (HCatalog and Metastore via JDBC)
- Google Cloud Platform (GCP) Hadoop Hive Database (HCatalog and Metastore via JDBC)
- Google BigQuery Database (via JDBC)
- Snowflake Database (via JDBC)
- ETL/ELT/DI/BI import bridges reading/writing database complex types, such as the following import bridges:
-
Databases supporting complex types implemented as external files, such as the following import bridges:
-
DATA / RELATIONAL DATABASES (RDBMS, Big Data / Hadoop Hive, etc.):
- Amazon Web Services (AWS) Athena Database import bridge: new bridge
- Amazon Web Services (AWS) Aurora Database import bridge: new bridge
- Apache Druid Database import bridge: new bridge
- Google BigQuery Database import bridge: redesigned and improved
- Google Spanner Database (via JDBC) import bridge: new bridge
- Presto Database import bridge: new bridge
- SAP Sybase ASE Database import bridge: redesigned and improved
-
DATA / FILE SYSTEMS (Object Stores, Data Lake, Flat Files / CSV, etc.):
- Confluent Kafka Schema Registry import bridge major improvements
- Microsoft Azure Data Lake Storage Gen2 import bridge: major improvements
-
DATA / NoSQL DATABASES (JSON, etc.) :
- Microsoft Azure Cosmos DB import bridge: new bridge
-
DATA INTEGRATION (DI/ETL/ELT/Scripts):
- Data Mapping Script import bridge: new import bridge from data mapping SQL like scripts supporting any source/target technologies (RDBMS, NoSQL, file systems, etc.) to emulate proprietary (or non supported) DI/ETL/ELT/CDC tools and technologies.
- Amazon Web Services (AWS) Glue ETL (via Apache Spark) import bridge: major improvements.
- Databricks Unified Data Services (via Apache Spark) import bridge
- Microsoft Azure Data Factory import bridge: major improvements.
- Informatica PowerCenter import bridge: major improvement for fast incremental harvesting (up to 10x faster) based on PowerCenter Repository XML incremental generation and rebuild.
- Snowflake Database SQL DML (DI/ETL) Script (SnowSQL) import bridge: major improvements to support the ETL aspects like SnowPipe, Stream, Task.
- Talend Data Integration import bridge: major improvements including support for numerous new data connectors and transformations, as well as new support for internal parameter overwrite to improve lineage.
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
Microsoft Power BI (PBIX or PBIT) File (PowerQuery M language based) import
bridge,
Microsoft Power BI Report Server (Repository) import bridge, and
Microsoft Azure Power BI Service (Repository) import bridge: major improvements including new Remote browsing, authentication. However, this bridge remains limited (compared to other BI server import bridges) because of Microsoft Power BI's current limited metadata access (API and file formats). More major improvements are expected in the next release pending Microsoft progress. - Microsoft SQL Server Analysis Services (SSAS) XMLA file import bridge: redesigned in java, and new multi dimensional modeling in addition to tabular modeling
- Tableau Hyper (Data Extract) Data Store import bridge: major improvements including support for the latest version and API
-
Microsoft Power BI (PBIX or PBIT) File (PowerQuery M language based) import
bridge,
-
BUSINESS APPLICATION (ERP, etc.):
- SAP Business Warehouse 4 HANA (BW/4HANA) import bridge: improved ABAP scripts, and support for Query Reports
-
MIMB CREDENTIALS ON CLOUD SECRET MANAGERS:
allowing administrators to store bridge credentials (e.g. user, password and private key) in a cloud secret manager, including support for: -
MIMB THIRD PARTY SOFTWARE UPDATES:
- All third party & open source software has been upgraded to their latest versions for bug fixes, improvements, and better security vulnerability protection. For more details, see the published MIMB's Third Party & Open Source Software Usage and LICENSES.
v10.1.0 (GA 01/31/2020 - Deprecated 12/31/2021 - EOL 12/31/2022)
-
DATA STORES (Flat files, RDBMS, Cloud Databases, Big Data / Hadoop):
-
RELATIONAL DATABASE support for multi-model incremental harvesting.
Large database servers containing multiple schemas (e.g. Oracle, Teradata, etc.) or multiple database instances (e.g. Microsoft SQL Server) are now imported as multiple models (e.g. one model per schema or database instance) with support for incremental harvesting (e.g. only updated or new schemas are imported while unchanged schemas are reused from the harvesting cache). For backward compatibility, databases are still imported as single models by default, multi model is achieved with the Miscellaneous option -model.split (previously -multiModel). Therefore, single large model database import is officially deprecated with this version but still supported, however it will be removed only at the next major release. -
DATA CATALOGING OF THE DATA LAKE on local file servers (POSIX file systems), over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), on messages databases (e.g. Kafka), or on NoSQL databases (e.g. MongoDB):
- with high level data lake directory inventory import bridges such as:
-
RELATIONAL DATABASE support for multi-model incremental harvesting.
-
DATA INTEGRATION (DI/ETL/ELT/Scripts):
-
New bridges:
- Amazon Web Services (AWS) Glue ETL (via Apache Spark) import bridge
- Databricks Unified Data Services (via Apache Spark) import bridge
- Denodo Virtual DataPort import bridge
- Informatica Data Engineering Integration (DEI) / Big Data Management (BDM) Developer import bridge
- Microsoft Azure Data Factory import bridge
- Snowflake Database SQL DML (DI/ETL) Script (SnowSQL) import bridge
-
New bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
- New bridges:
-
GENERAL:
- All Third Party & Open Source Software have been upgraded to their latest versions for better security vulnerability protection.
v10.0.1 (GA 04/24/2019 - Deprecated 12/31/2020 - EOL 12/31/2021)
-
DATA STORES (Flat files, RDBMS, Cloud Databases, Big Data / Hadoop):
-
DATA CATALOGING OF THE DATA LAKE on local file servers (POSIX file systems), over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), on messages databases (e.g. Kafka), or on NoSQL databases (e.g. MongoDB):
- automatically crawling and discovering lower level metadata from flat file, NoSQL, and other file import bridges:-
New Bridges:
- Positional File import (e.g from mainframe) based on .pos file defining each field position and type bridge
-
New Bridges:
-
DATA CATALOGING OF THE DATA LAKE on local file servers (POSIX file systems), over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), on messages databases (e.g. Kafka), or on NoSQL databases (e.g. MongoDB):
-
DATA SERVICES (REST API, Web Services):
-
New Bridges:
- Web Services Description Language (WSDL) import (Beta Bridge) bridge
-
New Bridges:
-
DATA INTEGRATION (DI/ETL/ELT/Scripts):
-
New bridges:
- Apache Spark (with Python or Scala) import (Beta Bridge) bridge
- Teradata Parallel Transporter (TPT) Script importbridge
-
Improved Bridges:
- Talend Data Integration import major improvements bridge
-
New bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
Improved Bridges:
- MicroStrategy Intelligence Server import to support the latest v11.x (including 11.1/2019) bridge
- Oracle Business Intelligence (OBI) Enterprise Edition (Server) import to support Prompts bridge
- TIBCO Spotfire Analyst (DXP Format) import major improvements bridge
- TIBCO Spotfire Server (Repository) import major improvements bridge
-
Improved Bridges:
-
DATA MODELING (DM) & other Modeling Technologies:
-
Improved Bridges:
- erwin Data Modeler and Mart import/export to support 2019 R1 bridge
- IDERA ER/Studio Repository import ported to Java (isolating the COM API) and support for 18.0 bridge
-
Improved Bridges:
-
METADATA MANAGEMENT (MM) & DATA GOVERNANCE (DG):
-
Improved Bridges:
- Apache Atlas (for HortonWorks) import major improvements bridge
- Cloudera Navigator import major improvements bridge
-
Improved Bridges:
-
GENERAL:
- All Third Party & Open Source Software have been upgraded to their latest versions for better security vulnerability protection.
v10.0.0 (GA 09/21/2018 - Deprecated 09/21/2020 - EOL 12/31/2020)
-
DATA STORES (Flat files, RDBMS, Cloud Databases, Big Data / Hadoop):
-
DATA CATALOGING OF THE DATA LAKE on local file servers (POSIX file systems), over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), on messages databases (e.g. Kafka), or on NoSQL databases (e.g. MongoDB):
- with high level data lake directory inventory import bridges such as:- File System (for Linux and Windows) import bridge
- Amazon S3 (Simple Storage Service) import bridge
- Apache Hadoop Distributed File System (HDFS) (for Cloudera, Hortonworks, and MapR) import bridge
- Microsoft Azure Blob Storage import bridge
- Microsoft Azure Data Lake Storage import bridge
- OpenStack Swift (Object Storage) import bridge
- Apache Kafka Cluster import bridge
- MongoDB Database (JSON) import bridge
- Apache CouchDb Database (JSON) import bridge
- MarkLogic NoSQL Database (for JSON only) import bridge
- Flat File (CSV) import bridge
- Microsoft Office Excel (XSLX) File import bridge
- JSON (JavaScript Object Notation) File import bridge
- Apache Avro File import bridge
- Apache Parquet File import bridge
- Apache ORC File import bridge
- W3C XML File import bridge
-
DATA SERVICES (REST API, Web Services):
- New Bridges:
-
OTHER DATA STORES:
-
New Bridges:
- Apache Hadoop HBase Database (Java API) import bridge
- Apache Hadoop Hive Database (Hive Metastore via JDBC) import bridge
- Microsoft Azure SQL Database import bridge
- Microsoft Azure SQL Data Warehouse import bridge
- SAP HANA import bridge
- SAS Library import bridge
- Snowflake Database (via JDBC) import bridge
-
New Bridges:
-
DATA CATALOGING OF THE DATA LAKE on local file servers (POSIX file systems), over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), on messages databases (e.g. Kafka), or on NoSQL databases (e.g. MongoDB):
-
DATA INTEGRATION (DI/ETL/ELT/Scripts):
-
New Bridges:
- Apache Sqoop import bridge
- Informatica Developer import new support for DI/ETL bridge
- SAP Data Services (BODI/BODS) import bridge
- SAS base SAS code import bridge
- SAS Data Integration (via SAS Metadata Server) import bridge
- Talend Data Preparation import bridge
-
Improved Bridges:
- Microsoft SQL Server Integration Services (SSIS) import support for up to version 14.0 (2017) bridge
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- SAS BI Visual Analytics (via SAS Metadata Server) import bridge
- Microsoft Azure Power BI import bridge
- TIBCO Spotfire Server import bridge
- TIBCO Spotfire Document (File) import bridge
- TIBCO Spotfire Binary Data (SBDF Format) (File) import bridge
- TIBCO Spotfire Text Data (STDF Format) (File) import bridge
- ThoughtSpot import bridge
-
Improved Bridges:
- Microsoft SQL Server Analysis Services (SSAS) import support for up to version 14.0 (2017) and specifically its new JSON serialization of the Tabular Model bridge
- Qlik Sense import bridge
-
New Bridges:
-
DATA MODELING (DM) & other Modeling Technologies:
- New Bridges:
-
METADATA MANAGEMENT (MM) & DATA GOVERNANCE (DG):
-
Improved Bridges:
- Apache Atlas (for HortonWorks) import bridge
- Cloudera Navigator import bridge
-
Improved Bridges:
-
BUSINESS APPLICATIONS:
- Improved Bridges:
-
GENERAL:
- All Java code is now compiled with Java 8 without Java 7 compatibility.
- All Third Party & Open Source Software have been upgraded to their latest versions for better security vulnerability protection.
- Some bridges require access to third party drivers in their parameters (such as "Google BigQuery Database" or "Microsoft Azure Blob Storage"). In order to facilitate the user experience, some of these bridges are now "Driver Live Download Enabled" where the bridges uses Apache Maven to download the proper driver version and use it automatically. In such case, new messages "Downloading https://repo.maven.apache.org/maven2/" will appear in the bridge log. If the bridge cannot access internet, a message "Error downloading data from URL" is displayed, and the user needs to manually download the driver and provide it as a bridge parameter. The list of bridges that can automatically download drivers from Apache Maven have a download icon on the supported tools page.
-
END OF LIFE (EOL) / DEPRECATED BRIDGES:
- Previous FLAT FILE prototype/beta import bridges such as "Flat File (CSV or XLSX) - Beta Bridge" (FlatExcelFile) and "Flat File (CSV) - Beta Bridge" (FlatFile) have been deprecated (EOL) and replaced by the (much more powerful and universal) officially supported import bridge from "File System (CSV, Excel, XML, JSON, Avro, Parquet, ORC)" (FileSystem) bridge
- Previous HADOOP HDFS prototype/beta import bridges such as "Apache Hadoop Distributed File System (WebHDFS REST API) - Beta Bridge" (ApacheHDFSWeb) have been deprecated (EOL) and replaced by the officially supported import bridge from "Apache Hadoop Distributed File System (HDFS Java API)" (ApacheHDFS) bridge
v9.1.0 (GA 04/24/2017 - Deprecated 12/31/2018 - EOL 12/31/2019)
-
GENERAL FEATURES, ARCHITECTURE & METAMODEL CHANGES:
-
METADATA HARVESTING FROM CLOUD DEPLOYED MM/DG servers, with two possible deployment architectures of the MIMB server:
- Local Network: For a Model Bridge Server connected to a local Metadata Management Server via a dedicated open port on the same network where firewall is not an issue. In such case, the Model Bridge server is controlled by the Metadata Management Server in a classic client/server architecture.
- Over the Web (Cloud): For a Model Bridge Server connected to a remote Metadata Management Server over the Web where a secure firewall is in place. In such case, the Model Bridge Server will proactively connect over http on regular basis to a dedicated remote Metadata Management Server for any metadata import/export activities to perform. This is the recommended architecture for Metadata Management Servers hosted on the cloud needing to access local Model Bridge Servers behind a firewall for metadata harvesting purpose.
-
METADATA HARVESTING FROM CLOUD DEPLOYED MM/DG servers, with two possible deployment architectures of the MIMB server:
-
DATA STORES (Flat files, RDBMS, Cloud Databases, Big Data / Hadoop):
-
DATA CATALOGING OF THE DATA LAKE over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), or file servers (POSIX file systems)
- with high level data lake directory inventory import bridges such as:- Amazon S3 (Simple Storage Service) import (beta bridge)
- Apache Hadoop Distributed File System (HDFS Java API) import or (WebHDFS REST API) import (beta bridge)
- Posix (Windows/Linux) File System import (beta bridge)
- Flat File Database (CSV or Excel) import (beta bridge)
- JSON (JavaScript Object Notation) Database Files import
- Apache Avro Database Files (JSON) import
- Apache Parquet Database Files import
-
BIG DATA HADOOP HIVE TECHNOLOGIES (Cloudera, Hortonworks, MapR)
- Apache Hadoop Hive Database (HCatalog via JDBC) import
- Apache Hadoop Hive Database (Web Hcatalog) import
- Apache Hadoop Hive Database (Hive Metastore via JDBC) import (beta bridge)
-
NO SQL TECHNOLOGIES
- MongoDB Database (JSON) import
- Apache CouchDb Database (JSON) import
- MarkLogic NoSQL Database (for JSON only) import
- Apache Cassandra Database import
- DataStax Enterprise (Cassandra) import
-
SQL New Databases
- Actian Vector (Vectorwise) Database Database (via JDBC) import
- HP Vertica Database (via JDBC) import
- Oracle MySQL Database (via JDBC) import
-
SQL Stored Procedures and Functions (major SQL parsing improvements for lineage)
- Microsoft SQL Server Database (via JDBC) import
- Oracle Database (via JDBC) import
- Pivotal GreenPlum Database (via JDBC) import
- PostgreSQL Database (via JDBC) import
- Teradata Database (via JDBC) import
-
SQL Scripts (major SQL parsing improvements for lineage)
- Apache (Cloudera, Hortonworks, MapR) Hadoop HiveQL Script import
- IBM DB2 Universal Database (UDB) SQL Script import (beta bridge)
- Oracle Database SQL Script (PL/SQL) import
- Teradata Database SQL Script (BTEQ) import
-
SQL DDL import major improvements (instead of live JDBC connections) which is better for security reasons and for cloud architectures
- Apache (Cloudera, Hortonworks, MapR) Hadoop HiveQL DDL import
- Oracle Database DDL import
- Teradata Database SQL DDL import
- Other Database SQL DDL import (beta bridge)
-
DATA CATALOGING OF THE DATA LAKE over the cloud (e.g. Amazon S3), on big data clusters (e.g. Hadoop distributions), or file servers (POSIX file systems)
-
DATA INTEGRATION (DI/ETL/ELT):
-
New Bridges:
- Alteryx import (beta bridge)
-
Improved Bridges:
- Informatica PowerCenter import bridge major improvements in performance and memory usage.
- Microsoft SQL Server Integration Services (SSIS) new support for version 2016.
- Talend DI import bridge is now file based instead of API based, includes major improvements for big data, and new support for MDM.
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- IBM Cognos 11 import (for existing Cognos 10 features, plus beta bridge import of the new Cognos 11 Analytics features of Dynamic Cubes and Data Modules)
- Qlik Sense import
- SAP BusinessObjects 4.2 import (for existing BusinessObjects 4.1 features, however new 4.2 only features are not supported yet)
-
Improved Bridges:
- Microstrategy import scalability and performance improvements
- Tableau import bridge major improvement in (1) reducing the number of Tableau Data store connections (Upper/Lower case mix, Default vs specified port, database to various schemas), and (2) parsing the Tableau Init SQL (In Tableau data prep / data integration).
-
New Bridges:
-
DATA MODELING (DM) and Object Modeling:
-
New Bridges:
- erwin Data Modeler 9.7 import/export bridges
- IDERA ER/Studio 2016 import/export bridges
- OMG UML XMI 2.x new export bridge to NoMagic MagicDraw and Sparx Enterprise Architect
- NoMagic MagicDraw new import bridge
-
Improved Bridges:
- Minor improvements in all data modeling bridges
-
New Bridges:
-
METADATA MANAGEMENT (MM) & DATA GOVERNANCE (DG):
-
New Bridges:
- Apache Atlas (for HortonWorks) import
- Cloudera Navigator import (beta bridge)
- IBM Information Governance Catalog (Open IGC) export (Vendor Internal Bridge)
-
New Bridges:
v9.0.2 (GA 06/10/2016 - Deprecated 12/31/2017 - EOL 12/31/2018)
-
GENERAL FEATURES, ARCHITECTURE & METAMODEL CHANGES:
- Updated MIMB Web Services which are now based on RESTful API technology (i.e. therefore removing any security vulnerabilities of the older Axis technology)
- New MIMB Model Change Management SDK allowing to compare the metadata of a newly imported model with a previously imported one in order to detect any change. This new comparison feature enables support for metadata version management to any Metadata Management MM applications based on MIMB for metadata harvesting. Such MM applications can now avoid creating unnecessary new versions of models if the source metadata (e.g. a database, or data model) has not changed since the last automatically scheduled metadata harvesting.
-
DATA STORES (Flat files, RDBMS, Cloud Databases, Big Data / Hadoop):
- Major SQL Parsing improvements, especially in Stored Procedures and SQL scripts
-
New Bridges:
- Amazon Web Services AWS) RedShift Database import
- Apache Cassandra import (including from DataStax Enterprise)
- JSON (JavaScript Object Notation) file import (beta bridge)
- MongoDB import (beta bridge)
- Flat File Database (CSV or Excel) import (beta bridge)
-
Database SQL Script import (beta bridge)
- Teradata Database SQL Script (BTEQ) import (beta bridge)
-
Database SQL DDL import (beta bridge)
- Apache Hadoop HiveQL DDL import (including from Cloudera, Hortonworks, MapR, etc.)
- Oracle Database SQL Script (BTEQ) import (beta bridge)
-
DATA MODELING (DM):
- Minor bug fixes in popular data modeling tool bridges
-
DATA INTEGRATION (DI/ETL/ELT/DQ/MDM/EII):
- Major redesign of all DI/ETL/ELT based upon a more universal DI metamodel which better supports the new generations of DI tools while reducing the volume of metadata. Consequently most DI/ETL/ELT bridges now import much faster (some of them twice as fast), without loosing any DI/ETL/ELT design or data flow lineage details.
-
New Bridges:
- Microsoft SQL Server Integration Services (SSIS) (Repository Database) import bridge
- Microsoft SQL Server Integration Services (SSIS) 2014 import bridge
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
Improved Bridges:
- IBM Cognos Content Manager with PowerPlay Transformer import bridge major improvements to better support lineage for cubes
- MicroStrategy import bridge major improvements for scalability and protection against broken/corrupted reports
- Tableau import bridge major improvements to better support massive amounts of database or file connections (popular in self service BI)
-
Improved Bridges:
v9.0.1 GA (12/15/2015)
v9.0.0 GA (11/23/2015)
-
GENERAL FEATURES, & METAMODEL CHANGES:
-
New 100% Java based MIMB architecture components (including expression parsers, model validation, etc.) allowing support for a variation of Linux/Unix based deployments:
- only for Java based bridges such as the import from JDBC based databases, ERwin XML data models, Talend DI models, Tableau BI models, etc.
- C++ based bridges (in particular the ones depending on the COM API) will remain Windows based such as the import from ERwin native (.erwin) data models, SAP BusinessObjects universes, etc.
-
New 100% Java based MIMB architecture components (including expression parsers, model validation, etc.) allowing support for a variation of Linux/Unix based deployments:
-
RDBMS (JDBC):
-
Improved Bridges:
- IBM DB2 (JDBC) import bridge major improvements
- IBM Netezza (JDBC) import bridge major improvements
- Microsoft SQL Server (JDBC) import bridge major improvements on metadata coverage, expression parsing, triggers, filters and stored procedures
- Oracle (JDBC) import bridge major improvements
- Pivotal GreenPlum (JDBC) import bridge major improvements
- PostgreSQL (JDBC) import bridge major improvements
- SAP Sybase ASE (JDBC) import bridge major improvements
- Teradata (JDBC) import bridge major improvements
-
Improved Bridges:
-
BIG DATA (Apache Hadoop distributions of Cloudera, HortonWorks, MapR, DataStax, Hadapt):
-
New Bridges:
- Hadoop HDFS Java API new import bridge
- Hadoop WebHDFS REST API new import bridge (beta bridge)
-
Improved Bridges:
- Hadoop Hive Metastore import bridge major improvements
- Hadoop Hive Server import bridge major improvements
-
New Bridges:
-
DATA MODELING (DM):
-
Improved Bridges:
- Data Modeling tool support for SQL Server 2014
- CA ERwin 9 Data Modeler import and export bridges support for version 9.64 (64 bits)
- CA ERwin 9 Mart import bridges support for version 9.64 (64 bits)
- Embarcadero ER/Studio Data Architect import and export bridges support for version 11 (64 bits)
- Embarcadero ER/Studio Repository import bridges support for version 11 (64 bits)
-
Improved Bridges:
-
DATA INTEGRATION (DI/ETL/ELT/DQ/MDM/EII):
-
New Bridges:
- Pentaho DI new import bridge (beta bridge)
- Talend MDM new import and export bridge
-
Improved Bridges:
- IBM DataStage import bridge major improvements in scalability (64 bits) for large DI models, and ported to Java
- Informatica PowerCenter import bridge major improvements (in parameter passing, and metadata lineage)
- Microsoft SQL Server Integration Services (SSIS) import bridge minor improvements
- Oracle Data Integrator (ODI) import bridge minor improvements
- Oracle Warehouse Builder (OWB) import bridge minor improvements
- Talend DI import and export bridge major improvements (metadata coverage and data flow lineage)
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- Microstrategy export bridge (no longer in beta)
- QlikView import bridge (no longer in beta)
-
Improved Bridges:
- IBM Cognos import bridge minor improvements, including in performance
- Microsoft SQL Server Analysis Services (SSAS) and Reporting Services (SSRS) import bridge minor improvements
- SAP BusinessObjects import bridge minor improvements
- Tableau import bridge major improvements in metadata coverage
-
New Bridges:
v8.0.3 GA (05/19/2015)
v8.0.2 LA (03/31/2015)
-
DATA STORES (RDBMS, COBOL, XML, Big Data):
-
Improved Bridges:
- Oracle JDBC import minor improvements such as support for external tables
- Database (JDBC) import bridge minor improvements in expression parsing
-
Improved Bridges:
-
DATA MODELING (DM):
-
New Bridges:
- CA ERwin 9 Data Modeler import/export bridges support for version 9.6 including support for extended notes
-
Improved Bridges:
- Data Modeling tool support for SQL Server 2014
-
New Bridges:
-
DATA INTEGRATION (DI/ETL):
-
Improved Bridges:
- Informatica PowerCenter import bridge major improvements in scalability (64 bits) for large DI models, and ported to Java
- Microsoft SQL Server Integration Services (SSIS) import bridge major improvements including support for SSIS 2012
- Oracle Data Integrator (ODI) import bridge ridges major improvements to better support flat files
- Oracle Warehouse Builder (OWB) import bridge major improvements to better support cubes
- Talend import and export bridge major improvements improving metadata coverage and lineage
-
Improved Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
Improved Bridges:
- Microsoft SQL Server Analysis Services (SSAS) and Reporting Services (SSRS) import bridge major improvements including support for SSAS/SSRS 2012
- Tableau import bridge major improvements in metadata coverage
-
Improved Bridges:
-
GENERAL FEATURES, & METAMODEL CHANGES:
- Java 8 (compiled with backward compatibility with Java 7) compliance of MIMB (Java 6 is no longer supported)
v8.0.1 (12/02/2014)
-
DATA STORES (RDBMS, COBOL, XML, Big Data):
-
New Bridges:
- Oracle 12c Database
- Pivotal Greenplum Database
- PostgreSQL Database
-
Improved Bridges:
- Improved Expression parsing in many Database Import Bridges
- Support for external database based views in many Database Import Bridges
- Support for user supplied JDBC driver on many Database Import Bridges
-
New Bridges:
-
DATA MODELING (DM):
-
New Bridges:
- CA ERwin 9 Data Modeler import/export (Beta) bridges support for version 9.6
- Embarcadero ER/Studio Data Modeler import/export bridges support for version 10
- Oracle SQL Server Data Modeler Import Bridge
-
Improved Bridges:
- CA ERwin 8 and 9 Data Modeler import bridges ported to 64 bits java to support very large ERwin data models
- Oracle Designer Import Bridge improvements on logical/physical separation, and other minor improvements
-
New Bridges:
-
DATA INTEGRATION (DI/ETL):
-
New Bridges:
- Microsoft SQL Server 2012 Integration Services (SSIS) Import Bridges
- Apache Hadoop HiveQL Scripts Import (Beta) Bridge
- Microsoft SQL Scripts Import (Beta) Bridge
- Oracle SQL Scripts Import (Beta) Bridge
- IBM InfoSphere Metadata Workbench Extension Mappings Export (Beta) Bridge
-
Improved Bridges:
- Informatica PowerCenter Import Bridge improvements, including repository multimodel incremental harvesting
- Informatica PowerCenter Export Bridge improvements, including forward engineering of mapping design and query conversions
- Oracle Data Integrator Import Bridge multiple improvements and new profile
- Talend Import Bridge improvements, including use as ELT
- Talend Export Bridge improvements, including forward engineering of mapping design and query conversions
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- Microsoft SQL Server 2012 Analysis Services (SSAS) and Reporting Services (SSRS) Import Bridges
- QlikTech QlikView Import (beta) Bridge
- SAP BusinessObjects Information Design Tool Export Bridge
-
Improved Bridges:
- MicroStrategy Import Bridge various improvements and redesigned profile
- SAP BusinessObjects all Import/Export Bridge improvements to support for Windows Active Directory (AD) Authentication
- SAP BusinessObjects 14.x Universe Design Tool Import/Export Bridge improvements to support a tree of connection folders
- SAP BusinessObjects 14.x WebIntelligence Import Bridge improvements to support the report page layout
- Tableau Import Bridge ported to Java with major improvements
-
New Bridges:
-
METADATA MANAGEMENT (MM):
-
New Bridges:
- IBM InfoSphere Metadata Workbench Extension Mappings Export (Beta) Bridge
-
New Bridges:
-
GENERAL FEATURES, & METAMODEL CHANGES:
- Meta Integration Profiling Export Bridge improvements with redesigned for smaller memory footprint, and separated partner sdk jar file
v7.2 (11/01/2013)
-
DATA STORES (RDBMS, COBOL, XML, Big Data):
-
New Bridges:
-
[BIG DATA] Apache Hadoop Hive "Native" Import bridges including from:
- Cloudera Enterprise
- Cloudera Impala
- DataStax Enterprise
- Hadapt
- Hortonworks
- MapR
- [BIG DATA] Google BigQuery (beta bridge)
-
[BIG DATA] Apache Hadoop Hive "Native" Import bridges including from:
-
Improved Bridges:
- Microsoft SQL Server JDBC import bridge support for SQL Server 2012
- Improved PK/FK support in Sybase JDBC import bridge
-
New Bridges:
-
DATA MODELING (DM):
-
New Bridges:
- SAP Sybase PowerDesigner LDM (version 15 and 16) import bridge
-
Improved Bridges:
- CA ERwin 9 Data Modeler import/export bridges support for version 9.5
- Embarcadero ER/Studio Data Architect import/export bridges support for version 9.6
-
IBM InfoSphere Data Architect:
- Import bridge support for Domain Model (DDM) definitions
- Export bridge improvement to diagramming of generalizations
- Added support for the generate flag for some data modeling tools
-
Diagram migration improvements among some data modeling tools
- Relationship layout
- Connector lines
-
Reverse engineering of Business Intelligence (BI) designs
- Document each table and column with business names and descriptions retrieved from logical metadata layers in the BI model.
- Infer Foreign Key relationships between database tables by examining the BI model's SQL joins.
-
Improvements in diagramming support in data modeling import bridges.
- Entity auto-size
- Diagram display options
- Entity and relationship fonts and colors
-
New Bridges:
-
DATA INTEGRATION (DI/ETL):
-
New Bridges:
- Oracle Data Integrator (ODI) 11g import/export (beta) bridges
- Talend Data Integration v5.x import/export (beta) bridges
-
Improved Bridges:
- Microsoft SQL Server SSIS import bridge support for SQL Server 2012
- Informatica PowerCenter import bridge Support for TIBCO data sources
- ETL Post-processor optimization
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- Tableau Software v7 Server & Desktop import (GA) bridge and export (beta) bridge
-
Improved Bridges:
- SAP BusinessObjects XI import/export bridges support for version R4.0 SP6 to R4.1
- SAP BusinessObjects Designer import bridge: support for @DerivedTable function
- MicroStrategy import bridges: improved support for Logical Tables based on SQL queries
-
New Bridges:
-
GENERAL FEATURES, & METAMODEL CHANGES:
- Microsoft SQL Server support for Varchar(max)
v7.1 (04/05/2013)
-
DATA MODELING (DM):
-
New Bridges:
- CA ERwin 9.1 and 9.2 Data Modeler import/export bridges
- Embarcadero ER/Studio 9.5 import/export bridges
- IBM InfoSphere Data Architect (IDA) 9.1 import/export bridges
-
Improved Bridges:
- CA ERwin 9.x Mart import bridges (now supports root models)
- CA ERwin 7.x, 8.x, 9.x Data modeling import bridges (role and relationship names)
- Microsoft Office Excel import/export bridges for Data Model Reporting / Data Store Documentation (redesigned and reimplemented in Java for better scalability
- Generic JDBC Database import bridge (numerous improvements to support more databases like Netezza)
-
"High Fidelity" Diagram details:
(such as object positions and sizes, entity auto-size, entity display levels, entity fonts, attribute datatype alignments, other shapes and additional documentation on the diagram, and separation of Logical and Physical Diagrams)- CA ERwin 7.x, 8.x and 9.x import bridges
- Embarcadero ER/Studio (all versions) import bridges
- IBM InfoSphere Data Architect (IDA) (all versions) import bridges
-
Data Modeling Tool Profile (metamodel) redesign to better reflect the original tool's metamodel / UI:
- CA ERwin 7.x, 8.x and 9.x import bridges
- Embarcadero ER/Studio (all versions) import bridges
- Numerous expression parsing improvements to extract more data flow lineage
-
New Bridges:
-
DATA INTEGRATION (DI/ETL):
-
New Bridges:
- Microsoft SQL Server 2012 Integration Services (SSIS) import bridge
- Oracle Data Integrator (ODI) 11g import/export bridges (beta bridges)
- Talend Data Integration v5.x import/export bridges (beta bridge)
-
Improved Bridges:
- IBM DataStage import bridge (now supports parallel jobs)
- Microsoft Office Excel import/export bridges for DI/ETL Mapping Specifications (redesigned and reimplemented in Java for better scalability
- Microsoft SQL Server Integration Services (SSIS) (now supports calculated columns)
- Microstrategy BI import bridges (now provide more detailed lineage, and supports more metadata such as aliases for attributes, metrics, consolidations and custom groups)
-
Separation of data flow and control flow
- Data flow (actual movement of data)
- Control flow (conditions and filters)
. Column Control (which directly impacts values)
. Row Control (which does not directly impact values such as filters)
as systematic post-processing of all DI/ETL import bridges. - Manage circular ETL processing (workflow loops) for proper data flow lineage and ETL summary.
- Numerous expression parsing improvements to extract more data flow lineage
-
New Bridges:
-
BUSINESS INTELLIGENCE (BI/OLAP):
-
New Bridges:
- IBM Cognos 10.2
- Tableau Software v7 Server & Desktop import bridge (beta bridge)
-
Improved Bridges:
- Oracle Business Intelligence (OBIEE) import bridge (redesigned)
- SAP BusinessObjects XI R4.0 SP6 Webi Report import bridge (GA)
- Numerous expression parsing improvements to extract more data flow lineage
-
New Bridges:
-
BUSINESS APPLICATIONS:
-
New Bridges:
- Oracle Business Intelligence Data Warehouse Administration Console (DAC) Import bridge (alpha bridge)
-
Improved Bridges:
- SAP ERP Central Component (ECC), previously called R/3, import bridge (beta bridge)
- SAP NetWeaver Business Warehouse (BW) import bridge (beta bridge)
-
New Bridges:
v7.0.4 (RC 09/15/2012 > LA 10/05/2012 > GA 10/12/2012)
-
NEW BRIDGES:
- CA ERwin v9 import/export bridges
- Composite Studio export bridge (beta bridge)
- Informatica PowerCenter 9.5 import/export bridges
- Oracle Data Integration 11g import/export bridges (beta bridge)
- SAP ERP Central Component (ECC), previously called R/3, import bridge (beta bridge)
- SAP NetWeaver Business Warehouse (BW) import bridge (beta bridge)
- SAS Business Intelligence import bridges (beta bridge)
- Talend Data Integration v4.x import/export bridges (beta bridge)
- SAP Master Data Management (MDM) v7.1 (beta bridge)
-
MAJOR BRIDGE IMPROVEMENTS:
-
Optimized metadata harvesting from large BI Repositories by:
(a) reducing the window of actual metadata harvesting up front (without processing each report as soon as it is harvested)
(b) accelerating the post processing of the harvested metadata using multi-thread parallel processing of the reports
for the following BI tools:- IBM Cognos repository import bridge
- Oracle Business Intelligence (OBIEE) repository import bridge
- SAP BusinessObjects XI repository import bridge
-
Optimized metadata harvesting from large BI Repositories by:
v7.0.3 (RC 03/31/2012 > LA 04/30/2012 > GA 05/31/2012)
-
VERSION PURPOSE, GENERAL FEATURES, & METAMODEL CHANGES:
- Business Intelligence (BI) improved report lineage details (both the bridge and the metadata profiles have been enhanced) for IBM Cognos, Oracle OBIEE, Microsoft SSAS/SSRS, MicroStrategy, SAP BusinessObjects)
- Data Integration (DI/ETL) improved linage for IBM DataStage, Informatica PowerCenter, Microsoft SSIS, Oracle OWB and ODIEE, SAP BusinessObjects DI
-
NEW BRIDGES:
- Embarcadero ER/Studio Repository (version 1.6) import bridge
- IBM Cognos 10.1
- IBM Cognos PowerPlay Transformer import bridge
- SAP NetWeaver Business Warehouse (BW) import bridge (beta bridge)
- Talend Data Integration v4.x import/export bridges (beta bridges)
-
MAJOR BRIDGE IMPROVEMENTS:
- CA Gen import/export bridges now support v8.0
- Embarcadero ER/Studio bridges now imports data warehouse lineage
- IBM InfoSphere Data Architect (IDA) import/export bridges now support v8.1
- IBM Cognos ReportStudio import bridge has been improved to support reports on PowerPlay cubes
- Microsoft Excel major improvements to support datatype on attribute/column constraints, and new ETL/DI lineage summary
- Microstrategy support for multi-project at once (or subsetting), and support for new version 9.2.1
- Sybase PowerDesigner support for new version 16
-
DEPRICATED BRIDGES:
- SAP BusinessObjects 5.x (from 5.0.0 in 1999 to 5.1.9 in 2004, no longer supported by SAP BusinessObjects)
- HP KnightBridge CDMA (Codes and Data Mapping Application) which was a special project (did not get support)
v7.0.2 GA (1/4/2012)
-
VERSION PURPOSE, GENERAL FEATURES, & METAMODEL CHANGES:
- Version to be used by partners other than data modeling tool vendors
-
Complete re-design and enhancement of ETL/DI metadata modeling and extraction including:
- Implementation using multimodel concept, avoiding model size constraints
- Summary lineage
-
NEW BRIDGES:
- IBM Cognos PowerPlay Transformer import bridge (beta bridge, not supported)
- SAP NetWeaver Business Warehouse (BW) import bridge (beta bridge, not supported)
- Talend Data Integration v4.x import/export bridges (beta bridge, not supported)
-
MAJOR BRIDGE IMPROVEMENTS:
- CA ERwin import bridge support Data Source Definition and Data Mapping Rules
- Embarcadero ER/Studio import bridge support for multimodel and Data Movement Properties
v7.0.1 GA (10/6/2011)
-
MIMB GENERAL FEATURES:
- UPDATE: MIMB now requires java version 1.6 at the minimum. Java version 1.5 is no longer supported.
-
NEW BRIDGES:
- Oracle Data Integrator (ODI) 11g import bridge (new Java API based architecture). This is a brand new bridge based on the new ODI metadata interface only available in ODI 11g. Therefore, MIMB 7.x only supports ODI 11g or newer versions, and no longer support ODI 9i and 10g based on their older deprecated metadata interface which was used by the MIMB 6.x ODI bridges.
- Oracle Warehouse Builder (OWB) 11.2 import/export bridge (new API architecture for 11.2 different from 11.1)
- IBM Cognos PowerPlay Transformer import bridge (beta bridge, not supported)
- SAP Master Data Management (MDM) v7.1 import/export bridges (beta bridge, not supported)
- SAP Business Information Warehouse (BW) import bridge (beta bridge, not supported)
- Talend Data Integration v4.x import/export bridges (beta bridge, not supported)
v7.0.0 LA (5/6/2011)
Limited Availability (LA) to OEM Partners for their metadata import/export of Data Modeling and design tools
(Note that version 7.0 was initially labeled as version 6.3, with Beta Early Access for OEM partners on 3/31/2011)
-
VERSION PURPOSE, GENERAL FEATURES, & METAMODEL CHANGES:
-
Data Integration (DI/ETL) improved detailed metadata coverage & lineage:
- support for DI/ETL design metadata vs. operational/runtime metadata
- support for Data Flow vs. Control Flow, and Semantic Flow for transformation reuse
- new metamodel and fully redesigned import bridges from all major DI/ETL tools
- export DI/ETL bridges are limited to source/target data stores
- Metadata Cache Driven Incremental Metadata Harvesting for High Performance & Scalability
-
Data Integration (DI/ETL) improved detailed metadata coverage & lineage:
-
NEW BRIDGES:
- IBM Cognos version 10.1 import bridge
- Oracle Business Intelligence (OBIEE) 11g XML import bridge
- SAP Business Intelligence Warehouse (BW) import bridge (Beta, not supported)
- SyncSort DMExpress export bridge
-
BRIDGES DEFERRED TO SERVICE PACK:
- IBM DataStage export bridge
- Microsoft SQL Server Integration Services (SSIS) export bridge
- Oracle Warehouse Builder (OWB) import and export bridge
- Oracle Data Integrator (ODI) import and export bridges
- SAP BusinessObjects Data Integrator (BODI) export bridge
-
MAJOR BRIDGE IMPROVEMENTS:
-
Business Intelligence (BI) Reporting tools improved representation of report graphical items (lists, crosstab, charts)
- SAP BusinessObjects Web Intelligence Report import bridge (to be confirmed)
- SAP BusinessObjects Desktop Intelligence Report import bridge (to be confirmed)
- SAP BusinessObjects Crystal Report import bridge (to be confirmed)
-
Repository based Data Integration (DI/ETL) multi model harvesting optimized for performance (incremental harvesting) and robustness (failure/restart) using a persistent cache of files on disk:
- IBM InfoSphere DataStage import bridge (to be confirmed)
- Informatica PowerCenter import bridge (to be confirmed)
- Metadata Mapping and Business Rules Requirements with Microsoft Excel import bridge (to be confirmed)
- Microsoft SQL Server Integration Services (SSIS) import bridge (to be confirmed)
- Oracle Data Integrator (ODIEE) import bridge (to be confirmed)
- Oracle Warehouse Builder (OWB) import bridge (to be confirmed)
- SAP BusinessObjects Data Integrator (BODI) import bridge (to be confirmed)
-
Repository based Business Intelligence (BI) and Data Modeling (DM) multi model harvesting optimized for performance (incremental harvesting) and robustness (failure/restart) using a persistent cache of files on disk:
- MicroStrategy import bridge (to be confirmed)
-
Redesigned architecture of COM/OLE api based bridges to support multiple tool versions with only one bridge library (DLL):
- MicroStrategy import and export bridges (to be confirmed)
-
Business Intelligence (BI) Reporting tools improved representation of report graphical items (lists, crosstab, charts)
v6.2 (10/15/2010)
-
VERSION PURPOSE, GENERAL FEATURES, & METAMODEL CHANGES:
- multimodel Stitching Technology (Rule based) for version and configuration management
- Semantic Mappings (in addition to Data Flow Mapping)
- changed compilation system from VisualStudio 2005 to VisualStudio 2010 (no longer using manifests)
- changed compilation system to use Xerces 3.1 and ICU 4.4
-
NEW BRIDGES:
- CA ERwin 8.0 import and export bridges (beta bridges)
- IBM Cognos 10.1
- IBM InfoSphere Discovery (previously Exeros) import bridge: initial support for version 4.x
-
MAJOR BRIDGE IMPROVEMENTS:
-
Business Intelligence (BI) Reporting tools improved representation of report graphical items (lists, crosstab, charts)
- IBM Cognos 8 ReportStudio import bridge
-
Repository based Business Intelligence (BI) and Data Modeling (DM) multi model harvesting optimized for performance (incremental harvesting) and robustness (failure/restart) using a persistent cache of files on disk:
- CA ERwin 7 ModelManager import bridge
- IBM Cognos 8 Content Manager import bridge
- Oracle Business Intelligence (OBIEE) import bridge
- SAP BusinessObjects Repository import bridge
-
Redesigned architecture of COM/OLE api based bridges to support multiple tool versions with only one bridge library (DLL):
- SAP BusinessObjects Designer import and export bridges (support recent service packs 11.5 SP5, SP6 and 12.1 SP2, SP3)
- SAP BusinessObjects Desktop Intelligence import bridge
- IBM Rational System Architect (Telelogic/Popkin SA) import and export bridges
- IBM Cognos series 7 Impromptu import bridge
- Changed metadata consistency validation to check for objects nativeId uniqueness. Bridges have been updated so that only unique nativeIds are imported.
-
Business Intelligence (BI) Reporting tools improved representation of report graphical items (lists, crosstab, charts)
-
OTHER UPDATED BRIDGES
-
CA ERwin 7 import bridge:
- added support for the relationships 'generate' flag
- now warning about domains with enumerated list of values and non-string datatype
-
CA ERwin 7 ModelManager import bridge:
- added support for incremental harvesting, using date filter parameter
- now support 'Model Source' dependencies between models stored in Model Manager, using semantic mappings
-
CA Gen import bridge:
- now avoid importing empty indexes
- fixed bug with duplicated StorageGroups when the model has multiple databases
- CA Gen export bridge: now checking if the output directory is not .ief extension
- CA Terrain for DB2 import bridge: fixed unnecessary renaming issue, for tables with same name but in different schemas
- Cobol Copybook import bridge: added support for the Occurs clause, no longer use generalizations
- Embarcadero ER/Studio import bridge: added support for the relationships 'generate' flag
-
Embarcadero ER/Studio export bridge:
- added support for the relationships 'generate' flag
- fixed export of relationships UDPs
- IBM Cognos Impromptu import bridge: removed 'Version' parameter
-
IBM Cognos 8 ReportStudio import bridge:
- improved support for prompt parameters and their lineage to source queries
- added support for report DrillThrough information
-
IBM Information Server export bridges:
- removed parameter 'Import Dimensional Objects'
- added support for BI Folders
- IBM Infosphere DataStage import bridge: now imports metadata as multimodel
-
IBM Infosphere Data Architect import and export bridges:
- fixed bug on LDM relationships referential integrity constraints
- fixed support for DB2 columns SYSTEM_DEFAULT value
- display a warning when unknown domains are found in an LDM file
- improved dimensional modeling support for version 7.5.3
- added support for LDM AlternateKeys and InversionEntries index transform option
- now setting a default size to diagram symbols, when their size cannot be detected from the file
- fixed bug importing LDM attributes and relationships persistent property
- avoid creating unnecessary LDM packages
- handle LDM entities with duplicated attributes with same name
-
IBM Rational System Architect (Telelogic/Popkin SA) import bridge:
- fixed buffer overrun bug when importing some foreign keys
- improved detection and handling of duplicated generalizations between 2 entities
- removed 'Version' parameter
- added support for diagram graphical shapes and their text comments
- IBM Rational System Architect (Telelogic/Popkin SA) export bridge: removed 'Version' parameter
- Informatica Developer 9 import and export bridges: support for latest version 9.0.2
-
Informatica PowerCenter import bridge:
- multimodel ETL support
- Improved connection name detection for custom SQL based readers and lookups.
-
JDBC/ODBC import bridges:
- removed unused parameters
- improved support for using SQL Server dynamic ports, updated parameters documentation
- fixed bug importing long names for SQL Server and Sybase
- optimized code importing Oracle indexes
- Kalido DIW import bridge: minor bug fixes
- Microsoft ODBO / ADOMD import bridge: fixed bug for SAP BW with unnamed OLAP Catalog
-
Microsoft Excel import and export bridges:
- the bridges no longer support the older XLS format natively, newer XLSX and XLSM formats (Excel 2007) are still supported
- added multimodel support
- Microsoft SQL Server Analysis Services import bridge: now represent relationships between measure groups and dimensions as joins
- Microsoft SQL Server Analysis Services export bridge: fixed bugs generating cubes from Kalido DIW
-
Microsoft SQL Server Integration Services import bridge:
- added support for flat file as destination
- added support for stored procedures
- various improvements to SQL syntax and expression parsing
- now skipping disabled sequence container
- added support for parameters
-
Microsoft SQL Server Reporting Services import bridge:
- added support for stored procedures
- added support for @PARAM parameters
-
MicroStrategy import bridge:
- improved detection of the project default database instance
- fixed bug, the reports' metrics lineage was not imported correctly
- avoid OutOfMemory errors on large projects, by subsetting amount of reports using an environment variable
- OMG UML 2 XMI import bridge: various bug fixes and improvements, updated tooltip for Visual Paradigm tool
- Oracle Warehouse Builder (OWB) import bridge: added support for external tables, minor bug fixes
-
SAP BusinessObjects CrystalReports import bridge:
- now testing the status of RAS server(s)
- now setting the "ras.config" environment variable, to allow using the clientSDKOptions.XML file
- improved expression parser to support SQL queries using crystal prompts parameters
- improved support for prompt parameters
- SAP BusinessObjects Data Integrator import bridge: various improvements to support ETL transformations metadata
- SAP BusinessObjects Data Integrator export bridge: fixed bug exporting Cobol copybook metadata
-
SAP BusinessObjects Designer import bridge:
- added warning log messages when the universe contains broken expressions
- removed 'Version' parameter
- no longer use the universe default owner schema for tables with no schema specified, because it is not reliable
- source tables only detected as side effect of expression parsing are now stored in separate package
-
SAP BusinessObjects Designer export bridge:
- improved log messages
- now export objects sorted by name
- removed 'Version' parameter
- fixed bug related to processing of 'detail' objects
- SAP BusinessObjects Desktop Intelligence import bridge: removed 'Version' parameter
- SAP BusinessObjects WebIntelligence import bridge: now testing the status of Webi server(s)
-
SAP BusinessObjects Repository import bridge:
- added warning log messages when core universe has been updated more recently than derived universe
- fixed bug when selecting/subsetting by folders
- fixed bug when only the Crystal Reports software is installed, not the BusinessObjects client
- Sybase PowerDesigner CDM import bridge: improved support for UDPs (Extended Attributes)
-
Sybase PowerDesigner PDM import bridge:
- improved support for UDPs (Extended Attributes)
- improved support for attributes position in keys, using an artificial associated index
- Sybase PowerDesigner PDM export bridge: minor bug fixes
-
CA ERwin 7 import bridge:
v6.1.0 (05/14/2010)
-
VERSION PURPOSE, GENERAL FEATURES, & METAMODEL CHANGES:
-
NEW: Meta Integration Repository (MIR) Metamodel Enhancements:
- New metamodel support for Business Glossary Terms as used in naming standards and data dictionaries.
-
New namespace management for both logical and physical objects based on unique identifiers built upon a unique path to that object.
Uniquely identifying objects in a Model is key for:
- incremental harvesting with automatic stitching of new or updated models back to their big multimodel sources (especially from large BI environments)
- metadata lineage call backs (especially from BI reports)
- Enhanced data flow lineage with support for both actual data flow and conditional flow
- ClassifierMaps are now stored in most cases in their destination classifier
-
NEW: Standardized datatype Mappings for all bridges
- All datatype Mappings are saved in XML files (within the configuration directory) which are dynamically read by all import and export bridges
- The datatype Mapping Specifications provide the supported database or data store technologies, their supported versions, their supported datatypes, and finally on the actual datatype mapping implemented by the import or export bridge. The datatype Mapping Specifications are published at: http://metaintegration.com/Products/MIMB/MIRdatatypeMapping.html .
- datatype Mapping Limitations are published in Known Limitations
-
IMPROVED: multimodel Import Bridges with support for Incremental Metadata Harvesting
- Import bridges can be used for metadata harvesting into the repository of a Metadata Management (MM) solution. The metadata to be harvested can be very large, especially from Business Intelligence (BI) environments which may contain thousands of reports. Consequently some import bridges are implemented as a "Multi Model" bridge managing the large amount of metadata in multiple Model files. This approach also allows for incremental harvesting where the import bridge can check what has changed since the last import date, and return an updated "table of contents" indicating which models have been added, modified or deleted and import only the new or updated models.
- Improved multimodel Import Bridges from BI Tools with better support for BI Connections
- New multimodel Import Bridges from DI/ETL Tools
- Multimodel Import Bridge Limitations are published in Known Limitations
-
IMPROVED: Transformation Expression Parsers for more accurate linage:
-
Improved SQL expression parser, to better detect lineage of Views, ETL and BI tools metadata:
- support for INSERT, DELETE and UPDATE statements
- support for WITH and PIVOT tokens
- Improved lineage from all DI/ETL like Informatica PowerCenter, IBM DataStage, etc.
- Improved lineage from all BI tools IBM Cognos, SAP BusinessObjects, etc.
- Expression Parser Limitations are published in Known Limitations
-
Improved SQL expression parser, to better detect lineage of Views, ETL and BI tools metadata:
- IMPROVED: Model Validation (e.g. now checking there are no 2 features with the same physical name in a classifier)
- IMPROVED: User Defined Properties (UDP) processing for export bridges without UDP capabilities using the option "Append UDPs to description" (e.g. export bridges like XML XSD)
- IMPROVED: InstallShield (to work better on both Windows 32 bit and 64 bit operating systems)
-
NEW: Meta Integration Repository (MIR) Metamodel Enhancements:
-
MIMB SUPPORTED TOOLS:
- NEW: Initiate MDM import bridge (unsupported beta bridge prototype)
- NEW: Meta Integration BusinessRules export bridge: generates business rules mappings as Java or PL/SQL
- NEW: Meta Integration Glossary export bridge: generates a glossary model from any data or object model
- NEW: Meta Integration Repository import and export bridges: allow reading and writing models from repository
- UPDATE: CA ERwin 7 Model Manager import bridges: now displaying detailed error messages from ERwin in the log
- UPDATE: CA ERwin 7 import bridge: added new parameter value and algorithm to import subject areas as packages, and dispatch entities in the package they belong to
-
UPDATE: CA ERwin 4 and 7 export bridges:
- improved export of relationships source direction
- removed export parameter 'Design level' value 'Auto detect', as 'Logical and Physical' is a better default behavior for ERwin.
-
UPDATE: CA Gen import and export bridges:
- added support for the attributes Derived property
- added support for entity, relationships persistence property
- fixed bug with CHAR datatype with scale>0
- now skipping empty entry points (indexes)
- fixed bug with duplicated StorageGroups
-
UPDATE: Embarcadero ER/Studio import bridge:
- removed 'All models' import option
- now skipping tables on which a denormalization mapping was applied (vertical, or horizontal split), as they are no longer part of the model
- added workaround for ER/Studio column name unicity bug
- UPDATE: Embarcadero ER/Studio export bridge: added support for DM1 file format version 8.5
-
UPDATE: IBM Cognos Repository import bridge:
- better support and recovery from models which fail metadata validation
- fixed NullPointerException bug, now properly escaping search path with ';' character in object name
- improved processing of reports which depend on old model versions that are no longer available
- added new execution performance statistics messages in the log
- added import of connections
- renamed the root 'Public Folders' object
- improved profile
-
UPDATE: IBM Cognos Framework Manager import bridge:
- fixed bug importing namespaces and folders
- handle objects with ] character in their name
- UPDATE: IBM Cognos Framework Manager export bridge: improved 3-layers namespace structure generation
-
UPDATE: IBM Cognos ReportStudio import bridge:
- various improvements to expression parser
- added minimal support for MDX queries
- fixed name unicity bug with report variables
- fixed validation issue on report item with no expression
-
UPDATE: IBM InfoSphere Data Architect import and export bridges:
- added support for database sequences and their identity properties
- added support for upcoming version 7.5.3 and new Dimensional Modeling capability
- now setting the file version in LDM, DBM generated files for upcoming version 7.5.3
- fixed support for entity, relationships persistence property
- added support for improved DB2 model in upcoming version 7.5.3, with ZSeriesColumn, ZSeriesDistinctUserDefinedType
- fixed support for DistinctUserDefinedTypes
- various datatype improvements
- fixed export of generalizations as DBM foreign keys
- changed name and label mapping, abbreviation is not used anymore
- fixed bug when importing Oracle Synonyms
-
UPDATE: IBM Information Server import and export bridges:
- updated code for version 8.5
- added new bridge parameters to override database, schema information
- enhanced bridges to better connect matching keys and indexes
- UPDATE: IBM Rational Rose import bridges: improved import of relationships source direction
-
UPDATE: Informatica 9 Developer import and export bridges:
- improved metadata conversion and coverage
- the bridge can now run with a deployed Developer tool installation
-
UPDATE: Informatica PowerCenter import and export bridges:
- improved support for aggregator transformation
- improved processing of mapplets and variables
- added support for instance custom SQL overwrite
-
UPDATE: Informatica PowerCenter repository import bridge:
- updated description for User parameter
- fixed code page issue when browsing
-
UPDATE: JDBC import bridges:
- removed Catalog option from all JDBC bridges
- improved Catalog and Schema browsing, test functionality
- replaced Teradata "URL" parameter by "Host" parameter
-
UPDATE: Microsoft Excel import and export bridges:
- standardized export to produce a common Standard default format for all spreadsheets. The Format parameter has been removed
-
Enhanced the Standard format to version 2.1, to include:
- A "Subject Area" column on the Models type worksheet to allowing for quick reporting/sorting by subject area.
- The boolean LogicalOnly column for tables and columns was replaced with 'Design Level', with values: Logical, Physical and Logical/Physical
-
Enhanced the Excel Metadata AddIn to include:
- fixed bug with Japanese XLSX file, improved support for multi byte file names
- fixed bug unzipping XLSX files
- Worksheet references to already defined elements with a combo-box prompt of valid choices has been extended to all worksheets and all appropriate columns
- Extended the number of databases and technologies supported and related datatypes supported for prompted selection and validation
- Unused worksheets are now hidden upon opening a spreadsheet for the first time
- Inserting a new worksheet now displays the minimum required columns by default
- The Format command freezes the top 3 heading lines of each worksheet
- Enhanced consistency validation requirements so that top-level package names may no longer conflict with database catalog, schema names
- Added documentation of AddIn error messages
- Quick formatting of reusable transformation rules into simple matrix of conditions and results
-
UPDATE: Microsoft SQL Server Integration Services import bridge:
- improved lineage, support for multi cast, conditional split
- improved expression parser to better support UPDATE, DELETE statements
-
UPDATE: MicroStrategy import bridges:
- re-enabled import bridges
- improved handling of deeply nested expressions to avoid StackOverflow
- added support for objects creation and modification date
- added minimal support for Cube reports in version 9.0
- added workaround for project with corrupted metadata
- UPDATE: MicroStrategy export bridges: removed unused parameters
- UPDATE: OMG UML 2 import bridge: various improvements to better support Enumerations, PrimitiveTypes, GeneralizationSet, InterfaceRealization
- UPDATE: Oracle BI EE import bridge: improved tooltip
-
UPDATE: Oracle BI Server import bridge:
- improved tooltip
- fixed bug parsing UDML of physical tables
- UPDATE: Oracle BI Answers import bridge: added support for presentation variables expression syntax
- UPDATE: Oracle DataIntegrator import bridge: fixed bug on foreign keys
- UPDATE: Oracle DataIntegrator export bridge: minor improvements
- UPDATE: SAP BusinessObjects CrystalReports import bridge: improved support for XML queries
-
UPDATE: SAP BusinessObjects DataIntegrator import and export bridges:
- improved support for joiner, expression, filter, lookup, aggregator transformations
- various other improvements
-
UPDATE: SAP BusinessObjects Designer import and export bridges:
- added version auto-detection capability
- fixed crash related to database owners and qualifiers (schemas and catalogs)
- various improvements to expression parser
- handle issue of unnamed classes and objects (objects not found in linked universes)
- fixed bug with tables and columns name case-sensitivity
- allow exporting object names longer than 35 characters since versions 12.0
-
UPDATE: SAP BusinessObjects Repository import bridge:
- improved tool-tip
- added import of connections
- added import of universes, reports owner/author information
- relaxed version conflict detection for BO Repository 5.x and 6.x
- UPDATE: Sybase PowerDesigner 6 import bridge: now connecting tables, views to a default schema
-
UPDATE: Sybase PowerDesigner CDM and PDM import bridges:
- fixed RTF text decoder support for international characters
- now printing warning for external file dependencies
- fixed bug on UDP values with carriage returns
- added support for reusable Default objects
- improved support for PDM OLAP metadata in version 15, dispatch Cubes, Dimension in sub packages to avoid namespace conflicts
- REMOVED: Composite Studio (MIR XMI alias) bridges (terminated OEM agreement)
- REMOVED: SypherLink bridges (terminated OEM agreement)
v6.0.6 (12/04/2009)
-
MIMB SUPPORTED TOOLS:
- UPDATE: fixed compatibility problem with Microsoft Windows 2000
-
UPDATE: improved some file-based import bridges, now displaying the file path in the log in case of invalid file format:
- CA ERwin 4 and 7
- Hyperion Essbase Integration Services
- IBM Db2 Cube Views
- IBM Rational Rose
- Oracle BI Answers
- Oracle BI Server
- SAP BusinessObjects DataIntegrator
- UPDATE: CA ERwin 4 and 7 import bridges: fixed bug on attributes nullable property
- UPDATE: CA ERwin 7 import bridge: fixed bug when there are multiple schemas with the same name
- UPDATE: CA ERwin 7 import and export bridges: added support for Teradata 12
- UPDATE: IBM Cognos Framework Manager import bridge: improved import of namespace and folder structure
-
UPDATE: IBM Cognos Repository import bridge:
- fixed bug specific to cognos 8.4 web service api
- fixed bug retrieving shortcuts
- now shipping native cognos sdk libraries
- removed bridge parameter allowing user to control which sdk the bridge should use.
- removed unnecessary bridge parameters, and renamed login parameters for simplicity
- removed cognos version auto detection based on gateway URL, as it was too difficult to configure
- improved repository structure browsing, added retry functionality for enhanced reliability
- improved log error messages, displaying simplified cognos error text
- now avoiding import of old model versions which are not used by any reports
- UPDATE: IBM IS export bridge: fixed bug on multimodel bridges
- UPDATE: IBM Rational Rose import bridges: improved defensive tests to avoid loading invalid files
-
UPDATE: Informatica PowerCenter import bridge:
- improved support for variables
- added support for SAP sources
-
-
UPDATE: Microsoft Excel import and export bridges:
-
General Enhancements and Updates
- Excel "Metadata" Add-In based Toolbar support for Formatting (smart column width update) of any worksheet on demand (button) or automatic (on open of newly generated Excel spreadsheet)
- Support for logical and physical UDP distinction, as well as datatypes for UDPs
- Support for nearly unlimited length spreadsheets in the XLSX format
- Improved support for Office 2003 with Add-In
-
For Data Modeling / Data Dictionary purposes:
- Excel "Metadata" Toolbar support for Annotation on Models, Packages, Domains, Enumerations and Relationships
- Various improvements for data modeling tools round trip conversions
- Excel "Metadata" Add-In based Toolbar support for cell comment based annotation of cells on the packages, domains and enumerations type worksheets
- Data modeling specific compare/merge specifications for quick round-trip editing support
- New relationships type worksheet and extensions to the models type worksheet supporting associations, aggregation and generalizations, PK/FK/AK, verb phrase/role name, cardinality and other metadata concepts
-
For Data Integration (DI/ETL/EII/EAI) purposes:
- Excel "Metadata" Add-In based Toolbar support for cell comment based annotation of cells on the joins, lookups and filters type worksheets
- Validation on Rules type worksheets
-
General Enhancements and Updates
- UPDATE: Microsoft SQL Server Integration Services import bridge: various improvements and bug fixes
-
UPDATE: Microsoft SQL Server Reporting Services import bridge:
- various improvements to import MDX expressions, prompts, report lineage and graphical structure
- added support for DataSets based on relational SQL queries
- minor bug fixes and improvements
-
UPDATE: Microsoft SQL Server Analysis Services (XMLA) import bridge:
- improved support for measure groups, calculated measures, KPI(s)
- minor bug fixes and improvements
-
UPDATE: Oracle BI Server import bridge:
- fixed bug parsing columns and their description
- better handling duplicate physical columns and duplicate presentation columns
- UPDATE: SAP BusinessObjects Data Integrator (BODI) export bridge: initial support for ETL metadata
- UPDATE: SAP BusinessObjects Designer export bridge: removed unnecessary warning messages when updating tables
- UPDATE: SAP BusinessObjects Designer, Reporter, WebIntelligence and CrystalReports import bridges: renamed login parameters for simplicity
- UPDATE: SAP BusinessObjects Repository import bridge: removed unnecessary bridge parameters, and renamed login parameters for simplicity
v6.0.5 (09/28/2009)
-
MIMB SUPPORTED TOOLS:
- NEW: DDL export bridge
- NEW: SAP BusinessObjects Data Integrator (BODI) import and export bridges: support source/target data stores
- NEW: Informatica Developer import and export bridges: prototype bridges to support version 9.0 Beta
- UPDATE: simplified metamodel for browsing 3rd party repository metadata
- UPDATE: improved MIR XMI parsing performance
- UPDATE: added support for incremental harvesting for file based import bridges, using a hidden date parameter
- UPDATE: improved ability to terminate the MIMB process gracefully, closing connections to 3rd party tools APIs
- UPDATE: fixed issue with Microsoft security updates of ATL, MFC, CRT DLL(s) (KB971090, KB973923, KB971092, KB973924)
-
UPDATE: added support for new database platform codes
- IBM DB2 UDB 9.0
- IBM DB2 9.0 for z/OS
- Microsoft SQL Server 2008
- MySQL 5.0
- Sybase ASE 15.0
- Oracle 11g
- CA ERwin 7 import and export
- Embarcadero ER/Studio import and export
- IBM Rational Data Architect import and export
- Sybase PowerDesigner PDM import and export
-
UPDATE: improved error messages for COM/OLE api based bridges when the tool/api is not installed:
- CA ERwin and ModelManager
- IBM Cognos Impromptu
- IBM (Telelogic) SystemArchitect
- MicroStrategy
- Microsoft Excel
- Microsoft ODBO/ADOMD
- Microsoft SQL Server AS via DSO
- SAP BusinessObjects Designer and DesktopIntelligence
-
UPDATE: improved testing of file header, for file based import bridges:
- CA ERwin 4 and 7
- Hyperion Essbase Integration Services
- IBM Db2 CubeViews
- IBM Rational Rose and Rose Data Modeler
- Oracle BI Server and Answers
-
UPDATE: CA ERwin 7 import bridge:
- improved support for Teradata datatypes
- added support for LOB datatypes length e.g. BLOB(5G)
- added support for entity/tables Volumetric s properties
- added support for DB2 index PCTFREE property
- fixed bug with empty logical key
- fixed bug with corrupted view associations
- fixed bug with corrupted view columns
- fixed bug on corrupted type 2 domains
- fixed minor bug importing foreign key name
- UPDATE: CA ERwin 7 export bridge:added support for entity/tables Volumetric s properties
- UPDATE: CA ERwin 7 ModelManager import bridges: improved testing functionality, now checking selected models are available
-
UPDATE: CA ERwin 4 import bridge:
- added support for LOB datatypes length e.g. BLOB(5G)
- added support for entity/tables Volumetric s properties
- added new parameter value 'Import UDPs'='As metadata, only when used' to discard unused UDPs
- added support for DB2 index PCTFREE property
- improved import of views physical name
- fixed bug on corrupted type 2 domains
- fixed bug on DB2 identity properties
- better detect view columns datatype based on the source column, if any
- UPDATE: CA ERwin 4 export bridge: fixed bug when exporting index UDPs
- UPDATE: CA Gen import bridge: improved support for entity Volumetric s properties
-
UPDATE: Embarcadero ER/Studio import and export bridges:
- minor changes to support version 8.5
- added support for LOB datatypes length e.g. BLOB(5G)
- added support for the owner schema of Indexes
- added support for entity/tables Volumetric s properties
- added import of diagrams description and UDPs
- support exporting Cobol Copybook record file schema as physical model
- fixed crash on invalid model
- improved export bridge performance, so large models are exported faster
-
UPDATE: IBM Cognos QueryStudio import bridge:
- added log warnings when objects referenced in the report cannot be found in the source package
- the parameter 'Package file' is now hidden
-
UPDATE: IBM Cognos ReportStudio import bridge:
- added log warnings when objects referenced in the report cannot be found in the source package
- the parameter 'Package file' is now hidden
- improved support for graphical objects name and singleton
-
UPDATE: IBM Cognos FrameworkManager import bridge:
- the bridge now detects and reports an error, when the model is based on dynamic metadata (not defined in the file).
- the parameter "Package repository path" is now hidden, to avoid usage confusion
-
UPDATE: IBM Cognos FrameworkManager export bridge:
- fixed bug on scope relationships.
-
UPDATE: IBM Cognos Repository import bridge:
- added server version auto-detection, based on new version.XML URL parameter
- now printing the cognos dispatcher version information in the log
- renamed Gateway and Dispatcher URL connection parameters to be more specific
- improved code printing cognos specific error messages, so that login errors in particular can be more easily understood
- improved naming conventions for published cognos FM packages, whether cognos package versionning is used or not
- improved test functionality, now checking selected subset objects are available
- removed confusing 'Logon successful' log message
- added 'activation.jar' to classpath when using the native Cognos SDK
- fixed possible bug on ReportNet 1.x, if the login password contains special characters
-
UPDATE: IBM Rational Data Architect import bridge:
- added support for entity/tables Volumetric s properties
- improved support for logical LDM relationships with empty ForeignKeys
- improved support for LDM generalizations, detect and avoid simple generalization loops
-
UPDATE: IBM Rational Data Architect export bridge:
- added support for entity/tables Volumetric s properties
- added support for the MySQL, JDBC target databases, and other new databases for version 7.5.2
- added support for improved Informix metamodel in version 7.5.2
- added export of diagrams description and UDPs
- added support for DB2 index PCTFREE property
- improved export of DBM columns, now printing reference to logical domain from LDM file, if applicable
- improved export of DBM foreign keys, printing columns in order of associated index, if any
- avoid generating an empty DBM file, if there is no relational database catalog to export
- fixed bug when generating DBM model for Teradata
- fixed bug on DBM foreign keys, removed unnecessary annotation reference
- fixed bug on LDM model for NUMERIC datatype, now printing scale explicitly
- fixed NullPointerException bug with LDM model in version 7.5.2.1
- UPDATE: IBM Rational (Telelogic/Popkin) System Architect bridges: tested version 11.3.128, fixed regression bug on import of supertype/subtype entities
- UPDATE: IBM WebSphere Information Server export bridge: added support for Logical Data Modeling in version 8.5
- UPDATE: Informatica PowerCenter Repository import bridge: now supports versionned repositories, bug fix for version 7.x
-
UPDATE: Informatica PowerCenter export bridge:
- added support for Custom Functions
- added ability to export reusable transformations
- fixed bug on numeric datatypes precision and scale
-
UPDATE: JDBC import bridge:
- improved support for Oracle 11 and SQL Server 2008
- improved metadata extraction from Oracle and Teradata system tables
- improved support for java 1.6 and Microsoft SQL Server
- improved log messages, to help identify runtime permissions problems
- various minor bug fixes and improvements
-
UPDATE: Kalido DIW import bridge:
- improved support for the Oracle SYSDATE format
- when resolving joins, use the physical table name, rather than the alias name
-
UPDATE: Microsoft Excel import and export bridges:
-
Major improvements and new features in the 'data modeling' area for applications ranging from a simple business glossary to a metadata registry, data governance, data standardization, and even full data / object modeling.
The dramatically extended metadata coverage now offers reporting via Excel of nearly all concepts in popular data / object modeling tools, as well as easy and convenient metadata entry or editing for hidden or incomplete flags, names, descriptions, or user defined properties (utilizing the target modeling tool's built-in comparator and integrator).
- Enhanced main "Models" worksheet with more metadata such as dimensional flags, primary keys, alternate keys, indexes, inversion keys and more.
- New "Packages" worksheet to centralize the descriptions and user defined properties associated to the model organization that includes the model itself, the logical design packages, as well as the schemas.
- Enhanced "Domains" worksheet
- Enhanced "Enumerations" worksheet.
- New "Relationships" worksheet with full metadata defining Generalizations, Aggregations and other regular Associations, including role names, cardinality, and physical implementation as PK/FK.
-
Major improvements and new features in the 'data mapping' area for applications ranging from simple Classifiers/Entity/Table mapping with detailed Features/Attributes/Columns mapping requirements, to the much more powerful complex ETL transformations like joins, filters, expressions and lookups.
New support for reusable transformations allows business users to define business rules, including the mapping and transformations from a set of input variables to a set of output variables.
These transformation rules may then be reused to implement ClassifierMaps/FeatureMaps.
Such 'Data driven' business rules allows for enumeration mappings such as medical codes, as well as complex algorithms like a credit approval.
- Enhanced main Model "Mappings" worksheet
- New "Rules" worksheet
- Integrated Excel 'Standard' template (Blank and MetaMap files), extended to include version management and upgrade capabilities as the 'Standard' template evolves from version 1.0 in MIMB 6.0.4 to this new 'Standard' Excel templates version 2.0 as part of this new Excel 6.0.5 release.
- Improved custom 'Metadata' Toolbar/Ribbon User Interface for Excel
- Improved support for multiple versions of Excel from 2002 to 2007
-
Major improvements and new features in the 'data modeling' area for applications ranging from a simple business glossary to a metadata registry, data governance, data standardization, and even full data / object modeling.
The dramatically extended metadata coverage now offers reporting via Excel of nearly all concepts in popular data / object modeling tools, as well as easy and convenient metadata entry or editing for hidden or incomplete flags, names, descriptions, or user defined properties (utilizing the target modeling tool's built-in comparator and integrator).
-
UPDATE: Microsoft SQL Server Reporting Services import bridge:
- fixed bug importing a report sourcing from SQL Server 2008 database
- improved MDX expression parser
- improved import of filters
- improved support for graphical report fields, text, rowsets, parameters, calculated report fields
-
UPDATE: Microsoft SQL Server Analysis Services (XMLA) import bridge:
- improved support for Cubes Measure Groups
- added support for KPIs and Calculated Measures
- improved import of joins
- UPDATE: Microsoft SQL Server Integration Services import bridge: fixed lineage bug
- UPDATE: Microsoft SQL Server Data Source View import bridge: now importing business views friendly name
-
UPDATE: MicroStrategy import bridge:
- added initial support for version 9.0
- fixed regression bug related to prompts origin, removed 'Safe mode' parameter
- fixed name unicity bug on consolidations
- improved Test functionality, to make sure the project name is valid
- added client version auto-detection
- UPDATE: OLAP Databases via ODBO/ADOMD: now using OLAPSchema to represent the OLAP database catalog.
-
UPDATE: OMG UML 2 XMI import bridge:
- added better log messages to display progress
- improved bridge performance, so that large models import faster
- fixed bug importing generalizations
- other bug fixes and improvements
-
UPDATE: Oracle BI Server import bridge:
- improved import of variables, now parsing their initialization expression for lineage
- added import of display folders for physical tables
- now importing the objects native Id from UDML
- minor fixes to support old Siebel Analytics 7.8 files
- fixed bug on databases with no catalogs nor schema
-
UPDATE: Oracle BIEE import bridge:
- improved test functionality, to test the UDML file header and the selected subset of reports
- improved logging of login errors, with specific exception details
- improved browsing and subset capability to allow selecting multiple objects (folders, reports)
- added server version detection
- minor performance improvements
- UPDATE: SAP BusinessObjects CrystalReports import bridges: the Universes parameter is now hidden
-
UPDATE: SAP BusinessObjects Designer import bridge:
- added support for Stored Procedure tables/queries
- improved retrieval and testing of the database connection
-
UPDATE: SAP BusinessObjects Designer export bridge:
- improved export of prompts and filters
- improved retrieval and testing of the database connection
-
UPDATE: SAP BusinessObjects Repository import bridge:
- added auto detection of the java api path, the related bridge parameter is no longer mandatory
- added auto detection of the BO client software version
- fixed bug on corrupted WebIntelligence document
- improved test functionality, now checking selected subset objects are available
- improved performance when browsing folder structure, so large repositories with numerous folders can be analyzed faster
-
UPDATE: Sybase PowerDesigner PDM import bridge:
- import the 'generate' property for tables, views, triggers, relationships
- improved PK/FK relationship processing code to better detect invalid foreign key joins
- now printing warning for external file dependencies
- UPDATE: W3C XML Schema import bridge: improved import of annotation/descriptions, removing unnecessary carriage returns, line feeds
- REMOVED: Embarcadero ER/Studio via ERX bridge alias (to avoid confusion with native DM1 bridge)
- REMOVED: MetaMatrix bridge aliases for MIR XMI (terminated OEM agreement)
- REMOVED: MicroStrategy bridges have been disabled (cannot be supported without technology partnership in place)
- REMOVED: SchemaLogic bridge aliases for MIR XMI (terminated OEM agreement)
v6.0.4 (06/02/2009)
-
MIMB SUPPORTED TOOLS:
-
NEW: implemented new "Test" functionality in the following bridges:
- CA Gen
- IBM Cognos Impromptu
- IBM Telelogic System Architect
- IBM Rational Data Architect
- IBM Rational Software Architect
- Informatica PowerCenter Repository
- Merant AppMaster
- Microsoft SQL Server Analysis Services (via ODBO)
- Microsoft SQL Server Analysis Services 7.0 to 2000 (via DSO)
- Microsoft SQL Server Integration, Analysis and Reporting Services 2005 and 2008
- MicroStrategy Intelligence Server
- ProActivity
- NEW: JDBC import bridge: redesigned bridge architecture, added wrapper bridges to support Access, Sybase and Teradata
- NEW: OMG UML 2.0 XMI import bridge: beta bridge working with Sparx EnterpriseArchitect
- NEW: Simplified log output for multimodel bridges, now hiding INFO messages by default
-
UPDATE: BusinessObjects Designer import bridge:
- improved error handling for intermittent bug
- improved expression parser, to support quoted table names
- improved parsing of Derived Tables SQL statement, creating referenced tables not yet in the universe
- UPDATE: BusinessObjects DesktopIntelligence import bridge: bug fix for cells with no variables
-
UPDATE: BusinessObjects WebIntelligence import bridge:
- fixed name unicity bug with data provider result columns
- improved error handling when accessing invalid/corrupt data providers
-
UPDATE: BusinessObjects Repository import bridge:
- simplified architecture with only 2 DLLs
- improved browsing capability, to be able to subset by universes, folders, and documents
- added more debug log traces to help identify runtime problems
- fixed stitching issue when a universe contains filters with the same name
- modified initialization, so that the bridge doesn't fail when some tools are not licensed (Crystal, Deski, Webi, Designer)
- added new parameter, to skip or import empty folders
- added workaround for SDK limitation of 1000 query ResultSet size
- improved performance, when detecting crystal reports dependent universes
- improved profile
- UPDATE: CA ERwin 3.x import bridge: fixed bug importing user datatypes
-
UPDATE: CA ERwin 4 and 7 import bridges:
- fixed bug when importing logical-only keys with no attributes
- added detection of ERwin XML versus CA Repository XML formats
-
UPDATE: CA Gen import bridge: improved physical model import (Technical Design):
- now importing DB2 MVS/OS390/zOS physical objects: DatabaseInstance, Tablespace, StorageGroup
- now importing DB2 MVS/OS390/zOS physical name of Tables, Columns
- now retrieving the tables logical name from the equivalent entity in the logical model
-
UPDATE: Cognos ReportStudio import bridge:
- fixed bug on report with Korean (multi byte) characters
- improved expression parser to support 'within details' and similar keywords
-
UPDATE: Cognos Repository import bridge:
- fixed bug in log message processing, with Korean (multi byte) characters
- fixed stitching bug when a report uses a filter defined as a shortcut in the FM model
- improved profile
- UPDATE: Cognos FrameworkManager import bridge: added reverse engineering of joins, using determinant information
- UPDATE: Cognos Impromptu import bridge: now parsing the joins expressions
-
UPDATE: Embarcadero ER/Studio export bridge:
- better support for Transact-SQL datetime and money datatypes
- fixed bug when exporting index attachments
- UPDATE: IBM Ascential DataStage import bridge: bug fix when importing database schemas
-
UPDATE: IBM Rational Data Architect export bridges:
- fixed bug with SQL Server 2005, HSQLDB and Derby database type mapping
- fixed bug with SQL Server Double datatype mapping
- fixed bug with Interval and XML primitive datatype mapping
- improved datatype mapping of non ANSI datatypes (SQL Server money and datetime)
- improved export of DB2 MVS/OS390/zOS physical models (from CA Gen), now creating DatabaseInstances, TableSpaces, StorageGroups
- UPDATE: IBM Rational Rose Data Modeler import bridge: fixed support for multiple databases, and schemas not connected to databases
-
UPDATE: Microsoft Excel import and export bridges:
- major redesign of the bridge for new functionalities
- new "Standard" metamap and blank Excel templates integrating and replacing all previous Excel formats (MetaMaps and Blanks)
- new "Metadata" toolbar for Microsoft Office 2003 (.xla add-in) to 2007 (.xlam add-in) providing an actual user interface for using Excel as a tool for metadata management including model editing, model mapping, etc.
- added support for Office 2007 Open XML format (*.xlsm)
- added support for mappings with target lookups
- added new DataMapping template for ETL metadata, supporting multiple sources, targets and mapping sheets
-
UPDATE: Microsoft SQL Server Integration, Analysis and Reporting Services bridges:
- numerous bug fixes and improvements
- initial support for version 2008
-
UPDATE: MicroStrategy import bridge:
- improve import and validation of hierarchies top/bottom, detecting and handling hierarchy loops
- fixed validation bug, when importing 8.x metadata with a 7.x bridge
- added profile
- UPDATE: MicroStrategy export bridge: bug fixes to support versions 8.1.x
-
UPDATE: Oracle BI Server import bridge:
- added support for procedure tables SQL statement
- performance optimizations
- various bug fixes
-
UPDATE: Oracle BI Enterprise Edition import bridge:
- fixed axis/soap warnings
- relaxed subject areas verifications, some subject areas may not be visible on the presentation server
-
UPDATE: Oracle Warehouse Builder export bridge:
- fixed datatype mapping issues
- fixed issue exporting logical only entities, description/comment
- UPDATE: Sybase PowerDesigner PDM import bridge: fixed support of NUMERIC datatype for Oracle 9i
-
NEW: implemented new "Test" functionality in the following bridges:
v6.0.3 (01/28/2009)
-
MIMB GENERAL FEATURES:
- UPDATE: MIMB now requires java version 1.5 at the minimum. Java version 1.4 is no longer supported.
- UPDATE: fixed licensing bug for java bridges in OEM mode
-
MIMB WEB 2.0 USER INTERFACE:
- NEW: added support for bridges parameters historical values
- NEW: added new Test functionality to check bridges connectivity to a 3rd party tool API.
- NEW: added new log filtering functionalities
- UPDATE: improved Diagrammer and Lineage Analyzer zoom feature
- UPDATE: improved UI for editing bridge parameters of type File, Directory and Repository Subset
- UPDATE: the web application now only supports port 19980. Port 19982 is no longer supported
-
MIMB SUPPORTED TOOLS:
-
NEW: implemented new "Test" functionality in the following bridges:
- BusinessObjects Designer
- BusinessObjects DesktopIntelligence
- BusinessObjects WebIntelligence
- BusinessObjects CrystalReports
- BusinessObjects Repository
- CA ERwin 7.x ModelManager
- Cognos 8 BI Content Manager
- Oracle BI Enterprise Edition
- NEW: now printing in the log how much JVM memory is available to java bridges
-
NEW: added support for Semantic Lineage, traceability between logical design and physical design:
- Embarcadero ER/Studio import
- Oracle Designer import
- UPDATE: BusinessObjects Designer, DesktopIntelligence, WebIntelligence, CrystalReports and Repository bridges: added support for version 12.1 (XI Release 3.1)
-
UPDATE: BusinessObjects Repository import bridge:
- now skipping DesktopIntelligence reports stored in personal/favorite folders, as they cannot be imported
- fixed bug when a universe failed to import, and the stitcher would fail with 'File not found'
- improved error handling when universes fail importing
-
UPDATE: BusinessObjects DesktopIntelligence import bridge:
- Improved tooltip
- fixed bug with invalid/corrupted report Variables with unknown qualification
-
UPDATE: BusinessObjects Designer import and export bridges:
- improved error handling on corrupted/invalid Join Contexts
- improved error handling on corrupted/invalid Tables
- bug fix when reading qualifiers and owners information
- bug fix when exporting JoinContexts
- UPDATE: BusinessObjects CrystalReports import bridge: removed unnecessary parameters, improved tooltip
-
UPDATE: CA ERwin 7.x ModelManager import bridges:
- redesigned parameters interface with a single connection string parameter
- added support for both versions 7.2 and 7.3
- bug fixes
- UPDATE: CA ERwin 4 and 7 export bridges: bug fix when exporting the subjects areas description
- UPDATE: CA Gen import and export bridges: added support for version 7.6
- UPDATE: Cognos 8 BI ReportStudio and QueryStudio: fixed validation bugs on hierarchies
-
UPDATE: Database via JDBC import bridge:
- now using ALL_VIEWS instead of DBA_VIEWS to extract Oracle database views
- improved support of Oracle stored procedures
- UPDATE: Embarcadero ER/Studio import bridge: added support for final 8.0 DM1 format
-
UPDATE: Embarcadero ER/Studio export bridge:
- added support for final 8.0 DM1 format
- removed export of indexes associated to Foreign Keys
- UPDATE: Informatica PowerCenter import bridge: various improvements, support for custom SQL readers and lookups; limited support for mapping variables.
- UPDATE: IBM / Ascential DataStage export bridge: various improvements
-
UPDATE: IBM Rational Data Architect import bridge:
- added support for the .DDM domain model format
- bug fix on logical models default values
- UPDATE: IBM Rational Data Architect export bridge: fixed datatype mapping issue with SQL Server Bit/Boolean
-
UPDATE: Microsoft Excel import and export bridges:
- the existing Excel bridges which use a metamap configuration file are renamed 'Excel Advanced'
- new simpler Excel bridges are introduced, which automatically search for the correct metamap configuration file
- other bug fixes and improvements
- UPDATE: Microsoft SQL Server DataSourceView export bridges: various improvements
- UPDATE: Microsoft SQL Server Integration Services export bridge: improved conversion of ETL metadata
- UPDATE: Microsoft SQL Server Integration Services export bridge: improved export of PK/FK relationships as joins
- UPDATE: MicroStrategy import bridge: bug fixes, improved memory management, added new parameter to work around corruption issues
-
UPDATE: Oracle BI Answers import bridge:
- added support for complex report queries (Union, Intersection...)
- now computing a textual representation of report filters, as it is not available directly
- fixed bug for empty reports
-
UPDATE: Oracle BI Enterprise Edition import bridge:
- added new parameter to subset the imported reports from the Presentation Server
- now checking the presentation SubjectAreas available on the server match with those defined in the UDML file
- improved error handling
- UPDATE: Oracle BI Server import bridge: bug fixes, improved grouping of Variables
- UPDATE: Oracle Data Integrator import bridge: bug fixes
- UPDATE: Oracle Warehouse Builder import and export bridges: improved conversion of ETL metadata, bug fixes
- UPDATE: Sybase PowerDesigner PDM import bridge: updated datetime datatype mapping
- UPDATE: Sybase PowerDesigner CDM and PDM import bridges: fixed parsing error on extended properties with non-ASCII characters
-
NEW: implemented new "Test" functionality in the following bridges:
v6.0.2 (10/31/2008)
-
MIMB GENERAL FEATURES:
- NEW: SQL parser to detect the list of StoredProcedures arguments, based on their SQL script
- UPDATE: Fixed licensing bug related to bridge browse requests
-
MIMB WEB 2.0 USER INTERFACE:
- UPDATE: Profiling capabilities have been redesigned and expanded
- UPDATE: Improved Diagrammer and Lineage Analyzer layout and rendering performance
- UPDATE: Changed Tomcat default java settings to reserve more memory, and therefore support larger models
- UPDATE: Numerous other bug fixes and improvements
-
MIMB SUPPORTED TOOLS:
- NEW: CA ERwin 7 import and export bridges: initial support for version 7.3 new XML format
- NEW: Cognos 8 BI Reporting import bridges: support for version 8.4, improved scalability and performance
- NEW: Cognos 8 BI QueryStudio import bridge: now supporting QueryStudio reports for versions 8.3, 8.4
- NEW: Cognos 8 BI Content Manager import bridge: added repository harvesting of QueryStudio reports for versions 8.3, 8.4
- NEW: Oracle BusinessIntelligence Server (Siebel Analytics) import bridge: initial support of the BI Server repository metadata
- NEW: Oracle BusinessIntelligence Answers (Siebel Analytics) import bridge: initial support of Answers reports
- NEW: Oracle BusinessIntelligence Enterprise Edition (Siebel Analytics) import bridge: initial support of Presentation Server repository harvesting
- NEW: Oracle Warehouse Builder export bridge: initial support of ETL metadata for version 10g
- UPDATE: BusinessObjects CrystalReports 9.0 import bridge: this alpha bridge based on the deprecated RDC COM API is now discontinued. Crystal Reports is now only supported via the java RAS API starting from version 11.0 (XI)
- UPDATE: BusinessObjects CrystalReport import bridge: improved RAS server configuration tooltip for version 12.0
- UPDATE: BusinessObjects WebIntelligence import bridge: initial support of personal data providers in version 12.0
- UPDATE: BusinessObjects WebIntelligence, CrystalReport and Repository import bridges: removed support for NT and AD authentication modes, improved parameters descriptions
- UPDATE: BusinessObjects Repository import bridge: added database connections to the result of browse request
- UPDATE: Cognos 8 BI Content Manager import bridge: added database connections to the result of browse request
-
UPDATE: Cognos FrameworkManager import bridge:
- improved support for StoredProcedures
- added parameter to represent a published package as a model
- improved filters lineage processing
- UPDATE: CA ERwin 4 and 7 import bridges: fixed bug on identity columns
- UPDATE: CA ERwin 4 import bridge: now parsing StoredProcedures parameters from their SQL script
- UPDATE: CA Gen import and export bridges: bug fixes
- UPDATE: CA ParadigmPlus export bridge: fixed unicode/multibyte file path issue
-
UPDATE: Embarcadero ER/Studio import and export bridges:
- initial support for version 8.0
- added support for Submodel definitions for version 8.0
- fixed bug on physical only objects
- fixed bug on parsing list of reference values
- fixed bug on column properties inherited from domain
- UPDATE: IBM DataStage import bridge: fixed bug when running the bridge in browse mode
- UPDATE: IBM Information Server (Common Model) export bridge: various improvements and bug fixes, improved support for Cognos 8 BI metadata, stored procedures
- UPDATE: IBM Rational Data Architect export bridge: minor bug fixes
- UPDATE: IBM Rational Rose DataModeler import bridge: fixed bug related to Stored Procedures owner schema
- UPDATE: IBM Rational Rose 98 and 2003 export bridges: fixed default datatype export issue, now using default datatype conversion to Oracle
- UPDATE: Informatica PowerCenter Repository import bridge: added new parameter to support the Informatica Security Domain
- UPDATE: Informatica PowerCenter export bridge: various bug fixes
- UPDATE: Kalido DIW import bridge: various improvements and bug fixes
- UPDATE: MetaIntegration XMI export bridge: removed deprecated XMI Version parameter
- UPDATE: Microsoft Excel export bridge: various bug fixes
- UPDATE: Microsoft SQL Server Analysis Services export bridge: various improvements and bug fixes
- UPDATE: Oracle Data Integrator import and export bridges: support for ETL metadata, for versions 10g and 11g, various improvements and bug fixes
- UPDATE: OMG UML XMI export bridge: fixed datatype export bug, where the datatypes were exported as abstract Classifier
-
UPDATE: Sybase PowerDesigner CDM and PDM import and export bridges:
- support for version 15.0, support for Barker notation
- now importing diagrams extended attributes
- UPDATE: Sybase PowerDesigner PDM import bridge: added support for database Sequences
- UPDATE: Sybase PowerDesigner PDM import and export bridges: improved support for Triggers
- UPDATE: SyperLink Harvester 5.x import and export bridge: improved support for mappings, various bug fixes
v6.0.1 (07/22/2008)
-
MIMB SUPPORTED TOOLS:
- NEW: Microsoft SQL Server Analysis Services (SSAS) repository export bridge
- NEW: Oracle Data Integrator beta export bridge
- NEW: SyperLink Harvester 5.x beta export bridge: support for data models only
- UPDATE: BusinessObjects Designer export bridge: added ability to browse available database connections
- UPDATE: CA ERwin 4 and 7 import bridges: minor fix on Sybase database platforms support
- UPDATE: CA ERwin 7 Model Manager import bridge: added import and filtering of creation, modification dates
- UPDATE: Embarcadero ER/Studio import bridge: bug fix on supertype/subtype clusters
- UPDATE: IBM Rational Data Architect bridges: support for RDA version 7.5
- UPDATE: IBM Information Server (Common Model) export bridge: added new option to control export of joins
- UPDATE: Kalido DIW import bridge: added support for Cubes
- UPDATE: Microsoft Excel import bridge: improvements in how mappings build transformations
- UPDATE: Microsoft Excel export bridge: major speed improvements
- UPDATE: Microsoft SQL Server Repository bridges: various improvements, cleaner disconnection from the server
- UPDATE: MicroStrategy export bridge: added ability to browse available database instances from the server
- UPDATE: OMG UML XMI import bridge: minor bug fixes
- UPDATE: Sybase PowerDesigner CDM and PDM export bridges: now supporting shapes
- UPDATE: Sybase PowerDesigner PDM import and export bridges: improved conversion of triggers for versions 10 and later
v6.0.0 (05/31/2008)
-
MIR METAMODEL & GENERAL FEATURES:
-
NEW: improved repository management metamodel
- with new classes: Repository, Folder, FileAttachement, Content, Version and subclasses
- old classes (Directory, Product, Version, Format...) have been deprecated
- NEW: added JoinGroup class to represent Business Intelligence joins collections
- NEW: added Sequence and Identity classes to represent Data Modeling database sequence generators and Identity columns
- NEW: added Shape class to represent diagrams graphical shapes and text boxes
- NEW: improved modeling of Object and Data Modeling generalizations with new GeneralizationRole class
- UPDATE: added new properties to the Model class: Author, Modifier, ModificationTime
- UPDATE: added new property to the ExpressionNode class: datatype
- UPDATE: removed deprecated properties: Expression.status, ExpressionNode.status
- UPDATE: removed deprecated properties: ModelObject.status
- UPDATE: removed deprecated properties: DatabaseCatalog.majorVersion, DatabaseCatalog.minorVersion, DatabaseCatalog.tertiaryVersion
- UPDATE: removed deprecated property: PropertyValue.position (Extended properties are now single-valued)
- UPDATE: removed deprecated property: FeatureMap.mappingType
-
NEW: improved repository management metamodel
-
MIMB SUPPORTED TOOLS:
- NEW: Oracle Data Integrator (ODI) export bridge (beta): supporting relational database metadata
- NEW: Microsoft SQL Server Analysis Services (Repository) export bridge (beta): support for MS SSAS 2005 OLAP metadata via repository access
- NEW: Meta Integration Repository (MIR) XMI multimodel content bridges: new bridges allowing 3rd party repository metadata exchange via XMI
- UPDATE: Meta Integration Repository (MIR) on Access bridges: these bridges have been discontinued
- UPDATE: Meta Integration Repository (MIR) ODBC database bridges: these bridges have been discontinued
-
UPDATE: 3rd party repository bridges have been updated to use the new MIRSDK classes:
- BusinessObjects Repository 5.x and 6.x, XI import bridges
- CA ERwin 7 Model Manager import bridge
- Cognos 8 BI Reporting - Content Manager import bridge
- IBM Information Server (Common Model) export bridge
- Microsoft SQL Server Analysis and Reporting Services 9.0 import bridge
-
UPDATE: Data modeling bridges have been updated to support database Sequences
- CA ERwin 4 import and export bridges
- CA ERwin 7 import and export bridges
- Embarcadero ER/Studio import and export bridges
-
UPDATE: Data modeling bridges have been updated to support Identity columns
- CA ERwin 4 import and export bridges
- CA ERwin 7 import and export bridges
- Embarcadero ER/Studio import and export bridge
- IBM Rational Data Architect DBM import and export bridges
- Sybase PowerDesigner PDM import and export bridges
-
UPDATE: Improved Data modeling bridges to take advantage of new GeneralizationRole modeling
- CA ERwin 3 import and export bridges
- CA ERwin 4 import and export bridges
- CA ERwin 7 import and export bridges
- Embarcadero ER/Studio import and export bridge
- IBM Rational Data Architect LDM import and export bridges
- Sybase PowerDesigner CDM import and export bridges
-
UPDATE: Improved bridges to take advantage of new Shape class
- CA ERwin 3 import and export bridges
- CA ERwin 4 import and export bridges
- CA ERwin 7 import and export bridges
- Embarcadero ER/Studio import and export bridge
- Sybase PowerDesigner CDM and PDM import bridges
-
UPDATE: Business Intelligence bridges have been updated to take advantage of the new JoinGroup class
- BusinessObjects import and export bridges
- Kalido DIW import bridges
-
MIMB WEB 2.0 USER INTERFACE:
- NEW: brand new web 2.0 user interface, old java desktop interface has been deprecated
-
MIMB WEB SERVICES & OEM INTEGRATION:
- NEW: MIMB agents for remote metadata harvesting
-
MIMB KNOWN ISSUES:
- N/A
v5.2.5 only as incremental patches (XX/XX/2008)
-
MIMB SUPPORTED TOOLS:
- NEW: BusinessObjects Designer, Reporter, WebIntelligence, Crystal and Repository bridges: added support for version 12.0 (XI 3.0)
- NEW: Cognos 8 BI Reporting import bridges: support for version 8.4, improved scalability and performance
- NEW: Cognos 8 BI QueryStudio import bridge: now supporting QueryStudio reports for versions 8.3, 8.4
- NEW: Cognos 8 BI Content Manager import bridge: added repository harvesting of QueryStudio reports for versions 8.3, 8.4
- UPDATE: BusinessObjects WebIntelligence import bridge: fixed memory corruption issue
- UPDATE: BusinessObjects Designer import bridge: fixed issue with opening master/detail universes from repository
- UPDATE: BusinessObjects Crystal Reports 9.0 import bridge: this alpha bridge based on the deprecated RDC COM API is now discontinued. Crystal Reports is now only supported via the java RAS API starting from version 11.0 (XI)
- UPDATE: BusinessObjects Repository import bridge: fixed issue with DesktopIntelligence documents in version 12.0
- UPDATE: CA ERwin 7 export bridge: minor fixes
- UPDATE: Cognos FrameworkManager import bridge: improved support for StoredProcedures, added parameter to represent a published package as a model
- UPDATE: Embarcadero ER/Studio import bridge: added support for new target database platform codes for version 7.6, fixed bug on parsing list of reference values
- UPDATE: IBM Information Server (Common Model) export bridge: various improvements and bug fixes, improved support for Cognos 8 BI metadata, stored procedures
- UPDATE: IBM Rational Data Architect export bridge: now setting a default name when a Schema has no name
- UPDATE: IBM Rational Rose Data Modeler import bridge: added import of attributes key property
- UPDATE: Informatica PowerCenter export bridge: improved schema name
- UPDATE: Microsoft Excel export bridge: various bug fixes
- UPDATE: Oracle Data Integrator import and export bridges: various improvements and bug fixes
- UPDATE: OMG UML XMI export bridge: minor fixes for Sparx EA, added new options to print DTD reference and DI metadata
- UPDATE: SAP Master Data Management import and export bridges: various improvements and bug fixes
- UPDATE: SelectSE import bridge: fixed issue with SQL Views
- UPDATE: Sybase PowerDesigner CDM import bridge: updated import of 1-1 relationships with Dominant role
- UPDATE: Sybase PowerDesigner PDM import and export bridges: improved support for Triggers
- UPDATE: Teradata MDS bridges: these bridges have been removed
v5.2.4 last GA release of 5.x (03/14/2008)
-
MIMB DESKTOP USER INTERFACE:
- UPDATE: bug fixes and improvements to the Diagram visualization tab
-
MIMB SUPPORTED TOOLS:
- NEW: Meta Integration Transformations to Views: utility export bridge to convert ETL transformations into Database Views SQL definitions
- NEW: Microsoft SQL Server Analysis Services: new repository bridge that connects to an Analysis Service, browses and imports an OLAP database model
- NEW: Microsoft SQL Server Integration Services: new repository bridge that connects to an Integration Service, browses and imports a integration model
- NEW: Microsoft SQL Server Reporting Services: new repository bridge that connects to an Reporting Service (via IIS), browses and imports a report model
- NEW: SAP Master Data Management import and export bridges: initial version, supporting core data modeling concepts of MDM v5.5
- UPDATE: updated COM XML demo component
- UPDATE: BusinessObjects Metadata Manager: various bug fixes
- UPDATE: BusinessObjects Designer, Reporter, WebIntelligence, Crystal and Repository import bridges: clarified and improved bridges descriptions
- UPDATE: BusinessObjects WebIntelligence import bridge: fixed null pointer exception issue on some reports
- UPDATE: BusinessObjects DesktopIntelligence and WebIntelligence import bridges: now removing unused universe objects for more accurate lineage dependencies
- UPDATE: CA ERwin 4, 7 import bridges: fixed issue related to synonyms with identical names
- UPDATE: CA ERwin 7 Model Manager import bridges: fixed issue related to Windows Authentication
- UPDATE: Cognos 8 BI Content Manager import: added initial support for version 8.3
- UPDATE: Cognos 8 BI ReportStudio import: added initial support for version 8.3 reports, improved expression parsing
- UPDATE: Embarcadero ER/Studio export bridges: new DLL architecture to support versions 7.0 and 7.5, fixed bug on subtype relationships foreign keys
- UPDATE: IBM Rational Data Architect import bridge: various bug fixes, and new JAR files architecture to support different versions including 7.0 FP5 and 7.5
- UPDATE: IBM DataStage import bridge: fixed issue with version 8.0 file parsing, various improvements
- UPDATE: Informatica PowerCenter import: various bug fixes and improvements
- UPDATE: JDBC import bridges: added missing parameters, improved import of Oracle synonyms, removed creation of artificial diagram
- UPDATE: Kalido DIW import bridge: bug fixes, various improvements
- UPDATE: MicroStrategy import bridges: fixed issue with DatabaseSchema object, removed "import hidden objects" parameter
- UPDATE: Oracle Data Integrator import bridge: improved support of relational models, initial support of ETL transformations
- UPDATE: Sybase PowerDesigner CDM & PDM import bridges: improved RTF parsing support
- UPDATE: Sybase PowerDesigner CDM import bridge: added support for EntityAttribute extended properties
- UPDATE: Sybase PowerDesigner PDM import bridge: bug fixes and improvements related to versions 12.x
- UPDATE: SypherLink Harvester import bridge: various improvements and bug fixes
- UPDATE: Telelogic SystemArchitect import bridge: bug fix on diagrams entities graphical layout, now importing directionality of non-specific relationships
- UPDATE: Telelogic SystemArchitect import and export bridges: added support for version 11.0.30
- UPDATE: W3C XML DTD and XSD import bridge: removed creation of artificial diagram
v5.2.3 (12/21/2007)
-
MIR METAMODEL & GENERAL FEATURES:
- UPDATE: Improved Views SQL statement parsing for lineage detection
- UPDATE: Now setting the current directory to MIMB bin directory, to allow setup.XML relative paths
- UPDATE: Improved metadata Validation: now printing the name of the model being validated, useful for multimodel repository bridges
-
MIMB DESKTOP USER INTERFACE:
- NEW: Added 'Diagram' tab and associated diagram visualization engine to display UML and ER diagrams
- UPDATE: improved Lineage rendering performance
-
MIMB SUPPORTED TOOLS:
- NEW: CA ERwin 7.2 Model Manager import bridge: initial support of single and multimodel import, with support of ModelSource dependencies
- NEW: Oracle Data Integrator import bridge: initial version supporting ODI v10.1.3.4 relational metadata only
- UPDATE: BusinessObjects Designer import: improved exception handling when parsing joins expression
-
UPDATE: BusinessObjects Designer export:
- now using bridge parameters to control 2-layer property updates
- fixed issue with detail objects in 2-layer update mode
- new option to erase and completely recreate the database schema layer
-
UPDATE: BusinessObjects Repository import:
- now skipping empty folders
- fixed regression bug related to repository name
- fixed regression bug related to universes encoding conversion on version 5.x and 6.x
- UPDATE: CA ERwin 3, 4 & 7 import bridges: improved datatype mapping for Sysname
- UPDATE: CA ERwin 4 & 7 export bridges: improved export of Fonts and Colors
- UPDATE: CA ERwin 4 import bridge: fixed regression issue on Supertype/Subtype Identity Transform objects
- UPDATE: CA ERwin 7 export bridge: fixed issue with escaping special character #17
- UPDATE: Cognos Impromptu import: improved model organization, fixed regression issue with bridge options
- UPDATE: Cognos FrameworkManager export: fixed infinite loop bug, minor improvements and bug fixes
- UPDATE: Cognos Repository import: improved support for slow repositories
- UPDATE: Embarcadero ER/Studio import: fixed FK attribute unification issue, minor fix to support EA/Studio DM1 files
-
UPDATE: Embarcadero ER/Studio export:
- fixed issue with default target database
- fixed issue with non-identifying relationships split keys
- fixed text file transcoding issues (for Korean encoding in particular)
- fixed issue with indexes marked as not generated
-
UPDATE: IBM Rational Data Architect import:
- bug fix importing a physical DBM model
- now ignoring extra XML namespaces while loading the XMI file
- added support for native Teradata model available since 7.0 FP3
-
UPDATE: IBM Rational Data Architect export:
- improved XML serialization code to better support 0x11 special character
- fixed ArrayIndexOutOfBound exception when exporting invalid FKs
- added support for native Teradata model available since 7.0 FP3
-
UPDATE: IBM (Telelogic) SystemArchitect import and export:
- added model browsing/selection capability on import
- added support for new versions: 10.6.11, 10.7.16 and 10.8.04
- UPDATE: IBM (Ascential) DataStage import: added new parameter for summarization of ETL lineage, improved support for variables
- UPDATE: Informatica PowerCenter import: added new parameter for summarization of ETL lineage
- UPDATE: Microsoft SQL Server 2005 Reporting Services: improved import of report metadata, initial support of MDX queries
- UPDATE: Microsoft SQL Server 2005 Integration Services: improved import of ETL transformation metadata
-
UPDATE: MicroStrategy import:
- added support for CustOMGroup objects used in Reports
- added repository browsing capability
- added initial support for report prompts, improved prompts lineage
- UPDATE: NCR Teradata Database import: improved parsing of Views SQL statements
-
UPDATE: Relational Database via JDBC import bridge:
- updated bridge description to support NCR Teradata native JDBC driver
- added support for Microsoft SQL Server 2005 database and driver
- added support for the descriptions of tables and columns for Microsoft SQL Server 2000 and 2005.
- enhancement to support a list of schemas
- added support for Sybase ASE 15.0 with native JDBC driver JConnect 6.0
- UPDATE: OMG UML XMI export: added support for Diagram Interchange (in Borland Together mode), and SVG rendering
- UPDATE: OMG CWM XMI import and export: bug fixes, added support for Dimension to default Hierarchy link
- UPDATE: Oracle Designer export: fixed regression bug with extra space character
- UPDATE: SAP Business Warehouse via ODBO/ADOMD import: improved error handling for incomplete/invalid cubes, fixed regression issue
- UPDATE: SchemaLogic import: added new parameter to support external names
- UPDATE: Sybase PowerDesigner CDM & PDM XML import: improved RTF parsing to skip font and color declarations in the header
- UPDATE: SypherLink import: improved PK-FK processing, minor improvements and bug fixes
v5.2.2 (10/01/2007)
-
MIR METAMODEL & GENERAL FEATURES:
- UPDATE: Improved support for internationalized file paths
-
MIMB DESKTOP USER INTERFACE:
- UPDATE: fixed the Lineage tab empty problem in MIMB UI
- UPDATE: various other bug fixes and enhancements
-
MIMB SUPPORTED TOOLS:
- UPDATE: BusinessObjects Designer import: added workaround for corrupted linked universe with empty classes and objects names
-
UPDATE: BusinessObjects Designer export:
- now properly refreshing universe schema structure at beginning of execution to remove tables no longer in the database
- fixed issues updating joins and join contexts
- UPDATE: BusinessObjects Desktop Intelligence import bridge: fixed issue with importing documents from a favorite folder
-
UPDATE: BusinessObjects Repository import bridge:
- fixed issue connecting to a repository in a cluster environment
- now skipping Desktop Intelligence documents located in a folder with slash '/' character in the path
- UPDATE: CA ERwin 3.x, 4.x and 7.x import and export bridges: improved support for Defaults according to the model's target database; various datatypes mapping adjustments
-
UPDATE: Cognos 8 Framework Manager export bridge:
- improved support for scope relationships
- when a QueryItem is of undefined datatype, its parent QuerySubject is marked as needing reevaluation
- UPDATE: Embarcadero ER/Studio import and export bridges: numerous improvements and bug fixes
-
UPDATE: IBM Ascential DataStage import bridge:
- added ability to browse and select a metadata subset for import
- added ability to specify metadata variables values to resolve correct name of database catalogs, schemas and tables
-
UPDATE: Kalido DIW import bridge:
- improved support for supertype/subtype relationships
- added support for multiple time variance
- various other bug fixes and improvements
- UPDATE: Microsoft Excel import and export bridges: improved support of data transformation models, bug fixes
- UPDATE: MicroStrategy export bridge: fixed issue with server mode project creation
- UPDATE: OMG CWM XMI export bridge: fixed bug related to closing schema XML tag
- UPDATE: Relational Database via JDBC import bridge: improved support for NCR Teradata database metadata via JDBC.
- UPDATE: Select SE import bridge: added support for tables constraints, improved support of Views SQL statement definition and columns
v5.2.1 (07/31/2007)
-
MIR METAMODEL & GENERAL FEATURES:
- UPDATE: added consistency validation rule to check generalization foreign keys
-
MIMB SUPPORTED TOOLS:
- NEW: Embarcadero ER/Studio export bridge: initial version supporting ER/Studio 7.0
- UPDATE: Ascential DataStage import bridge: improved support for transformations custom SQL
- UPDATE: BusinessObjects Designer export bridge: now creating Join Contexts from Kalido DIW models, added support for ragged hierarchies
- UPDATE: CA ERwin 3.x export bridge: now printing a log warning for FK-AK relationships that cannot be exported, fixed datatype mapping issues
- UPDATE: CA ERwin 4.x export bridge: fixed bug on attribute rolenames for fishhook relationships
- UPDATE: CA ERwin 4.x and 7.x import bridges: improved XML parser efficiency for large models
- UPDATE: CA ERwin 7.x import and export bridge: added support for new relationship name property available since version 7.2
- UPDATE: CA ERwin 7.x export bridge: fixed bug on fishhook relationships in ERwin 7.2
-
UPDATE: Cognos 8 Framework Manager export bridge:
- added a new option to separate the dimensional namespace and the logical namespace
- added a new option to change the name of the dimensional namespace
- added a new value "Dimensional level only" to the "Namespace hierarchy" option
- added a new option to represent dimensions without dimensional information as dimensions or model queries
- UPDATE: Cognos Impromptu import bridge: fixed regression bug
- UPDATE: IBM Rational Data Architect export bridge: fixed datatype mapping issues
- UPDATE: IBM Rational Data Architect import bridge: fixed issue related to plugin org.eclipse.emf.ecore.change
- UPDATE: Informatica PowerCenter export bridge: improved support for Joiner transformations
-
UPDATE: Kalido DIW import bridge:
- added a new option to use names or headings as object names
- added a new option to specify the design level of the physical objects
- added support for joins time variance
- UPDATE: OMG UML XMI import bridge: minor adjustments to support some CA Component Modeler 5.x models
- UPDATE: Telelogic System Architect export bridge: fixed bug on relationship loops
-
MIMB WEB USER INTERFACE:
- NEW: added new "Browse" panel rendering the model as a dynamic tree
v5.2.0 (06/08/2007)
-
MIR METAMODEL & GENERAL FEATURES:
- NEW: Support for multimodel bridges, especially repository bridges
- UPDATE: Improved internationalization support (.e.g, internationalization of file path)
- UPDATE: Improved bridge specifications (vendor names, tool current and old names, supported versions, supported methodologies and interface, web site, etc).
- UPDATE: Business Intelligence import bridges: Harmonization of "Reverse Engineering of Joins as Relationships" on BI import bridges
-
MIMB SUPPORTED TOOLS:
- NEW: Kalido DIW import bridge
- NEW: Microsoft SQL Server Integration Services import bridge
- NEW: SyperLink Harvester import bridge
- NEW: AbInitio XML import bridge (Beta)
- NEW: Relational database via JDBC and ODBC import bridge: added new bridge wrapper to simplify ODBC connection parameters
- UPDATE: BO Crystal Reports import bridge: various bug fixes and improvements
- UPDATE: BO Designer import bridge: bug fix when retrieving a universe from the CMS repository
- UPDATE: BO Designer export bridge: new update algorithm using public and private dimensional layers
- UPDATE: BO Repository 11.x import bridge: added CMS repository server name resolution, needed for proper universe retrieval
- UPDATE: CA ERwin 3.x bridges: Fixed datetime, timestamp, nvarchar datatype mapping issues
- UPDATE: CA ERwin 7.x bridges: Fixed unicity bug on validation constraint usage name
- UPDATE: CobolCopybook import bridge: Upgraded to support multiple 01 levels
- UPDATE: Cognos 8 BI FrameworkManager import and export bridge: minor bug fixes
- UPDATE: Cognos 8 BI Reporting import bridge: updated the expression parser, bug fix on queries nested tabular references
- UPDATE: Embarcadero ER/Studio import bridge: now importing the associations UUID
- UPDATE: Informatica Power Center import bridge: eliminated unexpected application error
- UPDATE: IBM Information Server (Common Model) import bridge: updated parameters and metadata coverage
- UPDATE: IBM WebSphere DataStage import bridge: Updated to produce more accurate direction for data packages
- UPDATE: IBM WebSphere DataStage import bridge: eliminated unexpected application error
- UPDATE: Microsoft SQL Server Analysis Service XMLA import bridge: Updated attribute look up function and allow a level to be used in multiple hierarchies
- UPDATE: Microsoft Excel import and export bridges: minor bug fixes
- UPDATE: MicroStrategy import and export bridges: minor fixes to support version 8.1
- UPDATE: NCR Teradata bridges: VC++ 6.0 upgrade
- UPDATE: Oracle Designer import bridge: now setting the database type to Oracle, improved datatype mappings for Oracle Designer 10g
- UPDATE: Oracle Designer export bridge: improved datatype mappings for Oracle Designer 10g
- UPDATE: Telelogic SystemArchitect export bridge: FK-AK relationships are not converted, added warning message
- UPDATE: Sybase PowerDesigner PDM export bridge: added support for Oracle 10g database
-
MIMB DESKTOP USER INTERFACE:
- NEW: Graphical Lineage Visualization tab integration
- UPDATE: Enhanced multimodel import/export control
- UPDATE: Enhanced support for remote scripting
- UPDATE: Improved Logging with dates, error codes and stack traces saved in all log files
-
MIMB WEB USER INTERFACE:
- NEW: Bridge Selection matching the automatically generated "Supported Tool" web page, with search capabilities and Save As button
- NEW: Metamodel Mapping dialog with Save As button
- UPDATE: Enhanced support for remote scripting
-
MIMB WEB SERVICES & OEM INTEGRATION:
- NEW: MIMB Integration with XML based Web Services
-
MIMB KNOWN ISSUES:
-
UPDATE: Limited support for Vista
- The Java Swing based user interface of Meta Integration's desktop solution has a few limitations on Vista
- The InstallShield has a few limitations on Vista
-
UPDATE: Limited support for Vista
v5.1.1 (03/23/2007)
-
MIR METAMODEL & GENERAL FEATURES:
-
UPDATE: improved Business Intelligence export bridges with common star-schema to dimensional modeling forward engineering algorithm and bridge options:
- Business Objects Designer
- IBM DB2 Cube Views
- Informatica PowerAnalyzer
- Hyperion Essbase Integration Services
- MicroStrategy
- Oracle Warehouse Builder
- UPDATE: bug fixes on Microsoft Windows 2000 related to installation and OEM detection
-
UPDATE: improved Business Intelligence export bridges with common star-schema to dimensional modeling forward engineering algorithm and bridge options:
-
MIMB SUPPORTED TOOLS:
- NEW: MIMB Integrator for BusinessObjects Metadata Manager (BOMM) version 11.7: first release
- NEW: Microsoft SQL Server 2005 Analysis Services (XMLA): initial support for OLAP metadata and lineage to Data Source Views
- NEW: Microsoft SQL Server 2005 Data Source View Designer import: new native implementation with support for Queries and Calculations
- NEW: Oracle Warehouse Builder 10.2 import bridge: added support for ETL metadata and lineage
- UPDATE: BO Repository import bridge: various enhancements and support for the latest service packs
-
UPDATE: BO Designer export bridge:
- removed option 'Close after execution', always closing the Designer application after bridge execution
- now allowing export to a universe file name longer than 8 characters
- added new 'Verbose' option
- added new option for scaling the graphical layout in version 11.5
- various other improvements and bug fixes
- UPDATE: CA ERwin 3.x export bridge: fixed bug on Model UDPs, added export of diagram text boxes
- UPDATE: CA ERwin 4.x import bridge: added export of diagram text boxes
- UPDATE: CA ERwin 7.x import and export bridges: initial support for version 7.2
- UPDATE: Cognos Series 7 Impromptu import bridge: fixed regression bug related to compilation
- UPDATE: IBM Information Server (Common Model) import bridge: updated parameters and metadata coverage
- UPDATE: Microsoft Excel import and export bridges: added support for hierarchical structures (COBOL, XML)
- UPDATE: Microsoft SQL Server 2005 Data Source View Designer export: minor bug fixes
- UPDATE: MicroStrategy import bridge: fixed regression bug on exception handling
- UPDATE: NCR Teradata MDS import and export bridge: fixed regression bug related to compilation
- UPDATE: Silverrun import bridge: added new option to invert relationships role names
- UPDATE: Sybase PowerDesigner CDM and PDM export bridges: changed the default export version to 12.0, minor enhancements
-
UPDATE: Telelogic System Architect import bridge:
- improved log messages related to foreign keys processing
- added new option to ignore invalid foreign key relationships
- added new option to control import of diagrams
- UPDATE: W3C XML Schema import bridge: improved support for recursive XML structure names
-
MIMB DESKTOP USER INTERFACE:
- UPDATE: bug fixes
-
MIMB WEB USER INTERFACE:
- NEW: Integration with MIRWeb replacing older JSP based MIMB Web interface
-
MIMB WEB SERVICES & OEM INTEGRATION:
- UPDATE: bug fixes
-
MIMB KNOWN ISSUES:
- NEW: This release has not been certified with Microsoft Windows Vista
v5.1.0 (12/13/2006)
-
MIR METAMODEL & GENERAL FEATURES:
-
NEW: MIMB execution on Remote Bridge Server via:
- MIMB Desktop application.
- MIMB command line tool.
- Web Services interface.
-
NEW: improved User Interface features:
- Remote Bridge Server execution control
- Explicit selection for Repository Subsets
- New Windows XP Look & Feel
- Attribute Table display of detailed object list
-
NEW: improved support for database views:
- CA ERwin 3, 4, 7 import and export bridges
- CA COOL:DBA (Terrain for DB2) import bridge
- Embarcadero ER/Studio import bridge
- IBM Rational Data Architect import and export bridges
- IBM Rational Rose Data Modeler import and export bridges
- Sybase PowerDesigner PDM import and export bridges
-
NEW: added support for generalization properties:
- CA ERwin 3, 4, 7 import and export bridges
- Embarcadero ER/Studio import bridge
- Sybase PowerDesigner CDM import and export bridges
-
NEW: improved support of Business Intelligence and Reporting metadata:
- BusinessObjects WebIntelligence, DesktopIntelligence and Repository import bridges
- Cognos Series 7 Impromptu import bridge
- Cognos 8 Framework Manager import and export bridges
- IBM DB2 CubeViews import bridge
- MicroStrategy import bridge
- Oracle Warehouse Builder import bridge
- UPDATE: improved compilation system, now using VisualStudio 2005
- UPDATE: improved packaging system, now using InstallShield 11.0
-
NEW: MIMB execution on Remote Bridge Server via:
-
MIMB SUPPORTED TOOLS:
- NEW: IBM Information Server (Common Model) Import Bridge
-
UPDATE: BusinessObjects Designer, Reporter and Repository import bridges:
- improved browsing algorithms and universe filtering performance for versions 5.x, 6.x and 11.x
- now printing the estimate number of documents to import in the log
- added import of Favorites folder for versions 11.x
- UPDATE: BusinessObjects Designer import bridge: added workaround for unexpected error on some invalid expressions
- UPDATE: CA ERwin 3, 4, 7 import bridges: added new parameter and algorithms to import Subject Areas as Diagrams or Packages
- UPDATE: CA ERwin 4 import bridge: better handling of OutOfMemory exception for large files
- UPDATE: CA ERwin 7 export bridge: bug fix on export of self/fishhook FK relationships, improved export of dimensional models
- UPDATE: CA ERwin 7 import bridge: bug fix on diagrams referenced relationships and diagrams entities coordinates
- UPDATE: CA Paradigm Plus import bridge: bug fix on relationship multiplicity
- UPDATE: Cognos 8 Framework Manager, ReportStudio and Content Manager import bridges: added support for version 8
- UPDATE: Embarcadero ER/Studio import bridge: now importing hierarchy of SubModels as Packages
- UPDATE: IBM Rational Rose Data Modeler export bridge: bug fix on export of attributes' domains
-
UPDATE: IBM Rational Data Architect import and export bridges:
- added support for version 7.0
- added dynamic java CLASSPATH computation, based on eclipse 'platform.XML' file
- changed export of logical LDM models, now exporting domains in a domain Package, now exporting entities in their respective SubjectArea package
- added support for import of submodel LDM files
- fixed support of diagrams, now using one Annotation per diagram
- UPDATE: Microsoft SQL Server Analysis Services (DSO) import bridge: numerous bug fixes and improvements for support of versions 7.0 and 2000
- UPDATE: OMG UML XMI export bridge: bug fixes
- UPDATE: Sybase PowerDesigner CDM XML export bridge: fixed relationship rolename inversion
- UPDATE: Silverrun RDM import bridge: bug fixes for primary keys and datatypes
-
MIMB DESKTOP USER INTERFACE:
- UPDATE: bug fixes
-
MIMB WEB USER INTERFACE:
- NEW: Completely rewritten new Web 2.0 (Ajax) MIMB using the new MIMB Web Services
-
MIMB WEB SERVICES & OEM INTEGRATION:
- NEW: MIMB Web Services for the integration with other Meta Integration tools, and third-party vendors (OEM).
-
MIMB KNOWN ISSUES:
- N/A
5.0.6 (10/31/2006)
- UPDATE: New sample models for version of ERwin (eMoviesMITI)
- UPDATE: New scenario models for dimensional modeling from multiple design tools
- UPDATE: update bridge specifications for currently supported tool names and versions
- UPDATE: improved metadata Validation to better detect aggregation relationship loops and primary key - foreign key loops
-
UPDATE: updated bridge to fix the direction of relationship role names:
- Sybase PowerDesigner CDM export bridge
-
UPDATE: updated import and export bridges to support primary and foreign keys constraint names:
- CA ERwin 3, 4, 7 import and export bridges
- Embarcadero ER/Studio import bridge
- Sybase PowerDesigner PDM import and export bridges
-
UPDATE: updated export bridges to create Dimensional models:
- CA ERwin 3, 4, 7 export bridges
-
UPDATE: updated import bridges with new option controlling how Subject Areas are imported:
- CA ERwin 3, 4, 7 import bridges
-
UPDATE: BusinessObjects Designer, Reporter and Repository import bridges:
- bug fixes related to encoding conversion
- improved browsing algorithms and universe filtering performance
- UPDATE: CA ERwin 7 export bridge: bug fix on views name
- UPDATE: CA ERwin 4 import bridge: added workaround for model with corrupted view columns
- UPDATE: CA ERwin 4 export bridge: improved loops detection
- UPDATE: CA ERwin 3 export bridge: improved loops detection, fixed decimal datatype mapping bug, fixed index UDP bug
- UPDATE: IBM DB2 CubeViews import and export bridges: added support for version 8.2.3
-
UPDATE: Microsoft Excel Import/Export bridges:
- new and updated bridge parameters (options) for filling and formating Excel cells
- new and updated bridge sample (configuration) blank and metadata mapping Excel files
- bug fixes
- UPDATE: MicroStrategy import bridge: many bug fixes and improvements related to reporting metadata, filters and subtotals.
-
UPDATE: Telelogic System Architect import and export bridges:
- added support for version 10.4
- added support for direct Encyclopedia connection, in addition to existing file based (UDL or dBase) connectivity.
- UPDATE: W3C DTD and XSD import bridges: updated options descriptions
5.0.5 (09/06/2006)
- NEW: IBM Rational Software Architect import bridge: initial support of version 6.0 EMX and UML2 files
- NEW: Cognos 8 BI Framework Manager import/export bridge: new support for Cognos Version 8.2
- UPDATE: MIMB Transformations: added new transformation "use java style naming convention"
- UPDATE: BusinessObjects Designer import bridge: fixed bug related to encoding conversion
- UPDATE: BusinessObjects Repository import bridge: fixed bug related to encoding conversion
- UPDATE: Cognos Series 7 Impromptu import bridge: added support for version 7.3.1413 (7.3 MR3)
- UPDATE: CA ERwin 7 import bridge: fixed graphical bug where relationships where not displayed on a diagram
- UPDATE: CA ERwin 7 export bridge: added export of Oracle tablespaces
- UPDATE: CA ERwin 4 & 7 import bridges: improved log messages for database type detection and datatype mapping
-
UPDATE: Embarcadero ER/Studio import bridge:
- fixed graphical bug related to entities black background color
- fixed bug on views and tables naming collision
- added support for version 7.1 new database platforms
- UPDATE: IBM Rational Rose DM export bridge: fixed bug on export of attribute link to its domain
-
UPDATE: IBM Rational Data Architect import and export bridges:
- added new version option to support both 6.1 and 6.1 FP1
- now setting the attribute abbreviation property for version 6.1 FP1
- better handling of OutOfMemory exception on very large models
- performance optimization for large models with many diagrams
- added support for Oracle Modeling
- improved support of alias tables and synonyms
- UPDATE: Microsoft Excel import and export bridges: updated tooltip, sample files, bug fix related to COM API environment
- UPDATE: Oracle Warehouse Builder OMB import and export bridges: many improvements and bug fixes
- UPDATE: Sybase PowerDesigner PDM import bridge: added import of Oracle tablespaces
- UPDATE: Sybase PowerDesigner CDM export bridge: improved export of User Defined Properties (UDPs)
5.0.4 (08/01/2006)
- NEW: Oracle Warehouse Builder OMB import and export bridges
-
UPDATE: MIMB log: improvements to display all bridge execution details in detailed consistency mode (as required to submit request to support):
- bridge specification (vendor, tool, format, version ...)
- system information (OS, Java, hardware)
- bridge parameters values
- UPDATE: MIMB Log: fixed handling of multi-line log messages
-
UPDATE: CA ERwin 7.x import bridge:
- added support for version 7.1 GA build 1075
- changed warning message about XML file version to info
- added workaround for bug on views name
- added import of View relationship alias name as extended PropertyValue
-
UPDATE: CA ERwin 4.x import bridge:
- added import of View relationship alias name as extended PropertyValue
- fixed bug on attributes connected to a domain with inherited constraint rule
- UPDATE: Embarcadero ER/Studio import bridge: added import of View relationship alias name as extended PropertyValue
-
UPDATE: Microsoft Excel import/export bridges:
- improved bridge parameters and documentation
- new excel sample files and associated metadata mapping files
-
UPDATE: W3C XML Schema import bridge:
- fixed import of include files with national characters
- added an option to import attributes of a specified namespace as user defined properties
5.0.3 (07/07/2006)
- UPDATE: BusinessObjects Designer import bridge: added workaround for BO bug where columns from a table and a synonym appear duplicated
-
UPDATE: CA ERwin 7.x export bridge:
- minor updates to support version 7.1.0.1039
- added new 'Version' parameter to support both versions 7.0.x and 7.1.x
- added new 'Validate XML' parameter to enable or disable XML file validation
-
UPDATE: Embarcadero ER/Studio import bridge:
- added new parameters to select and import the logical model, a physical model or all models
- fixed graphical layout bug on vertical axis coordinates for ER/Studio version 6.x and 7.0
- now importing the logical model entities owner schema
- added support for Unique (index) constraint on physical models introduced in version 7.1
- UPDATE: IBM Rational Data Architect export bridge: fixed support for target databases "IBM DB2 UDB zSeries V8 (New-Function Mode)" and "IBM DB2 UDB zSeries V8 (Compatibility Mode)"
- UPDATE: Sybase PowerDesigner CDM import bridge: now using the entities Generate properties to distinguish logical-only entities
- UPDATE: Sybase PowerDesigner PDM import bridge: added support for new databases supported in version 11.0 and 12.0
-
UPDATE: Sybase PowerDesigner CDM export bridge:
- added version 12.0 as available entry in the version parameter
- now using the entities Generate properties to distinguish logical-only entities
- fixed inconsistency bug between versions 8,9 and versions 10+ on how to export descriptions
-
UPDATE: Sybase PowerDesigner PDM export bridge:
- added version 12.0 as available entry in the version parameter
- fixed inconsistency bug between versions 8,9 and versions 10+ on how to export descriptions
v5.0.2 (06/02/2006)
- UPDATE: MIMB Model Validation: improved detailed consistency validation algorithm to work with larger models
- UPDATE: Cognos 8 Framework Manager 2 export bridge: added new bridge option to control how to export dimension attributes
-
UPDATE: Embarcadero ER/Studio import bridge:
- Fixed bug on 'Diagram' attachments that were not imported
- Added initial support for Submodel (diagram) graphical layout
- UPDATE: IBM DataStage 7.5 import bridge: improved lineage traceability by capturing greater details of ETL objects reuse and Job instances
- UPDATE: Microsoft Excel import bridge: added support for template (environment) variables
-
UPDATE: MicroStrategy import bridge:
- improved lineage detection of objects in the schema (semantic layer)
- now importing Attributes as separate objects, not grouping related ones anymore
- added initial support for reporting metadata (reports and documents)
- UPDATE: OMG CWM XMI export bridge: fix on export of Foreign Keys in mode "Model=UML and RDB"
v5.0.1 (04/21/2006)
- NEW: data modeling bridges have been updated to parse the database Views SQL statement and extract lineage metadata
- NEW: IBM Rational Data Architect Beta import and export bridges: initial support for version 6.1 database models (DBM) and logical models (LDM)
- NEW: IBM DB2 UDB Database (via JDBC) import bridge
- NEW: Microsoft SQL Server Database (via JDBC) import bridge
- NEW: Oracle Database (via JDBC) import bridge
- NEW: KnightsBridge Solutions Codes and Data Mapping Application (CDMA) export bridge
- NEW: Innovative Routines International (IRI) CoSORT/SortCL export bridge
- UPDATE: BusinessObjects Designer import bridge: improved login parameters to support the Standalone login mode in version 11.5
-
UPDATE: BusinessObjects Designer export bridge:
- improved login parameters to support the Standalone login mode in version 11.5
- added new option to execute in silent or interactive mode, allowing or blocking pop up windows
- other minor updates
-
UPDATE: BusinessObjects Reporter import bridge:
- added workaround for constant variables with empty formula
- improved expression parser to parse the SQL statement of Free Hand SQL Data Providers
- improved login parameters to support the Standalone login mode in version 11.5
-
UPDATE: BusinessObjects WebIntelligence import bridge:
- improved expression parser to support more complex expressions
- fixed issue on Web Intelligence documents converted from Desktop Intelligence
- other minor updates
v5.0.0 (03/28/2006)
General improvements:
- NEW: MIMB (Java/Swing based) Graphical User Interface (GUI) integrated within Meta Integration Works (MIW)
- NEW: MIMB Generalized Bridge (mandatory or optional) Input Parameters (instead of files + options), in order to better integrate with today's repository-based tools in addition to file-based tools.
- NEW: MIMB Online Bridge Metamodel Mapping Specifications integrated within the MIMB GUI, allowing for generation of CSV/Excel based bridge mapping specifications
- NEW: MIMB (Windows DOS, Unix Shell, or MIMB XML based) Script Generation from the MIMB Desktop GUI
- NEW: MIMB (XML based) Service Oriented Architecture (SOA) for add-on (or OEM built-in) metadata import/export menu integration
- NEW: MIMB License Manager and License Server Technology for MIMB Enterprise Edition, allowing local MIMB desktop applications to connect to a centralized Meta Integration License server (without a local license key)
- NEW: MIMB now supports 3rd party repository browsing and subset
- NEW: BusinessObjects Web Intelligence import bridge: initial support for versions 11.0 and 11.5
- NEW: BusinessObjects Repository import bridge: now supporting versions 11.0 and 11.5
- NEW: COBOL import bridge: initial version
- NEW: Microsoft Excel import and export bridges: initial version
- NEW: Informatica PowerCenter Repository import bridge: initial support of versions 6.x to 8.x
- NEW: CA AllFusion Gen import and export bridges: added support for version 7.0 and 7.5
- NEW: NCR Teradata MDS import and export: added support for version 6.1
-
NEW: Wrapper bridges now encapsulate various bridges versions (and/or file format) in unified facades:
- Business Objects Designer (File) import and export
- Business Objects Designer (Repository) import
- Business Objects Reporter (File) import
- Business Objects Reporter (Repository) import
- Business Objects Repository import
- CA ERwin 3.x export
- CA ERwin 4.x import and export
- CA ERwin 7.0 import and export
- Cognos Series 7 Impromptu (File) import
- Cognos 8 Content Manager Package import and export
- Cognos 8 Content Manager ReportStudio import
- Microsoft SQL Server Analysis Services import
- Microstrategy import and export
- NCR Teradata MDS import and export
- Popkin System Architect import and export
- Silverrun RDM import
- Sybase PowerDesigner import and export
- UPDATE: ModelSubsetting: fixed bug when subsetting models containing OLAPSchema, XMLSchema or RecordFileSchema objects
- UPDATE: Validation: various improvements to avoid unnecessary warnings when importing from BI repositories (BusinessObjects, Cognos)
-
UPDATE: BusinessObjects Designer export bridge:
- improved algorithm for update of an existing universe
- corrected typo on bridge tooltip description
-
UPDATE: BusinessObjects Designer import bridge:
- added new options and algorithms for the bridge to run in two modes: repository structure browser only, or repository structure and content
- added new option to execute in silent or interactive mode, allowing or blocking pop up windows
- fixed encoding bug when opening a universe file path with special non-ASCII characters
- now importing Default Hierarchies as well as Custom Hierarchies
- minor improvements and bug fixes
-
UPDATE: BusinessObjects Reporter import bridge:
- added new option to execute in silent or interactive mode, allowing or blocking pop up windows
- fixed expression parsing issues on formulas and variables.
- added workaround for variable used in report, but not defined in the list of document variables
- minor improvements and bug fixes
-
UPDATE: BusinessObjects Repository import bridge:
- added new options and algorithms for the bridge to run in two modes: repository structure browser only, or repository structure and content
- added new option to execute in silent or interactive mode, allowing or blocking pop up windows
- UPDATE: CA ERwin 7.0 import and export bridges: improvements to support Beta versions 7.0.0.1679, 7.0.0.1692, 7.0.0.1723
- UPDATE: CA ERwin 4.x, 7.0 import and export bridges: fixed concurrent execution issue, now using a unique temporary file name per instance
- UPDATE: CA ERwin 3.x, 4.x, 7.0 import bridges: fixed bug on attributes optionality when the IDENTITY datatype property is specified
- UPDATE: CA ERwin 3.x export bridge: fixed bug on attribute null/not null property when the generated ERX file is loaded into Microsoft Visio 2000
- UPDATE: CA ERwin 3.x import bridge: improvement to support the Microsoft Visio 2000 ERX export format and how it encodes the attributes description
-
UPDATE: Cognos 8 Content Manager import bridge:
- added new options and algorithms for the bridge to run in two modes: repository structure browser only, or repository structure and content
- removed dependency on the Cognos ReportNet SDK API
-
UPDATE: Embarcadero ER/Studio import bridge:
- now importing the unique ID for all major types of objects
- update to recognize a special case for Microsoft SQL Server specific attribute default values.
-
UPDATE: Informatica PowerCenter export bridge:
- fixed bug related to the target Database Type option where a user selection of a database type resulted in the selection of another database type
- fixed bug on metadata extensions (UDP), only user defined extensions are now exported
- UPDATE: Hyperion EIS import bridge: now removing empty (invalid) hierarchies
-
UPDATE: Informatica PowerCenter import bridge:
- improved support for lookup transformations
- fixed bug on metadata extensions (UDP), user defined versus system defined extensions are now correctly imported
- UPDATE: Microstrategy import bridge: fixed bug when two attributes have same name
- UPDATE: OracleDesigner import bridge: fixed bug on ForeignKey connected to AlternateKey in Physical models
- UPDATE: Popkin System Architect import bridges: fixed bug with models containing more than 12 diagrams, now properly closing each diagram
- UPDATE: Popkin System Architect export bridges: fixed infinite loop bug on a model with invalid PK/FK self-relationships (fishhook)
- UPDATE: Sybase PowerDesigner CDM import bridge: now gracefully detects and exits when the file is not XML as expected but binary
-
UPDATE: Sybase PowerDesigner PDM import bridge:
- added support for relationship role names for version 11
- fixed issue with owner schema of triggers and stored procedures
- now gracefully detects and exits when the file is not XML as expected but binary
- minor other improvements
- UPDATE: Sybase PowerDesigner PDM export bridge: added support for relationship role names for version 11
- UPDATE: XML Schema 1.0 export bridge: validation is improved to detect and avoid type name collisions and incorrect default attribute values.
v4.3.0 (10/21/2005)
- UPDATE: MIMB Wizard User Interface: added call to open the generated file when closing the wizard
- UPDATE: Improved support for internationalized strings in Java Native Interface for Java bridges
- UPDATE: Improved support for internationalized log messages, with appropriate encoding conversion
- UPDATE: MIRLicence installation tool: fixed bug specific to MIMB only keys
- UPDATE: BO Designer export bridge: fixed bug with attributes of length longer than 35 characters allowed by designer
-
UPDATE: CA ERwin 7.0 import and export bridges:
- many bug fixes and improvements to support version 7.0.0.1621 Beta
-
UPDATE: CA ERwin 4.x export bridge:
- improved target database mapping algorithm
- changed default target database to be ODBC when the model target database is not recognized or not supported by the tool
- updated datatypes mapping for better support of INTERVAL datatypes
- dropped support for older version of ERwin 4.0 and 4.1, now only supporting ERwin 4.1 SP2 (Build Number 2735) or higher
-
UPDATE: CA ERwin 3.x export bridge:
- improved target database mapping algorithm
- changed default target database to be ODBC when the model target database is not recognized or not supported by the tool
- improved datatype mapping for SQL 99 compliance
- UPDATE: Cognos 8 Framework Manager import and export bridges: now supporting Cognos 8.1 BMT 2.0
- UPDATE: Embarcadero ER/Studio import bridge: now supporting version 7.0
- UPDATE: Hyperion Essbase Integration Services export bridge: changed two options to be mandatory
- UPDATE: Informatica PowerCenter import bridge: improved support for multi-group transformations (router, union...)
- UPDATE: OMG CWM XMI export bridge: added new options to specify the CWMTFM and CWMOLAP namespaces
- UPDATE: OMG UML XMI export bridge: added support for Sparks Enterprise Architect
- UPDATE: Microstrategy import bridge: improved code in case the user session doesn't have enough rights to browse metadata
- UPDATE: W3C XML Schema export bridge: now avoiding to print the targetNamespace information when no value is provided as bridge parameter
v4.2.4 (09/30/2005)
-
UPDATE: CA ERwin 7.0 import and export bridges:
- many bug fixes and improvements to support version 7.0.0.1603 Beta
v4.2.3 (08/30/2005)
- NEW: Business Objects Repository import bridge: prototype version now available for versions 5.1.5 to 6.5
- NEW: CA ERwin 7.0 import and export bridges: prototype bridges now available for ERwin 7.0 Beta
- UPDATE: CA ERwin 4 ER1 export bridge: now using .ER1 (in upper case) as file extension to avoid download issues when running the bridge from a web user interfaces (MIMBWeb)
- UPDATE: Informatica PowerCenter import bridge: fixed bug when creating Connector FeatureMap when Feature name differs from physicalName.
- UPDATE: MIMB.exe MIMBDesktop.exe: now printing a warning in the log when the consistency validation is disabled
- UPDATE: Microsoft SQL Server 2005 Data Source View export bridge: various bug fixes
-
UPDATE: Microsoft SQL Server Analysis Services (DSO) import bridge:
- now importing the Cubes related CubeDimensions
- implemented expression parsing for more accurate lineage
- UPDATE: W3C XML Schema export bridge: added new Logical Export Methodology to the bridge with many new specific options
-
UPDATE: W3C XML Schema import bridge:
- added new algorithm and bridge option to import SubstitutionGroups as Generalizations
- fixed bug related to the path of included schema files
v4.2.2 (07/18/2005)
- UPDATE: Informatica PowerCenter import bridge: fixed bugs in FOLDERVERSION support for versions 5 and 6.
- UPDATE: Business Objects Designer import and export bridges: validated support for version 11.0 (XI)
- UPDATE: CA AllFusion ERwin Data Modeler import bridge: fixed bug on logical only UDPs.
- UPDATE: CA AllFusion Gen import bridge: fixed bug related to the temporary directory
- UPDATE: Cognos Series 7 Impromptu import bridge: added support for version 7.0.702
- UPDATE: IBM Rational Rose Data Modeler export bridges: improved export of enumerated Type Values
- UPDATE: JDBC import bridge: factorized two connection related options into a single "URL" option.
- UPDATE: OMG CWM export bridge: improved export of OLAP Dimensions with no levels, now creating a default level
- UPDATE: Microsoft SQL Server 2005 Data Source View import and export bridges: improvements and bug fixes to support the current "SQL Server June 2005 Community Technology Preview" version
- UPDATE: Microsoft SQL Server Analysis Services (DSO) import bridge: various improvements and bug fixes, support for SQL Server 2005 Analysis Services
- UPDATE: Select SE import bridge: added default DatabaseSchema to group all entities and views
- UPDATE: W3C XML Schema export bridge: various improvements and bug fixes, added new target system option for Altova XMLSpy
v4.2.1 (06/29/2005)
- NEW: fixed bugs related to Java Native Interface (JNI), the java bridges are now working with IBM JVM v1.4.2 Classic and J9VM
- NEW: added new AppendSystemClassPath configuration parameter in the MIRSetup.XML to control if the system CLASSPATH should be included or excluded
- NEW: all Java bridges (MIM, JDBC, Cognos 8 Content Manager) can now display the Java environment by specifying DEBUG_JAVA in the filepath
- NEW: W3C XML Schema export bridge: initial version supporting XSD 1.0 specification, plus Oracle and SQL Server specific extensions
- NEW: Microsoft SQL Server Analysis Services (OLAP) import bridge: prototype version with support for classifiers only (cubes, dimensions, and their lineage to tables)
-
NEW: improved algorithms for conversion of Default Values, Validation Rules, Constraints for the following bridges:
- CA ERwin 3.5 (ERX) export
- CA ERwin 4.x (XML) export
- Sybase PowerDesigner XML (CDM and PDM) 10.0 export
- UPDATE: JDBC import bridge: fixed bug on the import of Foreign Keys.
- UPDATE: CA ERwin 4 XML import bridge: fixed various bugs, tested with ERwin version 4.1.4 SP3
- UPDATE: Microsoft ADOMD / ODBO import bridge: tested support for SAS OLAP Server, improved option description with connection string example
- UPDATE: SilverrunRDM import bridge: improved import of Views with SQL statement and their View Columns
- UPDATE: Sybase PowerDesigner XML CDM and PDM import bridges: fixed regression bug about the file version detection
v4.2.0 (05/27/2005)
- NEW: The MIRVisualModelBridge executable has been renamed MIMBDesktop
- NEW: The MIRModelBridge executable has been renamed MIMB
- NEW: Improved configuration with conf/MIRSetup.XML file and MIRSetup executable
- NEW: Most libraries have been updated to use the latest Apache Xerces-C v2.6 XML parser and IBM ICU v3.2 Unicode library
- NEW: Most bridges DLLs have been renamed, the specification (Vendor, Methodology, File Format) have been updated
-
NEW: Extended MIR metamodel support for ETL metadata:
- improved Informatica PowerCenter import bridge: added support for ETL mappings and workflows
- Ascential DataStage import bridge: support of sources, targets and ETL jobs and sequences; support of XML and DSX file formats
- Ascential DataStage export bridge: support of sources and targets; support of DSX file format
-
NEW: Extended MIR metamodel support for Reporting metadata:
- BusinessObjects Reporter import bridge: import the report data queries and presentation layout
- Cognos 8 ReportStudio import bridge: import the report data queries and presentation layout
- Cognos 8 Content Manager import bridge: allows importing many models and reports stored in the ReportNet repository
-
NEW: Extended MIR metamodel support for Expressions:
- BusinessObjects Designer import bridge: added support of expression parsing
- BusinessObjects Designer export bridge: added support of expression parsing and conversion
- BusinessObjects Reporter import bridge: added support of expression parsing
- Cognos 8 FrameworkManager import bridge: added support of expression parsing
- Cognos 8 FrameworkManager export bridge: added support of expression parsing and conversion
- Cognos 8 ReportStudio import bridge: added support of expression parsing
- IBM DB2 CubeViews import bridge: added support of expression parsing
-
NEW: Extended MIR metamodel support for Data modeling:
- the new 'Logicaldatatype' property is now populated by the import bridges: ERwin 4
- added support for the concept of 'User-Defined Domain' and updated the bridges: ERwin 3, ERwin 4, ERStudio
-
NEW: Extended MIR metamodel support for BI and OLAP modeling:
- support for Ragged and Mixed OLAP Hierarchies:not implemented by bridges yet
- support for new concept of DrillPath (business intelligence hierarchies) and updated the bridges: BusinessObjects Designer, MicroStrategy
- improved modeling of Joins used by Dimensions.
- NEW: BusinessObjects Designer import and export bridges: added support for version 11.0
- NEW: MicroStrategy import and export bridges: added support for versions 7.5.0 and 8.0.0
- UPDATE: BusinessObjects Designer import bridge: added import of DerivedTables in v6.5 as schema layer dimensions.
- UPDATE: Embarcadero ER/Studio: fixed bug where the Views columns logical name and physical name was not properly imported
- UPDATE: Informatica PowerCenter import bridge: added datatypes support of flat files and SAP metadata
- UPDATE: MicroStrategy import bridge: fixed bug on sibling folders with same name, fixed bug on corrupted AttributeForms metadata
- UPDATE: Oracle Designer import bridge: fixed bug where Designer saved a domain twice in the DAT file
- UPDATE: Oracle Designer import bridge: fixed bug on some invalid DAT file lines, now allowing the bridge execution to finish
- UPDATE: Popkin SystemArchitect import and export bridges: added new options to specify the location of the encyclopedia
- UPDATE: Popkin SystemArchitect import and export bridges: fixed bug on old versions 7.x and 8.x
- UPDATE: SilverrunRDM import bridge: improved datatype mappings for SQL99 compliance
- UPDATE: Sybase PowerDesigner CDM import bridge: fixed bug where an AutoIncrement datatype was generated for a Foreign Key column
- UPDATE: many other bugs fixes and improvements
v4.1.6 (1/07/2005)
- UPDATE: MIMBWizard: added an option -l[ogo] to customize the tool with the image passed as parameter
- UPDATE: ERStudio import bridge: minor bug fixes and improvements
- UPDATE: ERwin 4.x import and export bridges: minor bug fixes and improvements
- UPDATE: SelectSE import bridge: improved import of rolenames on attributes
- UPDATE: Popkin SystemArchitect export bridge: added support for ER diagrams graphical information
v4.1.5 (12/01/2004)
- UPDATE: BusinessObjects Designer import and export bridges: the bridges now import and export the database schema graphical layout, for improved metadata exchange with modeling tools
- UPDATE: Cognos ReportNet Framework Manager import bridge: improved import of DBQueries physical tables name
- UPDATE: Cognos ReportNet Framework Manager export bridge: added a new bridge option to copy the description into the screentip property, so they appear in the ReportNet reporting tools
- UPDATE: Popkin SystemArchitect export bridges: the bridge can now export the Entity-Relationship diagrams graphical layout (positions and colors), for improved metadata exchange with modeling tools
- UPDATE: Sybase PowerDesigner CDM and PDM import bridges: minor bug fixes and improvements
- UPDATE: Sybase PowerDesigner 10 CDM and PDM export bridges: minor bug fixes and improvements, improved export of Descriptive fields with a new option value
v4.1.4 (11/24/2004)
- NEW: the MIMB SDK now includes the MIMBConsole sample application for Java
- NEW: ModelBridge: the bridges labels are now stored in a customizable XML configuration file
- NEW: CA ERwin 4.x import and export bridges: two new wrapper bridges now support the native ER1 file format.
- NEW: IBM DB2 v9 preview Data Models import and export bridges: beta release
- NEW: MicroStrategy export bridge: initial version supporting MicroStrategy 7.5.2
-
NEW: Sybase PowerDesigner PDM export bridge:
- new bridge optimized for PowerDesigner version 10
- added support for User Defined Properties (Extended Attributes)
- added support for OLAP metadata
-
NEW: Sybase PowerDesigner CDM 10 export bridge:
- added support for User Defined Properties (Extended Attributes)
- UPDATE: BusinessObjects Designer import bridge: changed the values of option 'Reverse engineer BI properties'
- UPDATE: CA ERwin 3.x import bridge: minor bug fixes
- UPDATE: CA ERwin 4.x import bridge: fixed import of Index Physical name, other minor bug fixes
-
UPDATE: Cognos ReportNet Framework Manager import bridge:
- added a new option to control the tables design level
- improved reverse engineering of joins into foreign key relationships
- UPDATE: IBM Rational Rose import bridge: minor bug fixes
- UPDATE: IBM Rational Rose export bridge: minor bug fixes
- UPDATE: IBM DB2 CubeViews import bridge: improved algorithm to import Aggregation Rules
- UPDATE: Informatica SuperGlue export bridge: many improvements and bug fixes
-
UPDATE: Popkin SystemArchitect import and export bridges:
- improved compilation parameters to run the bridge against any SA version greater than 9
- improved import bridge support for ER diagrams graphical information
- UPDATE: Sybase PowerDesigner CDM and PDM import bridges: minor bug fixes
- UPDATE: XML Schema import bridge: fixed bug related to empty XML sequences, fixed bug related to the file path
v4.1.3 (10/08/2004)
WARNING: all libraries have been recompiled because of improvements related to the bridge Manager library
- NEW: BusinessObjects Designer import and export bridges: added support for version 6.5
- NEW: Popkin SystemArchitect import and export bridges: added support for version 10.0
- NEW: Sybase PowerDesigner CDM export bridge: new bridge optimized for PowerDesigner version 10
- UPDATE: CA ERwin 4.x import bridge: improved support of Validation Rules enumerated values list of ERwin 4.1.4 SP2
- UPDATE: Embarcadero ER/Studio import bridge: minor bug fixes for generalizations and indices
- UPDATE: Informatica SuperGlue export bridge: various improvements for BI/OLAP tools
- UPDATE: MicroStrategy import bridge: various improvements
- UPDATE: OMG UML XMI import bridge: fixed bug when importing metadata from Gentleware Poseidon 2.5.1
- UPDATE: Oracle Designer import bridge: minor bug fixes
v4.1.2 (08/27/2004)
WARNING: The Meta Integration v4.1.2 tools now run on virtually any versions of Windows and Unix operating systems (currently packaged for Sun Solaris and Linux). Consequently, the source code has been upgraded for C++ 98 compliance, and therefore all libraries and executable have been recompiled (even when no modifications were performed).
- UPDATE: C++ code cleanup for strict compliance to ANSI C++ 98
- NEW: Debian GNU/Linux Testing (Sarge) version available
- UPDATE: Oracle Designer import bridge: various bug fixes and improvements
v4.1.1 (08/16/2004)
- NEW: CA Repository import and export bridges: prototype supporting the ODBC model
- NEW: MicroStrategy import bridge: initial version supporting MicroStrategy v7.5.2
- UPDATE: Model Subsetting: fixed bug when subsetting a model containing BusinessRules
- UPDATE: BI/ROLAP import bridges: changed description of import bridge option "Table design level" for easier understanding of what it does
- UPDATE: BusinessObjects Crystal 9.0 import bridge: fixed bug when reading the bridge options
- UPDATE: CA ERwin 3.x export bridge: now exports the Unique property for indices
- UPDATE: CA ERwin 4.x import bridge: fixed bug when opening a file with Japanese characters in its name
- UPDATE: CA ERwin 4.x export bridge: fixed bug when exporting a physical model to the Japanese ERwin version
- UPDATE: Cognos Impromptu import bridge: added workaround for unexpected exception thrown by the API when reading some alias tables and columns
- UPDATE: Cognos ReportNet Framework Manager: various bug fixes and improvements
- UPDATE: IBM DB2 CubeViews import bridge: added new option to control the mapping of objects' name and business name
- UPDATE: Sybase PowerDesigner CDM XML import bridge: fixed a relationship cardinality bug specific to version 10
v4.1.0 (07/23/2004)
- NEW: MIR XMI import and export bridges can generate and read XML compliant with the MIR XSD Schema based on XMI 2.0
- UPDATE: Java v1.4 is now the required version to run the MIMB software's java bridges
- UPDATE: BusinessObjects Designer import bridge: updated the list of supported databases
- UPDATE: CA COOL:Enterprise (ADW) import bridge: now import all Alphanumeric fields as CHAR instead of VARCHAR
- UPDATE: Cognos Impromptu import bridge: fixed bug related to Hotfile tables expressions
- UPDATE: Cognos ReportNet Framework Manager: fixed bug when exporting Joins and Shortcuts
- UPDATE: Hummingbird ETL import bridge: fixed bug related to alternate keys
- UPDATE: Hummingbird ETL export bridge: fixed bugs related to datatypes
- UPDATE: Informatica PowerAnalyzer export bridge: Beta version, many improvements to support both star schemas and operational schemas
- UPDATE: Informatica PowerCenter export bridge: now export the business names only if set explicitly
- UPDATE: IBM Rational Rose import bridge: fixed bug related to foreign keys
- UPDATE: OracleDesigner export bridge: now truncates description of enumerated type values if longer than allowed by the tool
- UPDATE: Sybase PowerDesigner CDM and PDM XML import bridges: now imports comment as comment, notes:description as description and notes:annotations as notes
- UPDATE: XML DTD and Schema import bridges: added an option to customize the name of PCDATA element content
v4.1.0 Release Candidate 1 (07/03/2004)
- UPDATE: renamed the Expat XML parser library to avoid conflicts with third party software.
- UPDATE: BI import bridges: improved optional algorithm to reverse engineer Dimensional properties onto relational objects
- UPDATE: added support for many more encodings
- UPDATE: IBM DB2 CubeViews export bridge: the option 'Dimensional Schema' is now mandatory
- UPDATE: Oracle Designer export bridge: fixed a bug related to long domain name renaming
- UPDATE: Relational Database via JDBC import bridge: various adjustments to the bridge options
- UPDATE: Hyperion EIS export bridge: fixed datatype mapping of DATETIME, added an option to specify the connection name
v4.1.0 Beta3 (06/17/2004)
- NEW: improved datatype system for SQL99 compliance
- NEW: the MIMB SDK now defines a 'Mandatory' boolean property for bridges options
- UPDATE: VisualModelBridge: fixed bug related to the bridge options values saved in the registry
- UPDATE: Business Objects Designer import bridge: added native support for alias tables
- UPDATE: CA ERwin 3.x export bridge: fixed bug related to the encoding option
- UPDATE: CA ERwin 4.x import bridge: fixed import of Index related UDPs
- UPDATE: Cognos Impromptu import bridge: added native support for alias tables, various other improvements
- UPDATE: Cognos ReportNet FrameworkManager import & export bridges: added native support for shortcuts
- UPDATE: Embarcadero ER/Studio import bridge: updated detection of the physical models target database
-
UPDATE: Hummingbird ETL import & export bridges:
- improved datatype support and externalized the mapping as XML file
- added support for version 5.1
- UPDATE: IBM Rational Rose import bridge: fixed bug on Notes
- UPDATE: Informatica SuperGlue export bridge: various improvements
- UPDATE: Informatica PowerCenter import & export bridges: added support of Metadata Extensions
- UPDATE: OMG CWM import bridge: added support for SAS ETL Studio in the Target Tool bridge option
- UPDATE: OMG CWM export bridge: fixed datatype issue for Oracle Warehouse Builder
-
UPDATE: Popkin System Architect import and export bridges:
- added support for version 9.1.40
- fixed bug related to the UDL import file path for version 9.0 and greater
-
UPDATE: Relational Database via JDBC import bridge:
- improved bridge architecture to allow setting the options as regular model bridge options
- improved support for JDBC Catalogs and Schemas
- added support for IBM DB2 Information Integration NICKNAME tables
- added option to import synonyms
-
UPDATE: Sybase PowerDesigner CDM & PDM XML import bridges:
- added import of Extended Attributes as User Defined Properties, and new bridge option to control it
- added new option to control how the Rich Text Formatting (RTF) text should be processed
- added support for new databases and datatypes of version 10.0
- fixed bug on Annotations
v4.1.0 Beta 2 (05/14/2004)
- NEW: Embarcadero ERStudio 6.5 Beta provides a metadata integration solution based on MIMB
- NEW: Business Objects Crystal Reports 9.0 import bridge: alpha version with import of tables and columns used in the report
- NEW: The MIMB VB SDK sample wizard application can now be launched as AddIn inside IBM Rational Rose
- UPDATE: VisualModelBridge: updated model viewer icons
-
UPDATE: JDBC import bridge:
- added new option to enable or disable import of system tables
- added new option to enable or disable import of stored procedures
- UPDATE: CA ERwin 3.x import bridge: fixed a bug related to ERX file generated by Microsoft Visio
- UPDATE: CA ERwin 4.x import bridge: fixed a bug related to the index members sort order.
- UPDATE: Cognos Impromptu import bridge: now in Beta mode, added support of Catalogs using multiple databases or Hotfiles
- UPDATE: Informatica SuperGlue export bridge: various bug fixes and improvements
- UPDATE: OMG CWM XMI import bridge: added support for files generated by SAS ETL Studio
- UPDATE: Sybase PowerDesigner CDM & PDM XML import bridges: minor updates to support version 10.0
v4.1.0 Beta 1 (05/03/2004)
- UPDATE: Model Subsetting: fixed a bug causing the ERwin 3.x export bridge to fail
- UPDATE: CA ERwin 4 import bridge: added support for new DB2 databases available in ERwin 4.1.4
- UPDATE: Cognos Impromptu import bridge: added import of Joins, various other improvements
-
UPDATE: Embarcadero ER/Studio import bridge:
- better support of models with multiple physical catalogs
- added support for ER/Studio 6.5 dimensional modeling
- UPDATE: Hummingbird ETL import and export bridges: various improvements and bug fixes
- UPDATE: IBM DB2 CubeViews import & export bridges: added support for CubeViews version 8.2
- UPDATE: Informatica SuperGlue export bridge: various improvements and bug fixes
- UPDATE: Microsoft Yukon DSV import bridge: removed unnecessary XML Schema specific options
- UPDATE: OMG CWM import & export bridges: various improvements and bug fixes
- UPDATE: Sybase PowerDesigner PDM XML import bridge: improved support of OLAP metadata
v4.0.9 (04/09/2004)
- UPDATE: BusinessObjects export bridge: added new options to better control the export of objects names, joins and hierarchies
- UPDATE: CA ERwin 4.x import bridge: fixed bug on SQL view columns datatypes
- UPDATE: Embarcadero ERStudio import bridge: added support for stored procedures
- UPDATE: Hummingbird ETL import and export bridges: various bug fixes
- UPDATE: Informatica SuperGlue export bridge: various improvements and bug fixes
v4.0.8 (03/23/2004)
- NEW: OLAP Database via OLE DB for OLAP import bridge: alpha version, tested with Microsoft SQL Server 2000 Analysis Services
- UPDATE: CA ERwin 4.x export bridge: minor bug fixes
- UPDATE: Embarcadero ERStudio import bridge: bug fixes on Indexes, RoleNames
- UPDATE: Hummingbird ETL import bridge: fixed detection of the database type
- UPDATE: Hummingbird ETL export bridge: added support for views, stored procedures and datatypes
- UPDATE: IBM Rational Rose import bridge: fixed a memory leak, support for Rose 2003.
- UPDATE: Informatica SuperGlue export bridge: various improvements and bug fixes
- UPDATE: OMG CWM import bridge: better support for OLAP Level Keys of Oracle Warehouse Builder
- UPDATE: OracleDesigner import bridge: fixed a memory leak
v4.0.7 (03/12/2004)
- NEW: Hummingbird ETL export bridge: beta support for version 5.1
- UPDATE: Business Objects Designer import bridge: fixed regression bug related to the import of joins.
- UPDATE: Business Objects Designer export bridge: performance improvements, fixed a bug on joins cardinality.
- UPDATE: CA ERwin 3.x export bridge: now escapes control characters when printing text in the ERX file.
- UPDATE: CA ERwin 4.x import & export bridge: added support for Japanese version of the tool
- UPDATE: Informatica PowerCenter import & export bridges: various improvements and bug fixes
v4.0.6 (03/08/2004)
- NEW: Cognos Impromptu import bridge: alpha support for version 7.1
- NEW: Hummingbird ETL import bridge: beta support for version 5.1
- NEW: Hyperion Essbase Integration Services export bridge: alpha support for version 7.0
- NEW: Meta Integration XMI (XML) export bridge: beta version
- UPDATE: MIMB SDK: improved the Visual Basic demonstration wizard
- UPDATE: License Key: fixed a bug showing an "invalid license key" message box.
- UPDATE: CA ERwin 3.x and 4.x export bridges: added support for Japanese character encoding and the Japanese version of ERwin.
- UPDATE: Business Objects Designer import bridge: performance improvements, added new option to import List Of Values.
- UPDATE: Cognos ReportNet FrameworkManager import & export bridges: various bug fixes and improvements
- UPDATE: IBM DB2 Cube Views import bridge: fully tested the bridge against the CubeViews Testing Suite
- UPDATE: OMG CWM XMI import and export bridges: various bug fixes and improvements
- UPDATE: Sybase PowerDesigner CDM & PDM XML import bridges: better factorization of types
- UPDATE: W3C XML Schema & DTD import bridges: fixed minor bug when generating default diagram
v4.0.5 (02/06/2004)
- NEW: MIMB SDK: a new type of option is now available for storing passwords.
- NEW: Hyperion Essbase Integration Services import bridge: alpha support for version 7.0
- UPDATE: CA COOL:BusinessTeam import bridge: added support for the DOS (IBM850) encoding.
- UPDATE: Cognos ReportNet FrameworkManager import and export bridges: various bug fixes and improvements
- UPDATE: Informatica PowerCenter import & export bridges: added support for version 7.1
- UPDATE: OMG CWM XMI import & export bridges: bug fixes related to the CWM:OLAP metadata
- UPDATE: Sybase PowerDesigner PDM XML import bridge: minor patch for versions 9.5.x
v4.0.4 (01/23/2004)
-
NEW: MIMB now includes the MIMB SDK for C++, Java and VisualBasic, and open source applications:
- MIMBWeb implements the Java SDK and allows running MIMB as a Web/Intranet service
- MIMBConsole implements the C++ SDK and allows running MIMB as a DOS console application
- MIMBWizard implements the VisualBasic SDK and provides a sample GUI wizard for running MIMB
- NEW: the MIMB SDK can now use an XML configuration file to control the display of bridges
- UPDATE: fixed a bug in the metadata validation algorithm related to UML qualifier attributes
- UPDATE: BusinessObjects Designer import & export bridges: added support for version 6.1
- UPDATE: CA COOL:Gen import bridge: when importing a physical data model, the bridge now retrieves tables and columns descriptions defined in the logical model
- UPDATE: CA ERwin 4 import bridge: added a new option to control the import of relationship names
- UPDATE: Cognos ReportNet FrameworkManager import and export bridges: various bug fixes and improvements
- UPDATE: Informatica PowerCenter import bridge: added support for version 7
-
UPDATE: Popkin SystemArchitect import and export bridges:
- added support for version 9.1.13
- added new log messages to better document the conversion process
- improved the bridges tooltip
- UPDATE: Sybase PowerDesigner PDM XML import bridge: added initial support for Multidimensional diagrams (OLAP modeling)
v4.0.3 (12/19/2003)
- UPDATE: ERwin4 import bridge: fixed a bug related to the import of attributes default value
v4.0.2 (12/15/2003)
- UPDATE: fixed a bug when converting UTF8 strings
- UPDATE: updated License Key Install utility bridge labels
- UPDATE: Business Objects Designer import bridge: fixed a problem related to the qualifier/catalog information
- UPDATE: Business Objects Designer export bridge: fixed a problem when exporting Cube measures
- UPDATE: CA COOL:Gen import bridge: changed foreign key attributes generation rules when importing logical models
- UPDATE: Cognos ReportNet Framework Manager import & export bridges: various updates and bug fixes
- UPDATE: Sybase PowerDesigner CDM & PDM XML import bridges: fixed problem with empty type values
v4.0.1 (11/21/2003)
- UPDATE: improved MIMB documentation and bridges tooltips
-
UPDATE: improved import algorithm of User Defined Properties (UDP),
the following bridges now benefit from a common import option and values:
- CA ERwin 3.x import bridge
- CA ERwin 4.x import bridge
- Embarcadero ERStudio import bridge
- IBM Rational Rose import bridge
- Oracle Designer import bridge
-
UPDATE: the table's Dimensional Role property is now exported in the following bridges:
- CA ERwin 3.5 export bridge
- CA ERwin 4.x export bridge
- Oracle Designer 6i & 9i export bridge
- Sybase PowerDesigner PDM XML export bridge
- UPDATE: Cognos ReportNet Framework Manager export bridge: fixed bug related to the Catalog and Schema information
- UPDATE: Business Objects Designer export bridge: added warning message when a column cannot be detected via the database connection
- UPDATE: Embarcadero ERStudio import bridge: fixed bug when importing foreign keys
- UPDATE: CA COOL:BusinessTeam (Groundworks) import bridge: fixed bug when deleting invalid foreign keys
- UPDATE: CA COOL:DBA (Terrain for DB2) import bridge: added support for Tablespace encoding in recent versions of the VAR file format
- UPDATE: Silverrun RDM import bridge: added support for new databases versions and datatypes
- UPDATE: Sybase PowerDesigner CDM and PDM XML import bridges: added workaround for invalid characters at the beginning of some XML files
v4.0.0 (10/24/2003)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: new version 4.0 of the MIR Metadata Repository metamodel and SDK for improved support of OLAP, BI and ETL concepts
-
NEW: VisualModelBridge:
- added support for SQL Views, Dimensions and Cubes in the model viewer, subsetting and finder
- added an entry in the Help menu and a toolbar button to start the License Key Install tool
-
NEW: All bridges:
- improved bridges to support OLAP, BI and ETL concepts as defined by the new MIR metamodel
- corrected some typos and spelling issues in the bridges options, tooltip and log messages
- The bridges now support metadata encoding conversion
- NEW: new import and export bridges for Cognos ReportNet Framework Manager
- NEW: new import and export bridge for Microsoft Yukon Data Source View
- NEW: new import bridge from Embarcadero ERStudio 5.1 to 6.0
- NEW: new export bridge to Informatica PowerAnalyzer v4.0 (Alpha)
- NEW: OMG CWM 1.0 XMI import and export bridges: now supports Oracle Warehouse Builder 10g OLAP metadata
- NEW: NCR Teradata MDS import and export bridges: added support for version 5.1
- NEW: JDBC import bridge: added support for DB2/UDB and improved support for various datatypes
- UPDATE: Informatica PowerMart/PowerCenter import/export bridges: full support for relational metadata
- UPDATE: IBM DB2 Cube Views import bridge: Added an option to select the design level of the database tables
- UPDATE: OMG CWM 1.0 XMI export bridge: fixed a bug related to the export of the UUID property
- UPDATE: ERwin 4 export bridge: fixed a bug related to the Note2 property
- UPDATE: Sybase PowerDesigner CDM XML import bridge: now supports generalizations as defined in new version 9.5.2
-
UPDATE: Popkin SystemArchitect export bridge:
- fixed an issue related to the diagrams of SA v9
- fixed an issue with the export of logical attributes comment property
- now escapes the '-' character and quotes the objects names
-
UPDATE: Select SE import bridge:
- Default value are now set only if specified by the HasDefaultValue property
- fixed an issue related to the association role names
-
UPDATE: Oracle Designer import bridge:
- added an option to filter the ER Model entities or the Server Model tables
- fixed an issue with the import of logical attributes comment property
-
UPDATE: BO Designer import bridge:
- fixed a bug related to the universe Qualifier/Catalog support
- added an option to control the import of the Classes and subClasses tree structure
- added an option to close or keep Designer open after the bridge has run
-
UPDATE: BO Designer export bridges:
- added an option to choose the dimensions export algorithm: none, create, replace or update
- added an option to close or keep Designer open after the bridge has completed
- UPDATE: W3C XML Schema import bridge: added some code to read XSD files only once even if included multiple times
v3.1.2 (06/19/2003)
- UPDATE: IBM DB2 Cube Views import bridge: added reverse engineering of Joins
- UPDATE: IBM DB2 Cube Views export bridge: better support for snow flake and multi-star models
- UPDATE: OMG CWM XMI import bridge: better support for IBM Warehouse Manager CWM files
- UPDATE: CA ERwin 4 import bridge: better support for blank type values (for models created in ERwin 3.x)
- UPDATE: IBM Rational Rose 4.0 import bridge: A memory leak was sometimes causing the bridge to fail
- UPDATE: NCR Teradata MDS import and export bridges: fixed a regression due to the previous changes
v3.1.1 (05/29/2003)
- UPDATE: IBM DB2 Cube Views import and export bridges: various improvements
- UPDATE: NCR Teradata MDS import and export bridges: the bridges libraries can now be loaded even if MDS is not installed
v3.1.1 Beta (05/22/2003)
- UPDATE: all export bridges generating XML files, to support data encoding conversion. These bridges now write XML files encoded in UTF8
- UPDATE: System Architect import bridges: now accepts a directory or a file path as input path (only the directory path was supported before)
- UPDATE: BusinessObject Designer import bridge: now concatenates the select and where statements in one property
- UPDATE: BusinessObject Designer export bridge: added support for forward engineering of design tools' DataWarehouse flags (Fact, Dimension...)
- UPDATE: various bridges: fixed typos in tooltip or option's description
v3.1.0 (04/30/2003)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: IBM DB2 Cube Views import and export bridges
- UPDATE: Java API to invoke C++ bridges from a Java application: cleaned-up and documented new methods
- UPDATE: many bridges: updated tooltips and harmonized messages and option descriptions
- UPDATE: BO Designer import bridge: fixed a bug related to joins attached to one table only
v3.1.0 RC1 (04/25/2003)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- UPDATE: all bridges: updated tooltips and harmonized messages and option descriptions
v3.1.0 Beta (04/22/2003)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: Popkin System Architect import and export bridges: added support for version 9.0.19
- NEW: Oracle Designer, PowerDesigner PDM XML, ERwin 3.x, ERwin 4.x import bridges: imports the Data Warehouse table roles as user defined properties
- UPDATE: most XML export bridges: added support for two more character sets (Korean and Japanese)
-
UPDATE: Oracle Designer export bridge:
- now prints the logical entity physical name into the plural name field
- when generating a Logical model, exports the Comment property as a Note
- now truncates the Domains comment if longer that supported by the tool
- added an export option to control the Commit frequency, for easier debugging
-
UPDATE: Oracle Designer import bridge:
- better support of models with external references
- fixed an incorrect double quote handling
- UPDATE: Terrain Map import bridge: added support for multiple encodings (formats) of the mapping information
-
UPDATE: Groundworks import bridge:
- added support for REFLEXIVE relationships (using twice the same partnership set)
- added support for Notes for Sterling Bsnteam V7.2
- UPDATE: PowerDesigner PDM XML export bridge: datatypes applied directly to attributes were not exported properly
-
UPDATE: PowerDesigner PDM XML import bridge:
- library did not load properly on Unix
- better support of models with external references
-
UPDATE: ERwin 3.x import bridge:
- improved the Informix datatype mapping
- added support for DB2 UDB v5 in ERwin 3.52
- added import of the Model Definition
- UPDATE: ERwin 4.x import bridge: now retrieves the Optional property of an Attribute when importing a Logical Only model
-
UPDATE: Informatica export bridge:
- now correctly set the values for UNIQUE of TARGETINDEX
- added a warning message for the case of an attribute involved in multiple Foreign Keys, and now exports only the first Foreign Key
- UPDATE: XMI UML export bridge: added export of Type Values as Attributes
-
UPDATE: BO Designer import bridge:
- added support for catalogs and alias tables in the traceability algorithm
- added import of ListOfValues for dimensions
- UPDATE: BO Designer export bridge: improved support for Owner/Schema and Qualifier/Catalog, better support for SQL Server2000 and Oracle databases
- UPDATE: System Architect import bridge: added import of the properties Attribute::Data and Entity::Purpose
-
UPDATE: COOL:Gen import bridge:
- fixed bug occurring when printing log messages
- Physical Model: better computes the aggregation property on a relationship and the association role multiplicity based on the optionality of the foreign key attributes
v3.0.10 (02/24/2003)
- NEW: Informatica PowerMart & PowerCenter XML export bridge: alpha version
- NEW: COOL:Gen import and export bridges: added support for Advantage Gen version 6.5
-
UPDATE: Business Objects import and export bridge:
- added support for version 5.1.6
- added options to specify the login parameters, in case of a repository installation
- added an option to specify how classes and dimensions should be imported
- fixed a COM related issue
- fixed an option default value related issue
-
UPDATE: ERwin 4 export bridge:
- now sets a default font size of 10 if it is not set
- The description and comment of an AssociationRole are now exported along with those of its Association
-
UPDATE: ERwin 4 import bridge:
- minor improvements to support the latest version of ERwin 4.1
- added support for relationships between views
- UPDATE: XMI/CWM export bridge: Now exports both a Object Model and a CWM Catalog when the option "UML and RDB" is selected
- UPDATE: PowerDesigner 6.1.1 CDM and PDM import bridges: fixed a bug related to empty enumerated type values
- UPDATE: XMI/CWM export bridge: added support for the 'UTF-8' encoding
- UPDATE: XMI/CWM, XMI/UML, XIF, MDC, Informatica import bridges: fixed a parsing problem related to UTF-8 characters
-
UPDATE: XMI/UML import bridge:
- Added support for UML 1.4 and XMI 1.2
- Added support for Embarcadero Describe v5.8+
- Added support for Gentleware Poseidon 1.5
-
UPDATE: COOL:Xtras Mapper (TerrainMap for DB2) import bridge:
- improved support for the various VAR encoding versions of the traceability information
- now displays in the log if the logical and physical models do correspond to each other
- UPDATE: COOL:BusinessTeam (Groundworks) import bridge: now creates only one generalization per parent entity
v3.0.9 (01/27/2003)
-
UPDATE: improved the MIRNativeConvert Java Class for better OEM integration:
- Added a method, importFile, to import a model in java from a C++ bridge
- Cleaner interface and implementation to import and export a model
-
UPDATE: OracleDesigner import bridge:
- improved the bridge for models with dangling relationship ends
- fixed a bug related to the import of attributes datatype information
- fixed a bug where the logical relationships linked to a non-primary identifier were wrongly considered as aggregation
- now imports the 'help text' of attributes as description
-
UPDATE: BusinessObjects Designer import and export bridges:
- new export algorithm that supports the update of an existing universe
- improved support for the notions of Owner/Schema and Qualifier/Catalog
- added import of BO Dimensions and Classes as MIR Attributes and Classes
- UPDATE: Rational Rose DataModeler import bridge: Diagrams in a Package were renamed even when there was no unique name conflict
-
UPDATE: Rational Rose DataModeler export bridge:
- Fixed a bug when exporting generalization subtypes without foreign keys
- Now correctly exports User Defined Property values that contain quotes
- UPDATE: COOL:Gen import bridge: the source association role was not always correctly set for 1..1 relationships
-
UPDATE: ERwin 4.x import bridge:
- UTF-8 characters are now properly imported
- Updated target databases and datatypes available in the latest ERwin 4.1, added support for SAS
- UPDATE: PowerDesigner CDM & PDM, XMLSchema import bridges: now correctly use the options default value
- UPDATE: Sybase PowerDesigner PDM import bridge: improved support for models with external shortcuts
- UPDATE: Sybase PowerDesigner CDM export bridge: now correctly sets the dominant role for 1..1 relationships
- UPDATE: Sybase PowerDesigner CDM and PDM export bridges: improved renaming conventions of objects
-
UPDATE: XMI/UML import and export bridges:
- added support for XMI 1.1
- now supports import and export of Sybase PowerDesigner 9.0 to 9.5 OOM models via XMI
- now supports import of Computer Associates AllFusion Component Modeler 4.1 models via XMI
- UPDATE: CWM export bridge: Added an option to generate CWM 1.1 models
v3.0.8 (01/03/2003)
- NEW: NCR MDS import and export bridges: added support for NCR Teradata MDS 5.0
- NEW: XMI/UML import bridge: added support for Microsoft Visio
- UPDATE: Rose Data Modeler import and export bridges: indexes are now fully supported
- UPDATE: Sybase PowerDesigner CDM and PDM XML import bridges: improved support for external shortcuts
-
UPDATE: Business Objects Designer 5.1.5 export:
- Added support for version 5.1.3
- Added the login identification, required for a multi-user installation of BusinessObjects
- Now also export the comment if any
- UPDATE: Silverrun import bridge: Added an option to specify if the file should be opened as binary or text mode
- UPDATE: COOL:Gen import bridge: Added an option to let the user choose how the datatypes of logical data model should be converted
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: fixed a bug related to foreign keys
-
UPDATE: COOL:BusinessTeam (Groundworks) import bridge: changed some datatypes conversions:
- String datatypes are now converted to CHAR if they have the same minimum and maximum length, VARCHAR otherwise
- Integer datatypes are now converted to SMALLINT if their maximum value is smaller than 9999, INTEGER otherwise
-
UPDATE: COOL:DBA (TerrainMap for DB2) import bridge:
- Improved handling of keys, indexes, associations and generalizations when merging models
- Added a set of options to report the status of the merge process in the log window
-
UPDATE: Oracle Designer export bridge:
- The physical comments are now always converted
- The uniqueness of domain names is now properly enforced
- A problem in the definition of alternate keys was fixed
- UPDATE: Select SE import bridge: now sets attributes of empty foreign keys based on primary key attributes physical name
- UPDATE: ERwin 3.x import bridge: added support for target databases found only in ERwin 3.5.2
v3.0.7 (11/22/2002)
- UPDATE: Oracle Designer import bridge: Better handling of incorrect relationships
- UPDATE: MIRModelBridge executable: fixed a problem related to the subsetting option
- UPDATE: Subsetting: fixed a bug related to the subsetting of XML DTD/Schema models
- UPDATE: XML Schema import bridge: better handling of included schemas path, added an option to specify their location
- UPDATE: Informatica PowerMart import bridge: if datatype is integer and there is a length, the datatype is converted to numeric
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: added support for the "Bachman DB2 V8.1" file version
- UPDATE: ERwin 4 export bridge: now export Foreign Key index only if the Foreign Key is exported
-
UPDATE: Rose Data Modeler import bridge:
- Fixed a bug in the import of nested CAT files
- Fixed a bug in the import of packages in CAT files
- Fixed a bug in the import of DM operations
v3.0.6 (11/06/2002)
- NEW: PowerDesigner CDM & PDM import bridges: added support for version 9.5
- UPDATE: Installer: improved detection and handling of errors related to the Windows registry
- UPDATE: MIRModelBridge command line executable: fixed a bug related to the subsetting feature
-
UPDATE: ERwin 3.x import bridge:
- Attributes and SQL View Attributes can now inherit their description from their domain
- fixed a regression bug related to physical ids
- fixed a bug related to the import of foreign keys from ERwin 3.0 models
- now correctly imports SQL View Entities name from ERwin 3.0 models
- UPDATE: ERwin 4.x import bridge: now correctly imports empty UDP enumerated values
- UPDATE: ERwin 4.x export bridge: now correctly exports transformed generalizations for all ERwin versions
-
UPDATE: Oracle Designer import bridge:
- fixed a bug related to the import of SQL View Attributes domains
- fixed a bug related to the import of SQL View Entities
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: fixed a bug related to the import of foreign keys, improved related error message
- UPDATE: CWM export bridge: added an option to not export the indexes associated to keys
v3.0.5 (10/18/2002)
- NEW: Business Objects Designer 5.1.5 import and export bridges: beta version
- NEW: Sybase PowerDesigner CDM & PDM export bridges: added support for version 9.5
- NEW: Oracle Designer import and export bridges: added support for version 9i
- NEW: COOL:DBA (TerrainMap for DB2) import bridge: beta version
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: minor bug fixes
- UPDATE: COOL:BusinessTeam (GroundWorks) import bridge: fixed a bug related to the import of diagrams
- UPDATE: COOL:Gen export bridge: now exports some physical information in logical relationships description
- UPDATE: COOL:Enterprise (ADW) import bridge: description lines with a starting space character were not imported
- UPDATE: ERwin 4.x import bridge: minor improvements, added support for new Teradata datatypes available in ERwin 4.1
- UPDATE: ERwin 3.x import bridge: fixed a bug related to the import of generalizations
- UPDATE: W3C XML Schema import bridge: minor bug fixes and updates, fixed a regression in the generation of the id attributes
- UPDATE: Sybase PowerDesigner CDM and PDM XML export bridges: fixed a bug related to the export of packages
- UPDATE: Sybase PowerDesigner CDM XML export bridges: fixed a bug related to the export of attribute's datatype
-
UPDATE: Oracle Designer import bridge:
- when importing logical data models, now creates only one generalization per supertype entity
- fixed a bug related to the import of views with keys
- reworked the logical relationships import algorithm
- UPDATE: Informatica PowerMart 5.1 (MX2 XML) import bridge: added support for DB2 datatypes
- UPDATE: Select SE import bridge: better manage attribute names to avoid name clashes
v3.0.4 (09/06/2002)
- NEW: SystemArchitect 2001 import and export bridges: added support for version 8.8.13
-
NEW: XML Schema import bridge release version
- added support for Microsoft XDR schemas
- now supports the include mechanism
- various bug fixes and improvements
- UPDATE: Subsetting: fixed a bug related to the subsetting of some generalizations and improved the subsetting of diagrams
- UPDATE: Validation: added the name of the parent object to the name of the object in error messages
- UPDATE: JDBC import bridge: now imports the Oracle owner, sid, server name and server domain properties
- UPDATE: COOL:Gen import bridge: fixed a bug related to the import of physical models foreign keys
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: now prefixes the view name with the owner name in the view SQL statement
- UPDATE: COOL:BusinessTeam (GroundWorks) import bridge: improved the way the position is set on migrated attributes
- UPDATE: Silverrun RDM import bridge: added support for AS/400 Synon/2E datatypes
- UPDATE: XMI/UML import bridge: now supports the multiplicities as defined by ArgoUML version 0.9 and higher
-
UPDATE: XMI/CWM RDB export bridge:
- now exports some Oracle specific properties as Tagged Values
- stored procedure's namespace property now correctly links to the owner schema
-
UPDATE: ERwin 3.x import bridge:
- now imports the logical and physical name of indices if found in the file
- the 'Date/Time' datatype for MS Access databases is now imported as SQL_TIMESTAMP MIR datatype instead of SQL_TIME
-
UPDATE: ERwin 4.x import bridge:
- now opens the XML file in binary mode to work around some invalid characters written in the file
- improved detection and handling of the ERwin 4 XML file version, added support for file version 4003
- improved filtering of graphical objects to remove unnecessary presentation elements from diagrams
- added support for datatypes and databases supported by ERwin 4.1
-
UPDATE: ERwin 4.x export bridge:
- changed the datatype of the default domains to be the same as the default ones in ERwin
- added support for datatypes and databases supported by ERwin 4.1
- UPDATE: XML DTD import bridge: did not set the associations aggregation property when Id attributes were not generated
- UPDATE: Oracle Designer import bridge: fixed a bug related to the import of some one-to-one relationships in logical models
-
UPDATE: Oracle Designer export bridge, export of physical models:
- foreign keys associated to generalizations are now correctly exported
- fixed a bug related to the export of some enumerated type values
- now correctly sets the "Mandatory" property of foreign keys
v3.0.3 (07/12/2002)
- NEW: W3C XML Schema import bridge: beta version
- NEW: Informatica PowerMart 5.1 (MX2 XML) import bridge: beta version
-
UPDATE: Rose Data Modeler export bridge:
- For Sybase and SQL Server target, datatype MIR_SQL_DATE is now mapped to SMALLDATETIME
- The Comment property is now exported in the Physical Data Model
-
UPDATE: ERwin 4 export bridge:
- The SQL Statement associated to a View was sometimes exported incorrectly
- Changed the mapping of Oracle datatypes to use VARCHAR2 instead of VARCHAR
-
UPDATE: Database via JDBC import bridge:
- Fixed a NullPointerException if a Catalog is specified but the Database does not support the concept
- MS Access database: Attribute in Primary Key are now always imported as mandatory
- MS SQL Server and Oracle databases: A cursor was not closed
- UPDATE: Rose import bridge: improved mapping of Java datatypes
-
UPDATE: Select SE import bridge: added an option to specify the default value for the "Create Constraint" property.
WARNING: the default value of the option changes the behavior of the bridge: constraints are now always created unless specified otherwise - UPDATE: COOL:Gen import bridge: Derived attributes are now imported as Logical Only attributes
- UPDATE: COOL:BusinessTeam (Groundworks) import bridge: import of graphical information was not correct for older versions of Groundworks
- UPDATE: CWM export bridge: the "namespace" property was incorrectly set if the model contained a MIR Schema
- UPDATE: COOL:DBA (Terrain for DB2) import bridge: now adds 'CREATE VIEW' at the beginning of the SQL statement of an SQL View if it does not start with it
- UPDATE: Meta Integration Works export bridge: large models were sometimes incorrectly converted from C++ to Java
- UPDATE: Model Subsetting: when subsetting a diagram or package, the associations between the exported classes are exported as well, whether they are in the Diagram/Package or not
v3.0.2 (06/12/2002)
- NEW: COOL:DBA (Terrain for DB2) import bridge: now imports the model's graphical information
- NEW: COOL:BusinessTeam (Groundworks) import bridge: now imports the model's graphical information
- NEW: import bridge from Informatica PowerMart 5.1 (MX2 XML): alpha version
- NEW: improved MIMB graphical interface: added the Advanced Options window to support a new metadata custom update algorithm
-
UPDATE: ERwin 4 import bridge:
- The model name is now computed from the file name, as a workaround of a bug in ERwin 4
- Added support for the previously unknown relationships constraint rules codes imported from a legacy ERwin 3.x model
- UPDATE: ERwin 4 export bridge: now export correctly the relationships constraint rules
- UPDATE: Oracle Designer export bridge: now commits foreign keys more frequently during the import of the DAT file in the repository
- UPDATE: PowerDesigner CDM & PDM import bridges: various bug fixes and better support for the recursive XML file format
- UPDATE: COOL:Enterprise (ADW) import bridge: better detection of attributes not connected to the model
v3.0.1 (05/17/2002)
-
NEW: The following bridges now support the notion of SQL View on (associated to) SQL Views:
- Rose DM export bridge
- ERwin 4 export bridge
- PowerDesigner PDM XML import and export bridges
-
UPDATE: ERwin 4 import bridge:
- fixed a bug related to the DB2/UDB 5 database
- improved support for legacy models imported from ERwin 3.x
- improved preprocessing of the XML file to remove binary characters
- improved support for models using the Information Engineering notation
- UPDATE: ERwin 4 export bridge: improved the way ERwin predefined domains are exported
-
UPDATE: Oracle Designer import bridge:
- fixed a bug related to the association aggregation property
- improved support of incomplete models (referencing objects undefined in the DAT file)
- added more explicit warning messages
-
UPDATE: NCR MDS export bridge:
- added periodic commits to avoid locking the repository for too long
- added an option to delete the destination database, if it already exists
- UPDATE: Rose DM import bridge: improved support for import of integrated object/data models
-
UPDATE: Rose DM export bridge:
- fixed a bug related to the export of enumerated types
- fixed a bug related to the export of domains
- added support for generalizations in data models
- UPDATE: Sybase PowerDesigner 6.1 import bridge: fixed a problem related to associations cardinality
v3.0.0 (04/29/2002)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- The import and export menu labels were updated. You may need to re-set your preferences
- NEW: Popkin System Architect import and export bridges: added support for version 8.5.24
-
NEW: PowerDesigner CDM & PDM XML import and export bridges:
- added support for PowerDesigner version 9.0 and new target DBMS available in this version
- updated some datatype mappings
- NEW: Rose Data Modeler import bridge: now imports integrated object and physical data models
-
NEW: The following bridges now support the import (and/or export) of objects Physical IDs:
- COOL:Gen import bridge: import of the objects "OBJID"
- ERwin 4 import bridge: import of the objects "id"
- Rose DM import bridge: import of the objects "quid"
- OracleDesigner 1.3.2, 2.1.2, 6.0 & 6i import bridge: import of the object "id"
- Popkin System Architect import bridge: import of the objects "GUID"
- PowerDesigner CDM & PDM XML import bridges: import of the objects "ObjectID"
- CWM 1.0 import and export bridges: import and export of the objects "UUID"
- XMI 1.0 import and export bridges: import and export of the objects "UUID"
-
UPDATE: JDBC import bridge:
- better support of MS SQL Server check constraints
- better support of Oracle stored procedures
-
UPDATE: ERwin 3.x import bridge:
- added a bridge import option that allows to migrate UDP default values to their applicable objects
- added support for merged migrated attributes
-
UPDATE: ERwin 4 import bridge:
- added a bridge import option that allows to migrate UDP default values to their applicable objects
- updated some datatype mappings
- UPDATE: Popkin System Architect import bridge: does not import empty notes anymore
- UPDATE: CWM 1.0 import bridge: provides more options on how to create a schema for tables with no owner
v3.0.0 Beta3 (03/22/2002)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: ProActivity import bridge: added support for ProActivity version 4.0
- UPDATE: PowerDesigner PDM XML import bridge: fixed some datatype mappings
- UPDATE: PowerDesigner PDM XML export bridge: fixed a bug related to the "Target Database" option
-
UPDATE: NCR MDS export bridge:
- better handle NUMERIC datatypes
- now sets the "database type" property
- now exports object description in the comment property, if the comment property is not set
-
UPDATE: ERwin 4.0 import bridge:
- added the generic "ODBC" target database and fixed some datatype mappings
- better support of the ERwin "Transformation" objects
- support for ERwin 4.1 (file version 4100)
- added more explicit messages if the input file is not a valid ERwin 4 XML file
- UPDATE: Oracle Designer import bridge: various bug fixes
-
UPDATE: RoseDM import bridge:
- fixed a bug related to the Source property of associations roles
- minor bug fixes and improvements
- UPDATE: SystemArchitect 2001 import bridge: better handles objects with duplicate names
v3.0.0 Beta2 (02/11/2002)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: SystemArchitect 2001 import and export bridges: added support for versions 8.5.16 and 8.5.20
-
UPDATE: ERwin 4.0 import bridge:
- Fixed a bug related to associations between two Views
- Added an option that allows the import of Views as regular Tables
- New algorithm that better supports ERwin duplicated attributes
- Support for ERwin 4.0 SP2 (build 1687) XML
-
UPDATE: ERwin 4.0 export bridge:
- now creates an associative table when exporting many-to-many relationship with transformations, if necessary
- fixed a bug related to attributes members of multiple keys
- UPDATE: Silverrun import bridge: now correctly opens the binary .TXT file in binary mode
- UPDATE: PowerDesigner CDM 7.5 & 8.0 import bridge: fixed an issue related to the import of datatypes
-
UPDATE: COOL:Gen import bridge:
- now stores the entities in the appropriate package, matching the Subject Area hierarchy
- fixed a bug related to the import of the "CASCADE" foreign key constraints
-
UPDATE: COOL:Gen export bridge:
- removed the export of foreign keys and non-unique keys (inversion entries) to the COOL:Gen logical model
- updated the datatypes mapping regarding the Time and TimeStamp datatypes lengths
- fixed a bug related to the export of the "CASCADE" foreign key constraints
- UPDATE: COOL:Enterprise (ADW) import bridge: now correctly renames and imports attributes for which the name was truncated in the .DAT file
- UPDATE: Oracle Designer import bridge: bug fixes and better support of Oracle Designer "shared" objects
- UPDATE: Oracle Designer 2000 export bridge: fixed an issue related to the generation of "short names"
- UPDATE: JDBC import bridge: Added an option that allows the import of Views as regular Tables
v3.0.0 Beta (12/14/2001)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- NEW: new version of the Metadata Repository SDK. See the MIRSDK ReadMe file for details
-
NEW: The following bridges now support User-Defined Properties:
- ERwin 3.5 import and export,
- ERwin 4.0 import and export,
- Oracle Designer import,
- Rose 98 to 2002 import and export
-
NEW: The following bridges now support the Owner/Schema notion:
- CWM pre-1.0 and 1.0 import and export,
- ERwin 3.5 import and export,
- ERwin 4.0 import and export,
- PowerDesigner PDM 7.5 and 8.0 import and export,
- Rose Data Modeler 2000e to 2002 import and export,
- COOL:DBA (Terrain for DB2) import
- UPDATE: ERwin 4.0 import bridge: Added an option to copy the objects' user-defined properties to their description field
-
UPDATE: ERwin 4.0 export bridge:
- Now export the Entities comment field
- Fixed a bug related to the Initial Values
-
UPDATE: Oracle Designer import bridge:
- Added an option to copy the objects' user-defined properties to their description field
- Added an option to copy the objects' description to their comment field
- Various bug fixes and improvements
- UPDATE: COOL:BusinessTeam (GroundWorks) import bridge: bug fixes
v2.5.1.5 (03/22/2002)
- NEW: SystemArchitect 2001 import and export bridges: added support for versions 8.5.16 and 8.5.20.
- UPDATE: PowerDesigner PDM XML import bridge: fixed some datatype mappings.
- UPDATE: PowerDesigner PDM XML export bridge: fixed a bug related to the "Target Database" option.
- UPDATE: PowerDesigner CDM 7.5 & 8.0 import bridge: fixed an issue related to the import of datatypes.
- UPDATE: NCR MDS export bridge: better handle NUMERIC datatypes.
-
UPDATE: ERwin 4.0 import bridge:
- added the generic "ODBC" target database and fixed some datatype mappings.
- support for ERwin 4.1 (file version 4100).
- UPDATE: ERwin 4.0 export bridge: fixed a bug related to attributes members of multiple keys.
- UPDATE: Oracle Designer 2000 export bridge: fixed an issue related to the generation of "short names".
-
UPDATE: Oracle Designer import bridge:
- Added an option to copy the objects' description to their comment field.
- various bug fixes and improvements.
-
UPDATE: RoseDM import bridge:
- fixed a bug related to the Source property of associations roles.
- minor bug fixes and improvements.
-
UPDATE: COOL:Gen import bridge:
- now stores the entities in the appropriate package, matching the Subject Area hierarchy.
- fixed a bug related to the import of the "CASCADE" foreign key constraints.
-
UPDATE: COOL:Gen export bridge:
- removed the export of foreign keys and non-unique keys (inversion entries) to the COOL:Gen logical model.
- updated the datatypes mapping regarding the Time and TimeStamp datatypes lengths.
- fixed a bug related to the export of the "CASCADE" foreign key constraints.
- UPDATE: COOL:BusinessTeam (GroundWorks) import bridge: bug fixes.
- UPDATE: COOL:Enterprise (ADW) import bridge: now correctly renames and imports attributes for which the name was truncated in the .DAT file.
- UPDATE: Silverrun import bridge: now correctly opens the binary .TXT file in binary mode.
v2.5.1.4 (12/03/2001)
- UPDATE: GUI tool: improved command line options
- UPDATE: ERwin4 export bridge to better handle the logical only/physical only flag.
- UPDATE: ERwin3.5 export bridge: the target database was not exported if the model had no diagram.
v2.5.1.3 (11/19/2001)
- UPDATE: Rose import and export bridges to support Rose 2002
- UPDATE: Rose DM import bridge to better support datatypes and domains.
v2.5.1.2 (11/06/2001)
- UPDATE: Rose DM import and export bridges to support Views.
- UPDATE: Rose DM import bridge to better support not well-formed MDL files.
- UPDATE: Terrain for DB2 import bridge: now imports the Foreign Keys also when the associated Primary Key attributes are defined after the foreign Key attributes in the .var file.
- UPDATE: COOL:Gen import bridge: the default for the "Design Level" option is now "Logical Only".
v2.5.1.1 (10/29/2001)
- NEW: ModelBridge command-line tool: now reads the Registry to retrieve the bridge options saved by the graphical MIMB tool.
- UPDATE: CWM Pre-1.0 and CWM 1.0 export bridges: not all the foreign keys were exported. The generated XML was sometimes not compliant to the DTD.
- UPDATE: ERwin 3.x import and export bridges: better mapping of the Teradata domain types.
- UPDATE: GUI tool: improved icons display to support Windows XP.
v2.5.1 (10/12/2001)
- UPDATE: PowerDesigner PDM 7.5 and 8.0 export bridge: generated an incorrect XML file when there was two Many-to-Many relationships between the same classes.
- UPDATE: Oracle Designer export bridges: fixed a problem related to carriage returns and line feeds.
v2.5.0.4 (10/05/2001)
- NEW: Popkin System Architect 2001 import and export bridges: added support for version 8.1 and 8.5.
- NEW: CWM XMI import and export bridges: support for CWM 1.0 standard (Alpha).
- NEW: COOL:Gen import bridge: support for physical data modeling.
- UPDATE: Oracle Designer 6i export bridge: support for Physical models (Release).
-
UPDATE: COOL:Gen export bridge:
- The attributes are now exported in the order of the table.
- The bridge now creates an association between the ROOT object and the entities.
- UPDATE: COOL:Gen import bridge: the type values of text attributes are now imported.
-
UPDATE: ERwin 4.0 export bridge:
- The mandatory property on relationships is now correctly set.
- The Diagram name is now prefixed by the Package name only when the diagram name is not unique in the model.
- UPDATE: NCR MDS 2.1 export bridge: the Business objects are now correctly updated. If a table has no Primary index, the bridge now sets one.
- UPDATE: GroundWorks import bridge: The associations created based on complex relationships now have a correct cardinality.
- UPDATE: ERwin 3.x import bridge: the value of Teradata Property COMPRESS is now correctly imported.
v2.5.0.3 (09/07/2001)
- NEW: Oracle Designer 6i export bridge: support for Physical models (beta).
- UPDATE: Oracle Designer import bridge: support for Physical models (release).
-
UPDATE: NCR MDS 2.1 export bridge:
- Support for MDS 2.1 release version.
- Added an option to update the existing logical information instead of overwriting it.
- UPDATE: NCR MDS import and export bridges: better support for PRIMARY index type.
- UPDATE: ERwin 4.0 import bridge: Fixed a bug related to Validation Rules: valid values and their definition are no longer inverted during import.
-
UPDATE: ERwin 4.0 export bridge:
- datatype mapping was incorrect for some target databases.
- no longer create empty tags for Default Values and Validation Rules.
- Support for ERwin 4.0 SP1 diagrams.
- UPDATE: ERwin 3.5 import bridge: failed to import some Stored Procedures.
- UPDATE: ERwin 3.5 import and export bridges: the position of valid values was lost.
-
UPDATE: Rose Data Modeler export bridge:
- Now support very large number of type values.
- Fixed a typo: the generated file may not be readable anymore by older versions of Rose Data Modeler,
-
UPDATE: Rose Data Modeler import bridge:
- Now import generic datatypes (when no target database is specified).
- Better support models with "ghost" objects,
- UPDATE: PowerDesigner 6.1 CDM and PDM export bridges: the lines read in the file are trimmed of spaces.
v2.5.0.2 (08/02/2001)
- NEW: MIMB can now read an abbreviation dictionary (comma separated text file) and expand the abbreviated names of attributes and classes.
- NEW: CoolGen import and export bridges: now support CoolGen version 6.0.
- UPDATE: PowerDesigner 7.5 and 8.0 export bridges: added an option to export the descriptions as notes.
- UPDATE: ERwin 4.0 import bridge: fixed a bug on Foreign Keys.
v2.5.0.1 (07/30/2001)
- UPDATE: ERwin 3.5 import bridge: improved support for Teradata target database.
- UPDATE: ERwin 4.0 export bridge: added support for attributes in multiple foreign keys.
-
UPDATE: JDBC import bridge:
- sometimes failed to import foreign keys correctly.
- better support for Oracle 8.1.7 database.
- UPDATE: NCR MDS export bridge: the UpperCase property is now set.
v2.5.0 (07/13/2001)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- UPDATE: GUI: Display a warning message with the number of days remaining, 30 days before a temporary key expires. You can turned off the display of the Message box by deselecting the check box "Display license key message box" in the Preferences dialog box: the message will appear in the log window instead.
- UPDATE: ERwin 4.0 import and export bridges: support for ERwin 4.0 SP1.
-
UPDATE: ERwin 4.0 import bridge:
- The foreign keys were sometimes not connected to their attributes, resulting in a consistency check error.
- If a Domain does not have a name, a default name "Unknown" is set to it.
- UPDATE: ERwin 4.0 export bridge: exports the AliasPhysicalNames into the Synonyms.
-
UPDATE: Groundworks import bridge:
- Delete the foreign keys associated to a Many-to-Many relationships.
- "shared" partnership sets are now imported. Previously only one relationship was imported.
- UPDATE: PowerDesigner PDM version 7.5 and 8.0 import bridge: creates an alternate key when a joint in a relationship is not connected to a key.
2.5.0 Beta2 (07/09/2001)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
- UPDATE: GUI: Replaced "..." button labels by more meaningful icons.
- UPDATE: GUI: The tool failed if no export tool were selected when selecting the subsetting level.
- UPDATE: Groundworks import bridge: to better recognize the identifying relationships, and to better handle the migration of the attributes in the foreign keys.
- UPDATE: PowerDesigner CDM & PDM version 7.5 and 8.0 export bridges: the bridge was very slow if the Association Roles of an Association had Notes.
- UPDATE: PowerDesigner CDM & PDM version 7.5 and 8.0 import bridges: now handles the grouping symbol. The Notes (in RTF format) were sometimes not imported.
- UPDATE: ERwin 4.0 export bridge: when generating a Physical only model, if an object has no comment, the description is now exported instead.
- UPDATE: ERwin 4.0 import bridge to import the Logical datatype if no Physical datatype is provided.
- UPDATE: ADW import bridge: if a Domain has a Value Type NUMERIC and a length, the Value Set Type information is ignored.
- UPDATE: Rose 2001 export bridge: when exporting both the Object model and the Data model, the traceability between the two models has been improved.
2.5.0 Beta (06/29/2001)
- LICENSE KEY: your current license key may no longer be valid with this version. If so, please contact our technical support.
-
UPDATE: Oracle Designer import bridge:
- Added support for physical modeling level (Beta1).
- Fixed errors when loading a model (DAT file) containing diagrams in Designer 6i.
-
UPDATE: Sybase's PowerDesigner CDM & PDM version 7.5 and 8.0 export bridges:
- Associations rolenames are now correctly exported.
- Documentation fields of association roles are appended to the documentation fields of their association.
-
UPDATE: Sybase's PowerDesigner CDM & PDM version 7.5 and 8.0 import bridges:
- Graphical information : now able to import colors and font information
- Encoding : added an option to allow the conversion of UTF-8 encoded strings to ISO-8859-1 (Latin1) encoding.
- Volumetric statistics : added an option to allow the append of such information to the description.
- Various bug fixes.
- UPDATE: NCR MDS 2.1 export bridge (Beta3)
- UPDATE: COOL:Gen import and export bridges: the referential integrity rules are now in the right order.
-
UPDATE: ERwin 3.x import bridge:
- Fixed a bug that occurred when importing a Japanese model with Japanese datatypes.
- The logical name of views is now set with their physical names.
- UPDATE: JDBC/ODBC import bridge : now able to retrieve foreign keys of Teradata databases schemas.
4. System requirements
4.1 Important preliminary disclaimer notice on all requirements
The following requirements only define the minimal requirements to run the application with reasonable performance based on the provided tutorial, or small business use cases. The actual requirements for enterprise wide use cases based on larger models and configurations do require significantly greater resources to obtain acceptable performance.
The following requirements are based on:
- actual physical hardware (no virtual environment),
- minimal to no network overhead (assuming both the database and application servers to be locally installed),
- vendor's default install of the current version of their software (with all current service or fix packs),
- no other applications sharing such hardware (starting from a clean machine),
Any other hardware/software configurations are acceptable as long as they provide the same (or better) results on the provided performance benchmark. In such case, if any problem is discovered (e.g. scalability or performance issues), then the customer must be able to reproduce the issue using an environment that conforms to the minimum performance requirements as defined herein.
Potential known issues include (but are not limited to) the following:
- actual usable hardware performance on virtual environments (e.g VMWare configuration and licenses)
- network overhead on remote servers (e.g. bandwidth, proxy, VPN issues, VMWare inter OS network limitations without a proper license, etc.)
- shared resources with competing applications on the same OS, or between OS on a virtual environment,
- licensing limitations (e.g. most database server licenses limit the number of usable core/CPU)
- vendor software known limitations and requirements (e.g. Oracle on VMWare vs Oracle VM)
4.2 Web Client requirements
Users only need an internet browser:
- Google Chrome v30 or newer
- Microsoft Internet Explorer (IE) v10 or newer. Note that older versions of IE (especially running on old versions of Windows like XP) are not officially supported as users may encounter some minor layout issues for this modern web 2.0 application (all issues have been resolved by Microsoft in more recent versions of Windows and IE).
- Mozilla Firefox v30 or newer
- Apple Safari v6 or newer
4.3 Web Application Server Requirements
Hardware Minimum Requirements (based on physical hardware performance, not a virtual environment):
- 2 GHZ or higher quad core processor
- 4 GB RAM (8 GB if 64bit OS using 64bits Web Application Server)
- 1 GB of disk space
Operating System Requirements:
-
Microsoft supported Windows 64 bit versions (including Windows 2008 Server, Windows 2012 Server, Windows 2016 Server, Windows 2019 Server, Windows 7, Windows 8.x, and Windows 10).
- Ensure that installer is executed with full Administrator privilege
- Ensure that Microsoft .NET Framework 3.5 or higher is installed
- Ensure that all current Microsoft Windows critical updates have been applied
- Most popular versions of Linux/Unix Operation Systems (such as Oracle Solaris, Redhat or Mac OS).
Web Application Server Engine Requirements:
- Apache Tomcat (bundled)
- Other Web Application Servers (such as IBM WebSphere or Oracle WebLogic) require manual install/setup, and are therefore not supported by this version.
Java Runtime Environment (JRE):
- OpenJDK 11 (bundled and recommended)
- Other Java Runtime Environment (JRE) require manual install/setup, and are therefore not supported by this version.
Note that Java bridges are compiled backward compatible to JRE 8.
5. Model Bridge (MIMB) Application Server Setup
5.1 Application Server Installation
The MIMB Application Server is installed as follows:
-
On Windows operating systems, use
unzip
to extract the software package (.zip) in the directory of your choice. You should avoid using the "Program Files" directories of Windows 7, 8.x and 10 as they have are now controlled by Windows with special access rights. Depending, on your software installation directory, you may need "Administrator" privileges. -
On Linux operating systems, use
tar –xjvf
to extract the software package (.tbz2) in the directory of your choice. Depending, on your software installation directory, you may need "root" privileges.
5.2 Application Server Configuration
Essential customizations (e.g. directories, memory) of the MIMB Application Server can be performed in the following configuration file:
%MIMB_HOME%\conf\conf.properties
Recommended customizations include:
-
M_BROWSE_PATH to browse local and mapped network drive.
All metadata harvesting file and directory parameters references are relative to the server. The reason is that the server must have access to these resources anytime another event (e.g., scheduled harvest) is to occur. On installation, it includes all directly attached drives However, as it is a service, the drive names and paths may vary from what the installer understands, and these drives are not made available at installation time, and thus will not be see when selecting drives using the UI. Note that this also applies and even script backup and restore drives. - M_DATA_DIRECTORY to relocate the data such as the log files, and metadata incremental harvesting cache as needed for very large DI or BI tools
- M_JAVA_OPTIONS to increase the maximum memory used by java bridges during the metadata harvesting of very large DB, DI or BI tools. Note that this parameter defines the default maximum for all java bridges, however most memory intensive java bridges (e.g JDBC bridges) have the ability to define its own maximum memory in their last parameter called Miscellaneous.
Additional customizations (e.g. port numbers, Windows service names) of the MIMB Application Server can be performed in the following configuration file::
%MIMB_HOME%\tomcat\conf\tomcat.properties
5.3 Application Server Execution
The easiest way to start the MIMB Application Server is to go to the software home directory and use the RestartApplicationServer
utility (.bat on Windows or .sh on Linux).
-
On Windows operating systems, you can alternatively use the Windows Services to control the MIMB Application Server by using the
RestartApplicationService.bat
utility instead. This utility will create the Windows Service for the MIMB Application Server, if it was not already created by previous execution of this utility or theSetup.bat
utility. At this point, you can simply use the Windows Services to start, stop or restart the MIMB Application Server automatically.
When running the MIMB Application Server as a Windows Service, it is important to configure the user running such service in order to have full access rights to the needed files and applications. For example, the MIMB bridges involved in the metadata harvesting may need to invoke the SDK of third party software such as the COM based API of CA ERwin, or SAP BusinessObjects Universe Designer.
In order to set such access rights, go to the services manager of Windows, right-click on the MIMB Application Server service. Then, go to the "Log On" tab to define an account by name under which the service will run. -
On Linux operating systems, administrators can use the system daemon directories (e.g.
/etc/init.d/
or/etc/systemd/
) to control the MIMB Application Server (either using theRestartApplicationServer.sh
utility or directly controlling the Tomact server in the home directory).
5.4 Application Server Usage
You can connect to the server which can be simply achieved on Windows installation by opening Model Bridge
link in the home directory.
In all cases, you can connect to the server using your internet browser to open by default:
http://localhost:19980/MIMB.
(Note that the above default port numbers may have been changed as defined in the section Application Server Configuration.
In addition to the above MIMB application Web UI,
scripts can also be built using the MIMB command line utility
(bin\MIMB.bat
on Windows, and bin/MIMB.sh
on Linux)
which has the following parameters:
There are two ways to invoke MIMB from the command line. The first one is to explicitly provide parameters for the import and export, for example:
The above method has all the benefits of scripting with parameters, but has the disadvantage of fighting with encoding and special characters on the command line script. The alternative is to store all the MIMB import/export parameters within an MIMB request XML file.
These MIMB request XML files can be generated automatically from the MIMB application UI as follows.
First, you need to edit c:\MetaIntegration\conf\conf.properties
in order to uncomment/set M_CONVERSATION_DIRECTORY=c:\MetaIntegration\data\MIMB
where the xml files will be generated (make sure the directory exists).
Then, use the MIMB UI to perform the desired import and export.
The MIMB import request should have been saved as a file such as RunMimbExtendedRequest_19_8309388477083505776.xml
which contains:
The MIMB export request should have been saved as a file such as RunMimbExtendedRequest_22_2010863314972480997.xml
which contains:
Then a c:\MetaIntegration\data\MIMB\MyMIMBRequest.xml
can be easily created by copying the import section of the first request and the export section of the second request as follows:
Finally, run c:\MetaIntegration\bin\MIMB.bat -r myMIMBRequest.xml -y myMIMBReply.xml