Preface
Using Metadata Manager
- Using Metadata Manager Overview
  - Resource Types
- Metadata Manager Architecture
- Metadata Integration Process
- Working with Metadata Manager
- Metadata Manager Interface
  - Load Tab
  - Permissions Tab
Configuring Metadata Manager
- Configuring Metadata Manager Overview
- Step 1. Create and Configure the Metadata Manager Service
- Step 2. Install the Metadata Manager Agent
Application Resources
- SAP R/3 Resource Overview
- Configuring SAP R/3
- Creating an SAP R/3 Resource
  - SAP R/3 Configuration Properties
- Configuring the Component Inclusion List
- Reference
Business Glossary Resources
- Business Glossary Resources Overview
- Application Services Verification
- Creating a Business Glossary Resource
  - Business Glossary Connection Properties
- Business Glossary Objects Extracted
- Business Glossary Objects Not Extracted
Business Intelligence Resources
- Business Objects
- Cognos
- Microsoft Analysis and Reporting Services
- Microstrategy
- Oracle Business Intelligence Enterprise Edition
- Tableau
- Incremental Metadata Load
- Adding or Removing Metadata Files for a Resource
Custom Resources
- Configuring Custom Metadata Sources
- Creating a Custom Resource
- Configuring the Template Name
- Adding or Removing Metadata Files for a Resource
Data Integration Resources
- Informatica Platform Resources
- Microsoft SQL Server Integration Services Resources
- PowerCenter Resources
Data Modeling Resources
- Embarcadero ERStudio
- ERwin
- SAP PowerDesigner
- Adding or Removing Metadata Files for a Resource
- Reference for Data Modeling Resources
Database Management Resources
- Cloudera Navigator
- IBM DB2 for LUW
- IBM Db2 for z/OS
- IBM Informix
- JDBC
- Microsoft SQL Server
- Netezza
- Oracle
- Sybase ASE
- Teradata
- Configuring the Schema Inclusion List
- Data Lineage for Database Management Resources
  - Tables in Join Statements
  - SQL Inline Views
Universal Resources
- Universal Resources Overview
- Available Metadata Sources
- XConnect Creation
- Resource Creation
  - Step 1. Configure the Metadata Source
  - Step 2. Create the Resource
    - Metadata Extraction from a Source File
Managing Resources
- Managing Resources Overview
- Configure Connection Assignments
- Upload Rule Sets
  - Linking Rules Files
  - Uploading a Rule Set
- Purging Metadata
- Refreshing the Resources Panel
- Updating the Search Index
- Customizing the List of Words to Ignore in Searches
Loading and Monitoring Resources
- Loading and Monitoring Resources Overview
- Loading Resources
- Linking Objects Across Resources
- Monitoring Resources
- Logs and Log Files
- Troubleshooting Resource Loads
- Scheduling Resource Loads
Managing Permissions
- Managing Permissions Overview
- Configuring Permissions for Users and Groups
- Configuring Permissions on the Metadata Catalog
Resource Migration
- Resource Migration Overview
- Resource Migration Steps
- Step 1. Copy the Plug-in for a Universal XConnect
- Step 2. Migrate the Model
  - Exporting a Packaged or Universal Model
  - Importing a Packaged or Universal Model
- Step 3. Migrate the Resource Configuration
  - Exporting a Resource Configuration
  - Importing a Resource Configuration
- Step 4. Load the Resource
- Step 5. Migrate Resource Metadata
  - Exporting Resource Metadata
  - Importing Resource Metadata
Repository Migration
- Repository Migration Overview
- Migrating the Repository when Domain Names and Encryption Keys are the Same
- Migrating the Repository when Domain Names or Encryption Keys Differ
Appendix A: Metadata Manager Login
- Metadata Manager Login Overview
- Cookies
- Logging in to Metadata Manager
- Changing a Password
Appendix B: Metadata Manager Properties Files
- imm.properties
  - Metadata Manager Application Properties
  - Data Lineage Properties
- searchpriorities.xml
  - Search Result Configuration
  - Sample searchpriorities.xml File
Appendix C: Resource Configuration Files
- Resource Configuration Files Overview
- Resource Configuration File Format
- Passwords in Resource Configuration Files
- Secure JDBC Parameters in Resource Configuration Files
- Sample Resource Configuration File
Appendix D: Glossary
- Glossary of Terms

Metadata Manager Administrator Guide

10.5.6
- 10.5.5
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Creating a PowerCenter Resource

Before you create a PowerCenter resource, configure the PowerCenter source.

On the

Load

tab, click

Actions

New Resource

The

Resource Selection

window appears.

Click

Data Integration

PowerCenter

Click

The

Properties

window appears.

Enter the following information:

Property	Description
Name	Name for the resource. The resource appears in the Resources panel with this name. The name must be unique and have from one through 256 characters. It cannot include the following characters: / \ : * ' ? " < > \| [ ]
Description	Description for the resource. Description cannot exceed 4000 characters.
Hide in Summary Lineage	Hides the resource in the summary view of data lineage diagrams. Enable this option to hide the resource and its child objects in the summary view. Disable this option to display the resource and its child objects in the summary view. Default is disabled.

Click

The

Configuration

window appears.

Configure the connection properties.

Click

Test Connection

to test the connection to the source system.

If Metadata Manager cannot connect to the source system, an error message appears. Correct the error and test the connection again.

Click

The

Parameters

window appears.

Configure the folders to extract metadata from.

To add folders to the

Selected Folders

list, select the folder in the

Available Folders

list and click

Add

. To add all available folders, click

Add All

To remove folders from the

Selected Folders

list, select the folder in the

Selected Folders

list and click

Remove

. To remove all folders from the

Selected Folders

list, click

Remove All

Configure the number of days for the

Source Increment Extract

window.

Click

The

Parameter Files

window appears.

To upload parameter files, click

Upload

To remove an uploaded parameter file, select the file and click

Delete

Click

Auto-assign

to direct Metadata Manager to analyze the PowerCenter repository and automatically assign the uploaded parameter files to each workflow that specifies the parameter file name.

Or, select a parameter file in the

Parameter Files

list, select one or more folders or workflows in the

Workflow Folders

list, and click

Assign

Or, select a parameter file and click

Assign to All

to assign the parameter file to all workflows.

When you configure a PowerCenter workflow, if you use an absolute file name or the $PMFolderName and $PMWorkflowName workflow variables to specify the parameter file name, Metadata Manager uses this value to automatically assign the parameter file to the workflow. If you use any other workflow variable for configuring the parameter file name, you must manually assign the parameter file to the workflow.

To remove a parameter file from a workflow, click

Remove

for the parameter file in the bottom panel.

Click

The

Schedules

window appears.

To add a schedule, select

Attach a Schedule

, and select a schedule in the

Schedule

list.