Managing backups development changes and security
Download
1 / 43

Managing Backups, Development Changes, and Security - PowerPoint PPT Presentation


  • 100 Views
  • Uploaded on

Managing Backups, Development Changes, and Security. Objectives. After completing this lesson, you should be able to: Describe the MDL import and export utilities Use snapshots to manage metadata changes Explain the different levels at which you can perform version management

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Managing Backups, Development Changes, and Security' - ace


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Objectives
Objectives

  • After completing this lesson, you should be able to:

    • Describe the MDL import and export utilities

    • Use snapshots to manage metadata changes

    • Explain the different levels at which you can perform version management

    • Perform security and user management tasks through the OWB Design Center graphical user interface


Lesson agenda
Lesson Agenda

  • MDL Export and Import

  • Manage metadata change using Snapshots

  • Version management

    • Generation comments

    • MDL annotations

    • Collection snapshots

  • Warehouse Builder users and roles

    • Security parameters


Metadata loader utilities mdl
Metadata Loader Utilities (MDL)

  • Copy and move metadata for backup, history management, or version management

  • Accessible for any type of object in the Projects Navigator, Locations Navigator, and Globals Navigator panels

  • Export utility

    • Extracts metadata objects from a workspace and writes the information into a ZIP format file

  • Import utility

    • Reads the metadata information from an exported MDL file

    • Creates, replaces, or merges metadata objects into a workspace


Uses of metadata loader utilities
Uses of Metadata Loader Utilities

  • Use the Metadata Loader utilities to accomplish any of the following:

    • Back up a workspace

    • Populate a new workspace

    • Copy metadata in multiple-user development environments

    • Upgrade a workspace

Repository

Backup

Upgrade

Populate a new repository


Exporting objects
Exporting Objects

  • Before exporting, ensure that you have:

    • Required access privileges

    • Sufficient storage space

  • Ensure that all the objects you select for export in a single export task belong to the same navigator panel.

  • Keep in mind:

    • Exporting a subset of objects also exports their parent objects.

    • Export the objects referenced by a set of objects by selecting the “export all object dependencies” option.


Importing objects
Importing Objects

  • You must have read/write access to use the metadata loader import utility.

  • In a multi-user development environment, lock metadata objects before importing, because import alters the repository.

  • Back up your repository either using the Export utility or metadata snapshots before importing a large set of objects.

  • Ensure that the base language of the import MDL file is the same as the base language of the target repository.


Accessing the mdl utilities
Accessing the MDL Utilities

To export, from File menu, select Export > Warehouse Builder Metadata

To import, from File menu, select Import > Warehouse Builder Metadata


Metadata loader log file
Metadata Loader Log File

When exporting or importing metadata, you can specify the log file name and the path where you want to save the log file.


Importing metadata from previous versions
Importing Metadata from Previous Versions

  • While importing metadata, the MDL Import utility automatically upgrades metadata created with previous versions of Warehouse Builder to the current version.


Upgrading the repository
Upgrading the Repository

  • You can upgrade repositories from earlier versions of Warehouse Builder (10g R2 and 11g R1) to OWB 11.2.


Lesson agenda1
Lesson Agenda

  • MDL Export and Import

  • Manage metadata change using Snapshots

  • Version management

    • Generation comments

    • MDL annotations

    • Collection snapshots

  • Warehouse Builder users and roles

    • Security parameters


Manage life cycle changes

1.Change Channels.

2.Take snapshotbefore change.

3.Change source Channels.

6.Synchronizemapping tables.

7.Take snapshotafter change.

5.Invoke Impact Analysis Diagram.

9. Cancel change!!

8.Deploy changes:

  • Replace mapping.

10.Redeploy the original:

  • Replace mapping again.

Manage Life-Cycle Changes

4.ReimportChannelsmetadata.

Sorry…

No problem.Simply restoreoriginal snapshot!


Manage life cycle changes1

1.Change Channels.

9. Cancel change!!

Manage Life-Cycle Changes

4.ReimportChannelsmetadata.

2.Take snapshotbefore change.

3.Change source Channels.

6.Synchronizemapping tables.

7.Take snapshotafter change.

5.Invoke Impact Analysis Diagram.

Sorry…

8.Deploy changes:

  • Replace mapping.

10.Redeploy the original:

  • Replace mapping again.

No problem.Simply restoreoriginal snapshot!


Managing metadata changes by using snapshots
Managing Metadata Changes by Using Snapshots

  • Metadata snapshots enable you to:

    • Back up and restore your metadata

    • Maintain a history of metadata changes

    • Compare different versions of the metadata

  • There are two types of snapshots:

    • Full snapshot

    • Signature snapshot

  • You can perform the following tasks with snapshots:

    • Create, delete, or add components to a snapshot

    • Compare one snapshot with another object or snapshot

    • Restore snapshots

    • Export and import snapshots




Using change manager
Using Change Manager

  • Use toolbar icons for common tasks: restore, delete, and compare

  • Change Manager maintains the details of the time a snapshot was created, the owner, and the type of the snapshot. It also shows the components of the snapshot.

  • Menu options

  • Right-click the snapshot and select Security to set access privileges to the snapshot.


Exporting and importing snapshots
Exporting and Importing Snapshots

  • Snapshots are stored in the database, in contrast to Metadata Loader exports, which are stored as separate disk files.

  • You can export snapshots to disk files.


Managing backups development changes and security
Quiz

  • When you export a snapshot, an MDL file containing the snapshot is created.

    • True

    • False


