Oracle Data Relationship Management 11.1.2 Administration (11.1.2.3)

In this course, you are tasked with building a Data Relationship Management application. You start by defining an application, and then add versions, hierarchies, and nodes. To support the application data, you create properties both manually and in bulk through the Migration Utility.

Before finalizing a version, you clean the data by creating queries and compares. You also update the data with action scripts. Finally, you blend versions to create a final version.

With the application structure completed, you create business rules for your data by creating validations and properties with formulas. You fine-tune the display of properties for nodes by setting up node types. You also export the data to a file and to a database table. To complete the implementation, you set up user security, perform audit activities, and archive your application by exporting it with the Migration Utility. This course uses release 11.1.2.3 software.

Learn To:

• Create Data Relationship Management applications
• Manage enterprise data and security in Data Relationship Management
• Explain best practices for implementing Data Relationship Management
• Describe Data Relationship Management concepts, terminology, and architecture

Audience

• Functional Implementer
• Administrator

Course Topics Product Orientation

• About Data Relationship Management
• Data Relationship Management Architecture
• Implementation Process for Data Relationship Management Applications
• Audiences for Data Relationship Management
• Connecting to Applications with Web Client
• Navigating Web Client

Working with Versions and Hierarchies

• Working with Versions
• Working with Hierarchies
• Implementation Considerations
• Querying and Viewing Transaction History

Working with Nodes

• Creating Nodes
• Inserting and Removing Nodes
• Adding and Deleting Nodes
• Inactivating and Re-Activating Nodes
• Copying and Moving Nodes
• Viewing and Editing Properties
• Domain Membership for Nodes
• Implementation Considerations

Defining Properties

• About Custom Properties
• Configuring Defined Properties
• Configuring List Values
• Configuring Lookup Values
• Configuring Inheriting Properties
• Assigning Controlling Hierarchies to Global Inheriting Properties
• Creating Property Categories
• Loading Metadata with the Migration Utility

Importing Data

• About Importing Data
• About Import Files
• Opening, Copying, and Deleting Imports
• Creating Imports
• Running Imports

Querying and Comparing Data

• Searching for Nodes
• Viewing Orphan Nodes
• Creating Queries
• Creating Compares
• Working with Query and Compare Results

Updating Data with Action Scripts

• About Action Scripts
• Creating Flat Files for Action Scripts
• Loading Action Scripts from Flat Files
• Running Action Scripts and Reviewing Results
• Downloading Action Script Results
• Modeling Nodes by Using Action Scripts

Blending Versions

• About Blending Versions
• Opening, Copying, and Deleting Blenders
• Creating Blenders
• Running Blenders

Creating Formulas and Dynamic Scripts for Derived Properties

• About Formulas for Derived Properties
• Formula Syntax
• Creating Derived Properties by Using Formulas
• Testing Formulas
• Creating Derived Properties by Using Dynamic Scripts

Validating Data

• About Validations
• Creating Validations
• Assigning Validations to Versions, Hierarchies, and Nodes
• Running Batch Validations
• Attaching Batch Validation to Exports
• Working with Batch Validation Results
• Editing and Deleting Validations

Setting Up Node Types

• About Node Types
• Process for Setting Up Node Types
• Creating, Editing, and Deleting Glyphs
• Creating, Editing, and Deleting Node Types
• Assigning Node Types to Node
• Configuring Hierarchy Node Type Property Values
• Troubleshooting Node Type Assignments

Configuring Governance Workflows

• About Data Relationship Governance
• Working with Requests
• Navigating the Worklist
• Managing Workflow Tasks
• Managing Workflow Models
• Integrating External Workflow Applications

Exporting Data

• About Exporting Data
• About Export Types
• Opening, Copying, and Deleting Exports
• Creating Exports
• Running Exports
• Creating and Running Export Books

Managing Security

• Security Levels
• Creating and Managing Users
• Assigning Access to Nodes
• Assigning Access to Metadata Objects
• Assigning Access to Property Categories
• Granting Anonymous Access

Analyzing Data Changes and Migrating Metadata

• Analyzing Data Changes
• Archiving Metadata Changes

Course Objectives

• Manage versions, hierarchies, and nodes
• Define properties for applications
• Import data into applications
• Query and compare application data
• Describe Data Relationship Management
• Create Data Relationship Management applications
• Update application data with action scripts
• Blend versions in applications
• Create formulas and dynamic scripts for derived properties
• Create validations for applications
• Set up node types in applications
• Export application data
• Manage security for applications
• Audit application data
• Configure Governance Workflows