ERwin Web Portal 9.7 (AKA MIMM 9.1.0)
- 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 the 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
- 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, the 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:
For more information, please refer to:
http://www.metaintegration.net/Products/MIMM/MIMMReadme.html#Changes
Comments
0 comments
Please sign in to leave a comment.