Tuesday, December 9, 2014

Oracle Metadata Management (OMM) 12c

Oracle Enterprise Metadata Management 12c  (OEMM) is a comprehensive metadata management platform. OEMM can harvest and catalog metadata from virtually any metadata provider, including relational, Hadoop, ETL, BI, data modeling, and many more. OEMM however is not just a metadata repository, OEMM allows for interactive searching and browsing of the metadata as well as providing data lineage, impact analysis, semantic definition and semantic usage analysis for any metadata asset within the catalog. OEMM's advanced algorithms stitch together metadata from each of the providers providing the complete path of data from source to report or vice versa. OEMM supports virtually any metadata provider including: Data modeling tools, databases, CASE tools, Hadoop, ETL engines, Warehouses, BI, EAI environments, as well as many more.


The Oracle Metadata Management (OMM) solutions include two products:
  • the Oracle Metadata Management for Oracle Business Intelligence (OMM4OBI)
  • and the Oracle Enterprise Metadata Management (OEMM)
The data sheet is here.


I intend to install it and play with it on my laptop (concentrating on the OBIEE side), and write few posts about it: 


Some smarter things to read about OEMM, by Issam Hijazi:
Oracle Enterprise Metadata Management
Big Data & Oracle Enterprise Metadata Management
Harvesting the Cloud with Oracle Enterprise Metadata Management

There is also Introduction Video (WebEx)



In the certification matrix, there is an impressive list of data sources:


