Table of Contents

Search

  1. Preface
  2. Analyst Service
  3. Content Management Service
  4. Data Integration Service
  5. Data Integration Service Architecture
  6. Data Integration Service Management
  7. Data Integration Service Grid
  8. Data Integration Service Applications
  9. Metadata Manager Service
  10. Model Repository Service
  11. PowerCenter Integration Service
  12. PowerCenter Integration Service Architecture
  13. High Availability for the PowerCenter Integration Service
  14. PowerCenter Repository Service
  15. PowerCenter Repository Management
  16. PowerExchange Listener Service
  17. PowerExchange Logger Service
  18. SAP BW Service
  19. Search Service
  20. System Services
  21. Test Data Manager Service
  22. Web Services Hub
  23. Application Service Upgrade
  24. Application Service Databases
  25. Connecting to Databases from Windows
  26. Connecting to Databases from UNIX
  27. Updating the DynamicSections Parameter of a DB2 Database

Database Properties

Database Properties

You can edit the Metadata Manager repository database properties. Select the Metadata Manager Service in the Navigator, select the
Properties
view, and then click
Edit
in the
Database Properties
section.
The following table describes the database properties for a Metadata Manager repository database:
Property
Description
Database Type
Type of database for the Metadata Manager repository. To apply changes, restart the Metadata Manager Service.
Code Page
Metadata Manager repository code page. The Metadata Manager Service and Metadata Manager use the character set encoded in the repository code page when writing data to the Metadata Manager repository. To apply changes, restart the Metadata Manager Service.
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 connection string to create a target connection to the Metadata Manager repository in the PowerCenter repository.
To apply changes, restart the Metadata Manager Service.
Database User
User account for the Metadata Manager repository database. Set up this account using the appropriate database client tools. To apply changes, restart the Metadata Manager Service.
Database Password
Password for the Metadata Manager repository database user. Must be in 7-bit ASCII. To apply changes, restart the Metadata Manager Service.
Tablespace Name
Tablespace name for the Metadata Manager repository 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 apply changes, restart the Metadata Manager Service.
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. To apply changes, restart the Metadata Manager Service.
Database Port
Port number for the Metadata Manager repository database. To apply changes, restart the Metadata Manager Service.
SID/Service Name
Indicates whether the Database Name property contains an Oracle full service name or an SID.
Database Name
Full service name or SID for Oracle databases. Service name for IBM DB2 databases. Database name for Microsoft SQL Server databases. To apply changes, restart the Metadata Manager Service.
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 using 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 using a trusted connection, configure the Windows service properties to log on using 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.
To update the secure JDBC parameters, click
Modify Secure JDBC Parameters
and enter the new values.