Welcome to All Things Data Integration: Announcements, Insights, Best Practices, Tips & Tricks, and Trend Related...

Oracle Metadata Management is Now Available

Oracle Metadata

Oracle Metadata Management is essential to solving a wide variety
of critical business and technical challenges around data governance and
transparency. For example, “How are those
report figures are calculated?” or “How does that change impact the data
upstream?”. Oracle Metadata Management
is built to answer these pressing questions for customers in a lightweight
browser-based interface.

What is new in Oracle Metadata Management’s newest release

Oracle Metadata Management a number of key
updates including:

  • Extended support for new cloud, big data and other
    technology with new harvesting bridges,
  • Enhanced search and findability function to manage
    objects within OMM, and
  • Quick and easy naming and renaming capabilities.
  • To read the
    entire list click here. A few highlights include:

Metadata Explorer – Designed for the
business user

This release provides a major redesign of the Metadata Explorer
User Interface on both the look and feel in addition to actual capabilities.

The new METADATA SEARCH/ BROWSE with FILTERING on any attributes
and/or properties allows for the choice of result set displays as a classic
Google like "LIST", or a new powerful "GRID" offering a
spreadsheet like display of multiple attributes/properties at once.
Attributes/properties can be individually selected, reordered, and sorted,
offering a full metadata reporting solution. The results can of course be
downloaded as CSV/Excel files.

METADATA EDITING is now possible at various levels. Numerous new fast and easy "in
place" editing to Rename objects, Edit Descriptions, and more are
available. The new Search/Browse GRID display also offers efficient editing
with TABULAR EDITING of multiple objects at once such as Business Glossary
Terms, Data Models Tables, or Table Columns. Also, BULK CHANGE of multiple objects at once is feasible, where a
search can return multiple objects (that can then be selectively sub-setted)
for which changes can be performed at once (e.g. Change the Security Threat
Level to Orange to a set of tables at once)

Metadata Documentation - Capture Metadata through documentation

Metadata Documentation has been further developed. Previously, you could import a database model but could not enrich it with your own metadata. Now databases can be documented with extra metadata and any number of custom attributes.

Harvesting Bridges

Oracle Enterprise Metadata Management provides a whole set of new harvesting bridges. A few examples include:

· Amazon Web Services AWS) RedShift Database import

· Apache Cassandra import (including from DataStax Enterprise)

· Apache Hadoop HiveQL DDL import (including from Cloudera, Hortonworks, MapR, etc.)

· Microsoft SQL Server Integration Services (SSIS) (Repository Database) import bridge

· Microsoft SQL Server Integration Services (SSIS) 2014 import bridge

Enhancements to existing bridges are
also available. For instance:

There has been a major redesign of all DI/ETL/ELT bridges based
upon a more universal DI meta-model which better supports the new generations
of DI tools while reducing the volume of metadata. As a result, DI/ETL/ELT
bridges now import much faster (some of them twice as fast), without losing any
DI/ETL/ELT design or data flow lineage details.

Business Intelligence bridges have also seen improvements,

· IBM Cognos Content Manager with PowerPlay Transformer import bridge has major improvements to better support lineage for cubes

· MicroStrategy import bridge has major improvements for scalability and protection against broken/corrupted reports

· Tableau import bridge has major improvements to better support massive amounts of database or file connections (popular in self service BI)

Metadata Manager and Version Handling

This release of Oracle Enterprise Metadata Management sees major
improvements in its Metadata Manager by way of performance and more efficient handling
of versions themselves. The MODEL
VERSION / CHANGE MANAGEMENT feature prevents the creation of 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. This is
new feature is achieved by taking advantage of the harvesting bridge’s new
capabilities to compare the metadata of a newly imported model with a
previously imported one in order to detect any change. The major benefit of
this new feature is to dramatically reduce the disk space in the repository by
automatically deleting unnecessary versions. CONFIGURATION / VERSION CHANGE
MANAGEMENT capabilities now exist which offer a way to compare various versions
of configurations.

Again, this is just a snippet of what’s new in this release of
Oracle Metadata Management but the added value is tremendous. We hope your journey with this solution in
enlightening! For more information visit the home page here.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.