Lesson agenda2
Lesson Agenda

  • MDL Export and Import

  • Manage metadata change using Snapshots

  • Version management

    • Generation comments

    • MDL annotations

    • Collection snapshots

  • Warehouse Builder users and roles

    • Security parameters


Version management of design objects
Version Management of Design Objects

  • Version Management is an important part of a multi-configuration management strategy.

  • For the smooth transition of objects from one system to another, you can version your objects at the following levels:

    • Code level, using the Generation Comments feature

    • Metadata (MDL) file level, using the annotations in the Import/Export feature

    • Repository-level versioning:

      • Collections

      • Snapshots

Dev

QA

Prod


Version management using generation code comments
Version Management: Using Generation Code Comments


Version management using annotations in export import
Version Management: Using Annotations in Export/Import

  • Using the annotations while exporting or importing metadata, you can version-control the MDL files (the metadata used to move between environments).

Specify annotations when exporting objects to an MDL file.

While importing, the File Summary dialog box displays the annotation.


Version management using collections and snapshots to version control
Version Management: Using Collections and Snapshots to Version-Control

  • Repository-based versioning relies on two features:

    • Collections

    • Metadata snapshots

  • Key steps:

    • Group a set of objects in a collection.

    • Create a snapshot to version the collection.

    • Compare objects in a snapshot with current workspace objects or with different versions of the same objects in another snapshot.

  • To revert to the old version, restore the snapshot.

    • When you restore a collection from a snapshot, you restore both the collection and the actual objects.



Managing backups development changes and security
Quiz Version-Control

  • If you are exporting your whole OWB project to a production environment and you want to make sure it is versioned, from the following options, select the method that you will use:

    • Generation comments for selected objects labelled as production

    • MDL file annotation marked with date and production build information

    • Create a collection of all the objects and snapshot it


Practice 12 1 overview managing metadata changes code and mdl file versions
Practice 12-1 Overview: Managing Metadata Changes, Code, and MDL File Versions

  • This practice covers the following topics:

    • Using snapshots for managing metadata changes

    • Performing version management

      • Using generation code comments and annotations in an MDL file


Lesson agenda3
Lesson Agenda MDL File Versions

  • MDL Export and Import

  • Manage metadata change using Snapshots

  • Version management

    • Generation comments

    • MDL annotations

    • Collection snapshots

  • Warehouse Builder users and roles

    • Security parameters


Warehouse builder users
Warehouse Builder Users MDL File Versions

  • Warehouse Builder users are regular database users.

  • Users can be created in the OWB client in one of the following ways:

    • On top of existing DB users

    • As a completely new user (OWB creates a new DB user)

  • If you are an OWB user, you have access to the OWB workspace.

  • If you are an OWB user, you can be:

    • An administrator of the workspace

    • An owner of a target

    • A regular repository user without owning a target

  • Control is given to users via roles or privileges.


Warehouse builder user considerations
Warehouse Builder User Considerations MDL File Versions

  • If you need a target user, register it in the OWB Security node in Globals Navigator panel.

    • The user is associated with a control center.

    • The user gets access to synonyms for the audit APIs.

    • You can deploy mappings only into a target user.

  • You can deploy DDL objects, such as tables, into a nontarget user.


Graphical ui for security management
Graphical UI for Security Management MDL File Versions

Only the workspace owner and other users granted the ADMINISTRATOR rolesee the Security node.


Workspace users roles and privileges
Workspace Users Roles and Privileges MDL File Versions

Important: By default, when you create a new user, that user has the EVERYONE role, which has full control on all objects. To enable metadata security, be sure to edit all user profiles and restrict the access that the EVERYONE role has to objects each user creates. Note that the workspace owner has both the EVERYONE and ADMINISTRATOR roles granted to it.



Everyone role
EVERYONE MDL File Versions Role

The Administrator can use the System Privilege link to deselect the privileges assigned to this role.


Administrator role
ADMINISTRATOR MDL File Versions Role

Registered OWB users can be granted the ADMINISTRATOR role by moving them to the grantees list here.

The privileges for an ADMINISTRATOR roles cannot be edited. Right?


Object level security
Object-Level Security MDL File Versions

Select the object in the navigator panel. From the View menu, select Security to set object-level security.


Access privilege policies
Access Privilege Policies MDL File Versions

  • Maximum access privilege policy

    • The default security policy

    • “No security”

    • All users get the object privilege of FULL_CONTROL through the EVERYONE role.

  • Minimum access privilege policy

    • “Least privileges”

    • All users get the object privilege of NONE through the PUBLIC role.

    • You can right-click any object in the Projects Navigator panel and set its security separately.


Setting security parameters
Setting Security Parameters MDL File Versions

Minimum security is the default,giving all users full access to all objects


Setting security parameters1
Setting Security Parameters MDL File Versions

Persist location password in metadata property eliminates the need to reenter a password.


Managing backups development changes and security
Quiz MDL File Versions

  • The EVERYONE role cannot be revoked from any user.

    • True

    • False


Summary
Summary MDL File Versions

  • In this lesson, you should have learned how to:

    • Use the MDL utilities to export and import metadata

    • Use snapshots to manage metadata changes

    • Version objects at various levels (code, MDL files, and at repository level using collections and snapshots)

    • Perform security and user-management tasks through the OWB Design Center graphical user interface


Practice 12 2 overview managing security
Practice 12-2 Overview: Managing Security MDL File Versions

  • This practice covers the following topics:

    • Assigning security by using the Design Center graphical interface