Metadata Manager
This section describes new Metadata Manager features in version 9.6.1.
Glossary View
When you view a category or business term in the Glossary view, you can open the category or term in the Analyst tool by clicking the View in Informatica Analyst toolbar icon.
For more information, see the Informatica 9.6.1 Metadata Manager User Guide.
Resource Properties
Effective in version 9.6.1, database management, JDBC, and Microstrategy resources have new resource configuration properties.
- Database Management Resources
The following table describes the new resource configuration property for database management resources:
Property | Description |
|---|
Secure JDBC Parameters | Secure JDBC parameters that you want to append to the JDBC connection URL. |
- JDBC Resources
The following table describes the new resource configuration property for JDBC resources:
Property | Description |
|---|
Case sensitivity | Specifies the case sensitivity setting for the metadata source database. By default, the Metadata Manager Agent uses the JDBC driver to determine whether the database is case sensitive. |
- Microstrategy Resources
The following table describes the new resource configuration property for Microstrategy 7.0 - 9.x resources:
Property | Description |
|---|
Import schema only | Imports the schemas for the selected projects without the reports and documents. By default, Metadata Manager imports the schemas, reports, and documents. |
For more information, see the Informatica 9.6.1 Metadata Manager Administrator Guide.
Resource Versions
You can create resources of the following versions:
- •Business Objects 14.1 (XI 4.1 SP2). Previously, you could create Business Objects resources up to version 14 (XI R4) SP6.
- •Microstrategy 9.4.1. Previously, you could create Microstrategy resources up to version 9.3.1.
- •Oracle 12c. Previously, you could create Oracle resources up to version 11g Release 2.
For information about creating resources, see the Informatica 9.6.1 Metadata Manager Administrator Guide.
Search
You can create a custom list of words and phrases to ignore in keyword and advanced searches.
For more information, see the Informatica 9.6.1 Metadata Manager Administrator Guide.
Security
Metadata Manager contains the following security enhancements:
- Encryption Key Support
Metadata Manager uses the encryption key for the Informatica domain to encrypt sensitive data, such as passwords, in the Metadata Manager repository.
For more information about the encryption key for the Informatica domain, see the Informatica 9.6.1 Security Guide.
- Secure JDBC Parameters
You can prevent the Administrator tool from displaying secure JDBC parameters that are part of the Metadata Manager repository database URL. You can also prevent Metadata Manager from displaying secure JDBC parameters that are part of the database connection URL for some database management resources.
You can prevent Metadata Manager from displaying secure JDBC parameters for the following database management resources:
- - IBM DB2 for LUW
- - IBM Informix
- - Microsoft SQL Server
- - Netezza
- - Oracle
- - Sybase ASE
- - Teradata
For information about specifying secure JDBC parameters in the Metadata Manager repository database URL, see the Informatica 9.6.1 Application Service Guide. For information about specifying secure JDBC parameters in the database connection URL for database management resources, see the Informatica 9.6.1 Metadata Manager Administrator Guide.
- Custom Metadata Configurator
To increase security for the PowerCenter repository, the Custom Metadata Configurator prompts you for the PowerCenter repository user name and password when you generate the mappings that extract metadata from custom metadata files.
For more information, see the Informatica 9.6.1 Metadata Manager Custom Metadata Integration Guide.