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:
- OEMM and OMM4OBI installation on Windows
- Importing OBIEE Metadata to OMM4OBI
- Simple OMM4OBI use cases with OBIEE
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
|
No comments:
Post a Comment