Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux
  10. Appendix C: Connecting to Databases from Windows
  11. Appendix D: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Create the Metadata Manager Service

Create the Metadata Manager Service

Use the service creation wizard in the Administrator tool to create the service.
Before you create the Metadata Manager Service, verify that you created and enabled the following services:

    PowerCenter Repository Service

    PowerCenter Integration Service

  1. In the Administrator tool, click the
    Manage
    tab.
  2. Click
    Actions
    New
    Metadata Manager Service
    .
    The
    New Metadata Manager Service
    dialog box appears.
  3. On the
    New Metadata Manager Service - Step 1 of 3
    page, enter the following properties:
    Property
    Description
    Name
    Name of the 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
    Description of the service. 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 service after you create it.
    License
    License object that allows use of the service.
    Node
    Node on which the service runs.
  4. Specify the following properties of the associated repository service:
    Property
    Description
    Associated Integration Service
    Select the PowerCenter Integration Service used by Metadata Manager to load metadata into the Metadata Manager warehouse.
    Repository User Name
    User name that the service uses to access the PowerCenter Repository Service. Enter the PowerCenter repository user that you created. Required when you associate a PowerCenter Repository Service with the service.
    Not available for a domain with Kerberos authentication.
    Repository Password
    Password associated with the PowerCenter repository user.
    Not available for a domain with Kerberos authentication.
    Security Domain
    LDAP security domain for the PowerCenter repository user. The
    Security Domain
    field appears when the Informatica domain contains an LDAP security domain. Required when you associate a PowerCenter Repository Service with the service.
    Not available for a domain with Kerberos authentication.
  5. Click
    Next
    .
    The
    New Metadata Manager Service - Step 2 of 3
    page appears.
  6. Enter the following database properties for the Metadata Manager repository:
    Property
    Description
    Database Type
    The type of the repository database.
    Code Page
    Metadata Manager repository code page. The Metadata Manager Service and the Metadata Manager application use the character set encoded in the repository code page when writing data to the Metadata Manager repository.
    You can enable the Metadata Manager Service only after you specify the code page.
    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.
    Use the following native connect string syntax for each supported database:
    • servername@databasename
      for Microsoft SQL Server.
    • databasename.world
      for Oracle.
    • databasename
      for IBM DB2.
    Database User
    The database user name for the repository.
    Database Password
    Password for the Metadata Manager repository database user. Must be in 7-bit ASCII.
    Tablespace Name
    Name of the tablespace in which to create all the repository database tables. You cannot use spaces in the tablespace name.
    Available for IBM DB2 databases.
    To improve repository performance on IBM DB2 EEE repositories, specify a tablespace name with one node.
    Database Hostname
    The name of the machine that hosts the database server.
    Database Port
    The port number on which you configure the database server listener service.
    SID/Service Name
    For Oracle databases. Indicates whether to use the SID or service name in the JDBC connection string. For Oracle RAC databases, select from Oracle SID or Oracle service name. For other Oracle databases, select Oracle SID.
    Database Name
    The name of the database server.
    Specify the full service name or SID for Oracle databases, service name for IBM DB2 databases, and database name for Microsoft SQL Server databases.
  7. If you want to append parameters to the database connection URL, configure additional parameters in the
    Additional JDBC Parameters
    field. 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 parameters:
    Parameter
    Description
    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
    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.
  8. If the Metadata Manager repository database is configured for secure communication, you can configure additional JDBC parameters in the
    Secure JDBC Parameters
    field.
    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
    .
    Enter the following secure database parameters:
    Secure Database Parameter
    Description
    EncryptionMethod
    Required. Indicates whether data is encrypted when transmitted over the network. This parameter must be set to
    SSL
    .
    TrustStore
    Required. Path and file name of the truststore file that contains the SSL certificate of the database server.
    TrustStorePassword
    Required. Password used to access the truststore file.
    HostNameInCertificate
    Host name of the machine that hosts the secure database. If you specify a host name, the Metadata Manager Service validates the host name included in the connection string against the host name in the SSL certificate.
    ValidateServerCertificate
    Optional. Indicates whether Informatica validates the certificate that the database server sends.
    If this parameter is set to True, Informatica validates the certificate that the database server sends. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
    If this parameter is set to False, Informatica does not validate the certificate that the database server sends. Informatica ignores any truststore information that you specify.
    KeyStore
    Path and file name of the keystore file that contains the SSL certificates that the Metadata Manager Service sends to the database server.
    KeyStorePassword
    Password used to access the keystore file.
  9. Click
    Next.
    The
    New Metadata Manager Service - Step 3 of 3
    page appears.
  10. Enter the HTTP port number to use for the service.
  11. To enable secure communications with the Metadata Manager Service, select
    Enable Secured Socket Layer
    .
    Enter the following properties to configure secure communication for the service:
    Property
    Description
    HTTPS Port
    Port number to use for a secure connection to the service. Use a different port number than the HTTP port number.
    Keystore File
    Path and file name of the keystore file that contains the private or public key pairs and associated certificates. Required if you use HTTPS connections for the service.
    Keystore Password
    Plain-text password for the keystore file.
  12. Click
    Finish
    .
    The domain creates the Metadata Manager Service. The domain does not enable the Metadata Manager Service during the service creation process.
  13. To enable the Metadata Manager Service, select the service in the Navigator and click
    Actions
    Enable Service
    . The PowerCenter Repository Service and PowerCenter Integration Service must be running to enable the Metadata Manager Service.
After you create the service through the wizard, you can edit the properties or configure other properties.