Category
Vendor Name
Tool Name
Tool Versions
Business Intelligence
IBM
Cognos Content Manager
RN to C10
Business Intelligence
IBM
Cognos Content Manager Packages
RN to C10
Business Intelligence
IBM
Cognos Content Manager QueryStudio
C8 v8.3 to C10
Business Intelligence
IBM
Cognos Content Manager ReportStudio
RN to C10
Business Intelligence
IBM
Cognos Framework Manager
C8 v8.1 to C10
Business Intelligence
IBM
Cognos Framework Manager
RN to C8 v8.0
Business Intelligence
IBM
Cognos PowerPlay Transformer
C10
Business Intelligence
IBM
Cognos QueryStudio
C8 v8.3 to C10
Business Intelligence
IBM
Cognos ReportStudio
RN to C10
Business Intelligence
IBM
Cognos Series 7 Impromptu
7.0.702,
7.1.116, 7.1.529, 
and 7.3.1413
Business Intelligence
IBM
DB2 Cube Views
8.x
Business Intelligence
Microsoft
SQL Server Analysis 
and Reporting Services (SSAS, SSRS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
Microsoft
SQL Server Analysis Services (SSAS)
7.0 to 8.0 (2000)
Business Intelligence
Microsoft
SQL Server Analysis Services (SSAS)
7.0 to 8.0 (2000)
Business Intelligence
Microsoft
SQL Server Analysis Services (SSAS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
Microsoft
SQL Server Analysis Services (SSAS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
Microsoft
SQL Server Analysis Services (SSAS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
Microsoft
SQL Server Integration Services (SSIS)
9.0 (2005) to 
10.5 (2008 r2)
Business Intelligence
Microsoft
SQL Server Reporting Services (SSRS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
Microsoft
SQL Server Reporting Services (SSRS)
9.0 (2005) to 
11.0 (2012)
Business Intelligence
MicroStrategy
Intelligence Server
7.0 to 9.x
Business Intelligence
MicroStrategy
MDX Adapter (ODBO)
7.0 to 8.1
Business Intelligence
Oracle
Oracle Business Intelligence (OBI) Answers
10.1 to 11.g
Business Intelligence
Oracle
Oracle Business Intelligence (OBI)
Enterprise Edition
10.1 to 11.g
Business Intelligence
Oracle
Oracle Business Intelligence (OBI) Server
10.1 to 11.g
Business Intelligence
Oracle
Oracle Hyperion Application Builder
N/A
Business Intelligence
Oracle
Oracle Hyperion Essbase
Integration Services (EIS)
7.x to 9.x
Business Intelligence
SAP
BusinessObjects (BO) Crystal Reports
11.x to 14.x
Business Intelligence
SAP
BusinessObjects (BO) Crystal Reports
11.x to 14.x
Business Intelligence
SAP
BusinessObjects (BO) Designer
6.x to 14.x
Business Intelligence
SAP
BusinessObjects (BO) Designer
6.x to 14.x
Business Intelligence
SAP
BusinessObjects (BO) Desktop Intelligence
6.x to 12.x
Business Intelligence
SAP
BusinessObjects (BO) Desktop Intelligence
6.x to 12.x
Business Intelligence
SAP
BusinessObjects (BO) Information Design Tool
14.1
Business Intelligence
SAP
BusinessObjects (BO) Information Design Tool
14.1
Business Intelligence
SAP
BusinessObjects (BO) Repository
11.x to 14.x
Business Intelligence
SAP
BusinessObjects (BO) Repository
6.x
Business Intelligence
SAP
BusinessObjects (BO) Web Intelligence (Webi)
11.x to 14.x
Business Intelligence
SAP
NetWeaver Business
Warehouse (BW) (via ODBO)
7.0 to 7.3
Business Intelligence
SAP
NetWeaver Business Warehouse 
(BW) (via XML)
7.0 to 7.3
Business Intelligence
SAS
Information Map Studio
9.x
Business Intelligence
SAS
Management Console
9.x
Business Intelligence
SAS
OLAP Server (via ODBO)
9.x
Business Intelligence
Tableau
Tableau
7.x to 8.x
Business Intelligence
Tableau
Tableau Server
7.1 to 8.x
Data Integration
IBM
DB2 Warehouse Manager
7.2 to 8.x
Data Integration
IBM
InfoSphere DataStage
7.5 to 9.1
Data Integration
Informatica
PowerCenter
5.x to 9.x
Data Integration
Informatica
PowerCenter
5.x to 9.x
Data Integration
Microsoft
SQL Server Integration Services (SSIS)
9.0 (2005) to 
11.0 (2012)
Data Integration
Microsoft
SQL Server Integration Services (SSIS)
9.0 (2005) to 
11.0 (2012)
Data Integration
Oracle
Oracle Business Intelligence Data 
Warehouse Administration Console (DAC)
10.1.3.4
Data Integration
Oracle
Oracle Data Integrator (ODI)
11.1.1.6 or newer
Data Integration
Oracle
Oracle Warehouse Builder (OWB)
10.2 to 11g
Data Integration
Oracle
Oracle Warehouse Builder (OWB)
9i
Data Integration
SAP
BusinessObjects Data Integrator (BODI)
11.7 to 12.x
Data Integration
SAS
Data Integration Studio
9.x
Data Integration
SAS
Data Integration Studio
9.x
Data Integration
Syncsort
Syncsort DMExpress
6.x to 7.x
Data Modeling
CA technologies
COOL:Biz
5.1
Data Modeling
CA technologies
COOL:BusinessTeam
2.2.1 and 1.2A.5.0
Data Modeling
CA technologies
COOL:DBA
5.3.2
Data Modeling
CA technologies
COOL:Enterprise
2.7
Data Modeling
CA technologies
COOL:Xtras Mapper
5.3.2
Data Modeling
CA technologies
ERwin Data Modeler
3.x
Data Modeling
CA technologies
ERwin Data Modeler
4.x
Data Modeling
CA technologies
ERwin Data Modeler
7.x
Data Modeling
CA technologies
ERwin Data Modeler
8.x
Data Modeling
CA technologies
ERwin Data Modeler
9.x
Data Modeling
CA technologies
Gen
4.1a to 8.0
Data Modeling
Embarcadero
ER/Studio Business Architect
1.5
Data Modeling
Embarcadero
ER/Studio Data Architect
5.1 to 10.0
Data Modeling
Embarcadero
ER/Studio Repository
5.1 to 9.6
Data Modeling
EMC (ProActivity)
ProActivity
3.0 & 3.1 & 4.0
Data Modeling
Grandite (Silverrun)
Silverrun-RDM
2.4.4 to 2.8.6
Data Modeling
IBM
InfoSphere Data Architect (IDA)
6.1 to 9.1
Data Modeling
IBM
Rational System Architect (SA)
10.4.23 to 11.x
Data Modeling
IBM
Rational System Architect (SA)
7.1.12 to 11.x
Data Modeling
Informatica
Developer
9.x
Data Modeling
Microsoft
Office Visio Database (via ERX)
97 to 2007
Data Modeling
Microsoft
SQL Server Data Source View (DSV)
9.0 (2005) to 
10.5 (2008 r2)
Data Modeling
Oracle
Oracle Data Modeler (ODM)
4.x
Data Modeling
Oracle
Oracle Designer
1.3.2, 2.1.2, 6.0, 
6i to 10g
Data Modeling
Select Software
Select SE
7.0
Data Modeling
Sybase 
(an SAP company)
PowerDesigner CDM 
(Conceptual Data Modeling)
6.1.x
Data Modeling
Sybase 
(an SAP company)
PowerDesigner CDM 
(Conceptual Data Modeling)
7.5 to 16.x
Data Modeling
Sybase 
(an SAP company)
PowerDesigner LDM (Logical Data Modeling)
15.x to 16.x
Data Modeling
Sybase 
(an SAP company)
PowerDesigner PDM (Physical Data Modeling)
6.1.x
Data Modeling
Sybase 
(an SAP company)
PowerDesigner PDM (Physical Data Modeling)
7.5 to 16.x
Data Modeling
Visible Systems
Corporation
IE:Advantage
6.1
Data Warehousing
IBM
InfoSphere Warehouse / Data Architect
9.x
Database
Apache
Hadoop HCatalog
0.5
Database
Apache
Hadoop Hive Server
0.10
Database
CA technologies
ERwin Data Profiler
4.0 to 4.1
Database
Cloudera
Enterprise (Hadoop Hive)
0.10
Database
Cloudera
Impala (Hadoop Hive)
0.10
Database
DataStax
Enterprise (Hadoop Hive)
0.10
Database
Google
BigQuery
2.0.0
Database
Hadapt
Hadoop Hive Server
0.10
Database
Hortonworks
Hadoop Hive
0.10
Database
IBM
DB2 Database
8.x to 9.x
Database
IBM
InfoSphere Discovery
4.0 to 4.1
Database
IBM
InfoSphere Federation Server
8.x
Database
IBM
Lotus Notes
5.0 to 6.x
Database
IBM
Netezza Database (via JDBC)
7.0
Database
MapR
Hadoop Hive
0.10
Database
Micro Focus
AppMaster Builder
97 to 2007
Database
Microsoft
Database via Open Database Connectivity 
(ODBC)
3.0
Database
Microsoft
Office Access Database
97 to 2007
Database
Microsoft
SQL Server Database
7.0 to 11.0 (2012)
Database
Oracle
Database via Java Database Connectivity (JDBC)
1.0 and 2.0
Database
Oracle
Oracle Database
6i to 12c
Database
Pivotal
Greenplum Database (via JDBC)
4.x
Database
PostgreSQL Global
Development Group
PostgreSQL Database (via JDBC)
8.x to 9.x
Database
Sybase 
(an SAP company)
Sybase ASE Database
15
Database
Teradata
Teradata Database
12.x to 13.0
Metadata Management
CA technologies
ERwin Data Modeler
7.x
Metadata Management
CA technologies
ERwin Data Modeler
8.x
Metadata Management
CA technologies
ERwin Data Modeler
9.x
Metadata Management
CA technologies
ERwin Mart
7.x
Metadata Management
CA technologies
ERwin Mart
8.x
Metadata Management
CA technologies
ERwin Mart
9.x
Metadata Management
IBM
InfoSphere Information Server (IIS) 
(Common Model)
9.1
Metadata Management
Microsoft
Office Excel
2003 to 2010
Metadata Management
Microsoft
SQL Server Repository
via Meta Data Coalition (MDC) XML
3.x
Metadata Management
Microsoft
SQL Server Repository 
via XML Interchange Format (XIF)
2.1b
Metadata Management
Object Management
Group
Common Warehouse Metamodel (CWM) XMI
1.0 to 1.1
Metadata Management
Object Management
Group
Common Warehouse Metamodel (CWM) XMI
Adopted Specs 
Pre-1.0
Object Modeling
Borland
Together
6.x to 2006
Object Modeling
Borland
Together
6.x to 2006
Object Modeling
CA technologies
Component Modeler
3.52
Object Modeling
CA technologies
Component Modeler
4.x
Object Modeling
Embarcadero
Describe
5.8+
Object Modeling
Gentleware
Poseidon
1.2 to 6.0
Object Modeling
IBM
Rational Rose
4.0
Object Modeling
IBM
Rational Rose
6.0 (98i) to 6.5 
(2000)
Object Modeling
IBM
Rational Rose
7.x (2000e and 
newer)
Object Modeling
IBM
Rational Software Architect (RSA)
6.x to 7.x
Object Modeling
IBM
Telelogic Tau
1.0 to 1.2
Object Modeling
Microsoft
Office Visio UML (via UML 1.x XMI)
97 to 2007
Object Modeling
Microsoft
Visual Studio / Modeler 2.0 (MDL)
2.0
Object Modeling
No Magic
Magic Draw
8.0 to 12.x
Object Modeling
Object Management
Group
Unified Modeling Language (UML) XMI
1.x
Object Modeling
Object Management
Group
Unified Modeling Language (UML) XMI
2.x
Object Modeling
Sparx Systems
Enterprise Architect (EA)
6.x to 7.x
Object Modeling
Sparx Systems
Enterprise Architect (EA)
6.x to 7.x
Object Modeling
Sybase 
(an SAP company)
PowerDesigner OOM (Object Oriented Modeling)
9.0 to 15.x
Object Modeling
Sybase 
(an SAP company)
PowerDesigner OOM (Object Oriented Modeling)
9.0 to 15.x
Object Modeling
Tigris
ArgoUML
0.10 to 0.24
XML Modeling
Microsoft
SQL Server XML Data Reduced (XDR) Schema
1.0
XML Modeling
World Wide Web
Consortium
XML Schema
1.0

1 comment:

  1. I am very grateful for this enlightening article. I am new to this issue, but for me it elucidated several questions. Congratulations on your knowledge on the subject. Thank you very much.
    Advanced Installer Architect 14.1

    ReplyDelete