Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Catalog Service
  4. Content Management Service
  5. Data Integration Service
  6. Data Integration Service Architecture
  7. Data Integration Service Management
  8. Data Integration Service Grid
  9. Data Integration Service Applications
  10. Interactive Data Preparation Service
  11. Enterprise Data Preparation Service
  12. Informatica Cluster Service
  13. Mass Ingestion Service
  14. Metadata Access Service
  15. Metadata Manager Service
  16. Model Repository Service
  17. PowerCenter Integration Service
  18. PowerCenter Integration Service Architecture
  19. High Availability for the PowerCenter Integration Service
  20. PowerCenter Repository Service
  21. PowerCenter Repository Management
  22. PowerExchange Listener Service
  23. PowerExchange Logger Service
  24. SAP BW Service
  25. Search Service
  26. System Services
  27. Test Data Manager Service
  28. Test Data Warehouse Service
  29. Web Services Hub
  30. Application Service Upgrade
  31. Appendix A: Application Service Databases
  32. Appendix B: Connecting to Databases from Windows
  33. Appendix C: Connecting to Databases
  34. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Metadata Manager Service Properties

Metadata Manager Service Properties

The following table describes the properties that you configure for the Metadata Manager Service:
Property
Description
Name
Name of the Metadata Manager Service. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters:
` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
Description
The description cannot exceed 765 characters.
Location
Domain and folder where the service is created. Click Browse to choose a different folder. You can move the Metadata Manager Service after you create it.
License
License object that allows use of the service.
Node
Node in the Informatica domain that the Metadata Manager Service runs on.
Associated Integration Service
PowerCenter Integration Service used by Metadata Manage to load metadata into the Metadata Manager warehouse.
Repository User Name
User account for the PowerCenter repository. Use the repository user account you configured for the PowerCenter Repository Service. For a list of the required privileges for this user, see Privileges for the Associated PowerCenter Integration Service User.
Repository Password
Password for the PowerCenter repository user.
Security Domain
Name of the security domain to which the PowerCenter repository user belongs.
Database Type
Type of database for the Metadata Manager repository.
Code Page
Metadata Manager repository code page. The Metadata Manager Service and Metadata Manager application use the character set encoded in the repository code page when writing data to the Metadata Manager repository.
The Metadata Manager repository code page, the code page on the machine where the associated PowerCenter Integration Service runs, and the code page for any database management and PowerCenter resources that you load into the Metadata Manager warehouse must be the same.
Connect String
Native connect string to the Metadata Manager repository database. The Metadata Manager Service uses the connect string to create a connection object to the Metadata Manager repository in the PowerCenter repository.
Database User
User account for the Metadata Manager repository database. Set up this account with the appropriate database client tools.
Database Password
Password for the Metadata Manager repository database user. Must be in 7-bit ASCII.
Tablespace Name
Tablespace name for Metadata Manager repositories on IBM DB2. When you specify the tablespace name, the Metadata Manager Service creates all repository tables in the same tablespace. You cannot use spaces in the tablespace name.
To improve repository performance on IBM DB2 EEE repositories, specify a tablespace name with one node.
Database Hostname
Host name for the Metadata Manager repository database.
Database Port
Port number for the Metadata Manager repository database.
SID/Service Name
Indicates whether the Database Name property contains an Oracle full service name or SID.
Database Name
Full service name or SID for Oracle databases. Service name for IBM DB2 databases. Database name for Microsoft SQL Server databases.
Additional JDBC Parameters
Additional JDBC parameters that you want to append to the database connection URL. Enter the parameters as name=value pairs separated by semicolon characters (;). For example:
param1=value1;param2=value2
You can use this property to specify the following information:
  • Backup server location. If you use a database server that is highly available such as Oracle RAC, enter the location of a backup server.
  • Oracle Advanced Security Option (ASO) parameters. If the Metadata Manager repository database is an Oracle database that uses ASO, enter the following additional parameters:
    EncryptionLevel=[encryption level];EncryptionTypes=[encryption types];DataIntegrityLevel=[data integrity level];DataIntegrityTypes=[data integrity types]
    The parameter values must match the values in the sqlnet.ora file on the machine where the Metadata Manager Service runs.
  • Authentication information for Microsoft SQL Server.
    The Metadata Manager Service does not support the alternateID option for DB2.
    To authenticate the user credentials with Windows authentication and establish a trusted connection to a Microsoft SQL Server repository, enter the following text:
    AuthenticationMethod=ntlm
    ;
    LoadLibraryPath=[directory containing DDJDBCx64Auth04.dll]
    .
    jdbc:informatica:sqlserver://[host]:[port];DatabaseName=[DB name];AuthenticationMethod=ntlm;
    LoadLibraryPath=[directory containing DDJDBCx64Auth04.dll]
    When you use a trusted connection to connect to a Microsoft SQL Server database, the Metadata Manager Service connects to the repository with the credentials of the user logged in to the machine on which the service is running.
    To start the Metadata Manager Service as a Windows service with a trusted connection, configure the Windows service properties to log on with a trusted user account.
Secure JDBC Parameters
Secure JDBC parameters that you want to append to the database connection URL. Use this property to specify secure connection parameters such as passwords. The Administrator tool does not display secure parameters or parameter values in the Metadata Manager Service properties. Enter the parameters as name=value pairs separated by semicolon characters (;). For example:
param1=value1;param2=value2
If secure communication is enabled for the Metadata Manager repository database, enter the secure JDBC parameters in this property.
Port Number
Port number the Metadata Manager application runs on. Default is 10250.
Enable Secured Socket Layer
Indicates that you want to configure a secure connection for the Metadata Manager web application. If you enable this option, you must create a keystore file that contains the required keys and certificates.
You can create a keystore file with keytool. keytool is a utility that generates and stores private or public key pairs and associated certificates in a keystore file. When you generate a public or private key pair, keytool wraps the public key into a self-signed certificate. You can use the self-signed certificate or use a certificate signed by a certificate authority.
Keystore File
Keystore file that contains the keys and certificates required if you configure a secure connection for the Metadata Manager web application. Required if you select Enable Secured Socket Layer.
Keystore Password
Password for the keystore file. Required if you select Enable Secured Socket Layer.