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 a Domain

Create a Domain

Create a domain if you are installing for the first time or if you want to administer nodes in separate domains.
  1. Log in to the machine with a system user account.
  2. Close all other applications.
  3. Go to the root of the directory for the installation files and run install.bat as administrator.
    To run the file as administrator, right-click the install.bat file and select
    Run as administrator
    .
    If you do not run the installer as administrator, the Windows system administrator might encounter issues when accessing files in the Informatica installation directory.
    The
    Informatica 10.4.1
    page appears.
  4. Select
    Install Informatica 10.4.1
    .
    This image describes the options to install Informatica
    Informatica provides utilities to facilitate the Informatica services installation process. Run the following utilities before you install Informatica services:
    • Pre-Installation (i10Pi) System Check Tool. Verifies whether the machine on which you are installing Informatica services meets the system requirements for installation.
      For more information about running the Pre-Installation (i10Pi) System Check Tool, see Run the Pre-Installation (i10Pi) System Check Tool in Graphical Mode.
    • Informatica Kerberos SPN Format Generator. Creates a list of the Kerberos service principal names and keytab file names required to run Informatica services on a network with Kerberos authentication.
    You can use the installer to run the utilities before you install informatica services. After you finish running a utility, restart the installer to run the next utility or install informatica services.
  5. Click
    Start
    .
  6. Read the terms and conditions for Informatica installation and the product usage toolkit and select
    I agree to the terms and conditions
    .
    Informatica DiscoveryIQ is a product usage tool that sends routine reports on data usage and system statistics to Informatica. Informatica DiscoveryIQ uploads data to Informatica 15 minutes after you install and configure Informatica domain. Thereafter, the domain sends the data every 30 days. You can choose to disable usage statistics from the Administrator tool.
  7. Click
    Next
    .
    The
    Installation Prerequisites
    page displays the installation requirements. Verify that all requirements are met before you continue the installation.
  8. Click
    Next
    .
    The
    License and Installation Directory
    page appears.
    This image describes about the installation directory, enabling kerberos network for the Informatica domain, license key, and the installation environment.
  9. Enter the Informatica license key, installation directory, and the installation environment.
    The following table describes the license key and directory that you specify for the Informatica services installation:
    Property
    Description
    License key file
    Path and file name of the Informatica license key.
    Installation directory
    Absolute path for the installation directory. The installation directory must be on the machine where you are installing Informatica. The directory names in the path must not contain spaces or the following special characters:
    @ | * $ # ! % ( ) { } [ ]
    Informatica recommends using alphanumeric characters in the installation directory path. If you use a special character such as á or €, unexpected results might occur at run time.
    Installation environment
    Environment type associated with the Informatica services installation.
    • Set Sandbox environment for a basic environment used for proof of concept with minimal users.
    • Set Development environment for the design environment.
    • Set Test environment for high volume processing that is closest to a production environment.
    • Set Production environment for high volume processing with high levels of concurrency meant for end users. Advanced production environments are typically multi-node setups.
  10. To configure the Informatica domain to run on a network with Kerberos authentication, select the checkbox to enable Kerberos network authentication.
  11. Click
    Next
    .
    If you do not enable Kerberos network authentication, the
    Pre-Installation Summary
    page appears. Skip to step 15.
    If you enable Kerberos network authentication, the
    Network Security - Service Principal Level
    page appears.
    This image describes the network security information.
  12. On the
    Network Security - Service Principal Level
    page, select the level at which to set the Kerberos service principals for the domain.
    The following table describes the service principal levels that you can select:
    Level
    Description
    Process Level
    Configures the domain to use a unique service principal name (SPN) and keytab file for each node and each application service on a node.
    The number of SPNs and keytab files required for each node depends on the number of application service processes that run on the node. Use the process level option for domains that require a high level of security, such as productions domains.
    Node Level
    Configures the domain to share SPNs and keytab files on a node.
    This option requires one SPN and keytab file for the node and all application services that run on the node. It also requires a separate SPN and keytab file for all HTTP processes on the node.
    Use the node level option for domains that do not require a high level of security, such as test and development domains.
  13. Click
    Next
    .
    The
    Network Security - Kerberos Authentication
    page appears.
    This image describes about the network security kerberos authentication parameters.
  14. Enter the domain and keytab information required for Kerberos authentication.
    The following table describes the Informatica domain and node information that you must provide:
    Property
    Description
    Domain name
    Name of the domain to create.
    The name must not exceed 128 characters and must be 7-bit ASCII only. The name cannot contain a space or any of the following characters:
    ` % * + ; " ? , < > \ /
    Node name
    Name of the node to create.
    Node host name
    Fully qualified host name or IP address of the machine on which to create the node.
    The node host name cannot contain the underscore (_) character. Do not use localhost. The host name must explicitly identify the machine.
    The following table describes the Kerberos realm and keytab information that you must provide:
    Property
    Description
    Service realm name
    Name of the Kerberos realm that the domain uses to authenticate users. The realm name must be in uppercase and is case-sensitive.
    To configure Kerberos cross realm authentication, specify the name of each Kerberos realm that the domain uses to authenticate users, separated by a comma. For example:
    COMPANY.COM,EAST.COMPANY.COM,WEST.COMPANY.COM
    Use an asterisk as a wildcard character before a realm name to include all realms that include the name. For example:
    *EAST.COMPANY.COM
    User realm name
    Name of the Kerberos realm that the domain uses to authenticate users. The realm name must be in uppercase and is case-sensitive.
    To configure Kerberos cross realm authentication, specify the name of each Kerberos realm that the domain uses to authenticate users, separated by a comma. For example:
    COMPANY.COM,EAST.COMPANY.COM,WEST.COMPANY.COM
    Use an asterisk as a wildcard character before a realm name to include all realms that include the name. For example:
    *EAST.COMPANY.COM
    Keytab directory
    Directory where all keytab files for the Informatica domain are stored. The name of a keytab file in the Informatica domain must follow a format set by Informatica.
    Kerberos configuration file
    Path and file name of the Kerberos configuration file. Informatica requires the following name for the Kerberos configuration file:
    krb5.conf
    If you configure the domain to run with Kerberos authentication, the domain and node name and the node host name must match the names you specified when you ran the Informatica Kerberos SPN Format Generator to generate SPN and keytab file names. If you use a different domain, node, or host name, generate the SPN and keytab file names again and ask the Kerberos administrator to add the new SPN to the Kerberos principal database and create the keytab files.
  15. Click
    Next
    .
    The
    Pre-Installation Summary
    page appears.
    This image describes the pre-installation summary.
  16. Review the installation information, and click
    Install
    to continue.
    The installer copies the Informatica files to the installation directory. After the installer copies the files, the
    Domain Selection
    page appears.
    This image describes about creating a domain or join a domain on a node.
  17. Select
    Create a domain
    .
    When you create a domain, the node that you create becomes a gateway node in the domain. The gateway node contains a Service Manager that manages all domain operations.
  18. Select the checkbox to enable secure communication between services in the domain.
    By default, if you enable secure communication for the domain, the installer sets up an HTTPS connection for the Informatica Administrator. You can also create a domain configuration repository on a secure database.
  19. To secure the connection to Informatica Administrator, select
    Enable HTTPS for Informatica Administrator
    .
    The following table describes the properties that you set for a secure connection to the Administrator tool:
    Property
    Description
    Enable HTTPS for Informatica Administrator
    Select this option to secure the connection to Informatica Administrator. To use an unsecure HTTP connection, clear the option.
    By default, if secure communication is enabled for the domain, the installer enables this option. You can also enable this option even if you do not enable secure communication for the domain.
    Port
    The port to use for communication between Informatica Administrator and the Service Manager.
    Use a keystore file generated by the installer
    Use a self-signed keystore file generated by the installer. The installer creates a keystore file named Default.keystore in the following location:
    <Informatica installation directory>\tomcat\conf\
    Specify a keystore file and password
    Use a keystore file that you create. You can use a keystore file with a self-signed certificate or a certificate signed by a certification authority.
    Keystore password
    A plain-text password for the keystore file. Required if you use a keystore file that you create.
    Keystore file
    Path and file name of the keystore file. Required if you use a keystore file that you create.
  20. To configure Security Assertion Markup Language (SAML) based single sign-on (SSO) support for web-based Informatica applications in an Informatica domain, select the checkbox to enable SAML authentication.
    If you enable Kerberos network authentication, you cannot configure SAML authentication.
  21. Click
    Next
    .
    If you select the checkbox to enable SAML authentication option, the
    SAML Authentication
    page appears.
    This image describes about SAML authentication that you can enter to configure the single sign on support for Informatica web application.
  22. Enter the Identity Provider URL for the domain.
  23. Enter the identity provider assertion signing certificate alias name.
  24. Specify whether to use the default Informatica SSL certificates or to use your SSL certificates to enable secure communication in the domain.
    The following table describes the SSL certificate options for SAML authentication:
    Option
    Description
    Use the default Informatica SSL certificate file.
    Select to use the default Informatica truststore file for SAML authentication.
    Enter the location of the SSL certificate file.
    Select to use a custom truststore file for SAML authentication. Specify the directory containing the custom truststore file on gateway nodes within the domain. Specify the directory only, not the full path to the file.
  25. If you provide the security certificates, specify the location and passwords of the keystore and truststore files.
    The following table describes the location and password of the truststore file:
    Property
    Description
    Truststore Directory
    Specify the directory containing the custom truststore file on gateway nodes within the domain. Specify the directory only, not the full path to the file.
    Truststore Password
    The password for the custom truststore file.
  26. Click
    Next
    .
    If you do not enable secure communication for the domain, the
    Domain Configuration Repository
    page appears. Skip to step 30.
    If you selected the checkbox to enable secure communication for the domain, the
    Domain Security - Secure Communication
    page appears.
    This image describes about selecting the security certificates to secure the domain
  27. On the
    Domain Security - Secure Communication
    page, specify whether to use the default Informatica SSL certificates or to use your SSL certificates to enable secure communication in the domain.
    The following table describes the SSL certificate options for securing the Informatica domain:
    Option
    Description
    Use the default Informatica SSL certificate files
    Use the default SSL certificates provided by Informatica.
    If you do not provide an SSL certificate, Informatica uses the same default private key for all Informatica installations. If you use the default Informatica keystore and truststore files, the security of your domain could be compromised. To ensure a high level of security for the domain, select the option to specify the location of the SSL certificate files.
    Specify the location of the SSL certificate files
    Use SSL certificates that you provide. You must specify the location of the keystore and truststore files.
    You can provide a self-signed certificate or a certificate issued by a certificate authority (CA). You must provide SSL certificates in PEM format and in Java Keystore (JKS) files. Informatica requires specific names for the SSL certificate files for the Informatica domain. You must use the same SSL certificates for all nodes in the domain. Store the truststore and keystore files in a directory accessible to all the nodes in the domain and specify the same keystore file directory and truststore file directory for all nodes in the same domain.
  28. If you provide the security certificates, specify the location and passwords of the keystore and truststore files.
    The following table describes the parameters that you must enter for the SSL certificate files:
    Property
    Description
    Keystore file directory
    Directory that contains the keystore files. The directory must contain files named infa_keystore.jks and infa_keystore.pem.
    Keystore password
    Password for the keystore infa_keystore.jks.
    Truststore file directory
    Directory that contains the truststore files. The directory must contain files named infa_truststore.jks and infa_truststore.pem.
    Truststore password
    Password for the infa_truststore.jks file.
  29. Click
    Next
    .
    The
    Domain Configuration Repository
    page appears.
    This image describes about configuring the database for the domain configuration repository.
  30. On the
    Domain Configuration Repository
    page, enter the database and user account information for the domain configuration repository.
    The domain configuration repository stores metadata for domain operations and user authentication. The database must be accessible to all gateway nodes in the domain.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the repository. Select one of the following databases:
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    • PostgreSQL
    • Sybase ASE
    Database user ID
    User account for the repository database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
    If you enabled secure communication for the domain, you can create the domain configuration repository in a database secured with the SSL protocol. Select the checkbox if you want to secure a database and skip to step 32.
    You cannot configure a secure connection to a Sybase database.
  31. Enter the database connection information.
    If you do not create a secure domain configuration repository, you can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      The following table describes the JDBC URL properties that you specify:
      Property
      Description
      Database address
      Host name and port number for the database in the format
      host_name:port
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      • Sybase ASE: Enter the database name.
      • PostgreSQL: Enter the database name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.
    • To connect using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
  32. If you choose to secure a database, enter the connection information using a custom JDBC connection string.
    If you create the repository on a secure database, you must provide the truststore information for the database. You must also provide a JDBC connection string that includes the security parameters for the database.
    The following table describes the properties you must set for a secure database:
    Property
    Description
    Database truststore file
    Path and file name of the truststore file for the secure database.
    Database truststore password
    Password for the truststore file.
    Custom JDBC Connection String
    JDBC connection string to connect to the secure database, including the host name and port number and the security parameters for the database.
    For information about the security parameters you must include in the JDBC connection for a secure database, see Connection String to a Secure Database.
  33. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  34. Click
    Next
    .
    The
    Domain Security - Encryption Key
    page appears.
    This image describes about the domain security encryption key.
  35. Enter the keyword and directory for the encryption key of the Informatica domain.
    The following table describes the encryption key parameters that you must specify:
    Property
    Description
    Keyword
    Keyword to use to create a custom encryption key to secure sensitive data in the domain. The keyword must meet the following criteria:
    • From 8 to 20 characters long
    • Includes at least one uppercase letter
    • Includes at least one lowercase letter
    • Includes at least one number
    • Does not contain spaces
    The encryption key is created based on the keyword that you provide when you create the Informatica domain.
    Encryption key directory
    Directory in which to store the encryption key for the domain. By default, the encryption key is created in the following directory:
    <Informatica installation directory>/isp/config/keys
    .
  36. Click
    Next
    .
    The
    Domain and Node Configuration
    page appears.
    This image describes the domain node configuration information.
  37. Enter the information for the domain and the node that you want to create.
    The following table describes the properties that you set for the domain and gateway node:
    Property
    Description
    Domain name
    Name of the Informatica domain to create. The default domain name is Domain_<MachineName>.
    The name must not exceed 128 characters and must be 7-bit ASCII only. The name cannot contain a space or any of the following characters:
    ` % * + ; " ? , < > \ /
    Node name
    Name of the node to create.
    Node host name
    Host name or IP address of the machine on which to create the node.
    If the machine has a single network name, use the default host name. If the a machine has multiple network names, you can modify the default host name to use an alternate network name.
    The node host name cannot contain the underscore (_) character. Do not use localhost. The host name must explicitly identify the machine.
    Node port number
    Port number for the node. The default port number for the node is 6005. If the port number is not available on the machine, the installer displays the next available port number.
    Domain user name
    User name for the domain administrator. You can use this user name to initially log in to Informatica Administrator. Use the following guidelines:
    • The name is not case sensitive and cannot exceed 128 characters.
    • The name cannot include a tab, newline character, or the following special characters: % * + / ? ; < >
    • The name can include an ASCII space character except for the first and last character. Other space characters are not allowed.
    Domain password
    Password for the domain administrator. The password must be more than 2 characters and must not exceed 16 characters.
    Not available if you configure the Informatica domain to run on a network with Kerberos authentication.
    Confirm password
    Enter the password again to confirm.
    Not available if you configure the Informatica domain to run on a network with Kerberos authentication.
  38. To display the default ports for the domain and node components assigned by the installer, enable
    Display advanced port configuration page
    .
    If you display the port configuration page, the installer displays the default port numbers assigned to the domain and node. You can modify the port numbers or specify a different range of port numbers for the application service processes. If you do not select the display the port configuration page, the installer does not display the default port numbers and you cannot modify the assigned port numbers.
  39. Select the checkbox to create the Model Repository Service and Data Integration Service during the installation.
    If you do not configure the services, the installer does not create a Model Repository Service or a Data Integration Service in the new domain. You can create the services in the Administrator tool after installation.
    If you select to configure the services, the installer creates a Model Repository Service and a Data Integration Service in the new domain. You must specify the database for the Model repository and configure the connection to the Data Integration Service. By default, the installer starts the services when the installation completes.
  40. Choose whether to create a monitoring Model Repository Service to monitor domain statistics during installation.
  41. Choose whether to create a Content Management Service for data domain discovery during installation.
  42. Choose whether to configure the profiling warehouse connection during installation.
  43. Choose whether to create a PowerCenter Repository Service and a PowerCenter Integration Service during the installation.
  44. Click
    Next
    .
    If you selected to display the port configuration page, the
    Port Configuration
    page appears.
    This image describes about the port configuration information.
    If you do not select to display the port configuration page, the installer displays the
    Windows Service Configuration
    page. Skip to step 46.
  45. On the
    Port Configuration
    page, enter the port numbers to use for the domain service manager and service processes that will run on the node.
    Verify that the port numbers you enter are not used by other applications.
    The following table describes the ports that you can set:
    Port
    Description
    Service Manager port
    Port number used by the Service Manager on the node. The Service Manager listens for incoming connection requests on this port. Client applications use this port to communicate with the services in the domain. The Informatica command line programs use this port to communicate to the domain. This is also the port for the SQL data service JDBC/ODBC driver. Default is 6006.
    Service Manager Shutdown port
    Port number that controls server shutdown for the domain Service Manager. The Service Manager listens for shutdown commands on this port. Default is 6007.
    Informatica Administrator port
    Port number used by Informatica Administrator. Default is 6008.
    Informatica Administrator HTTPS port
    No default port. Enter the required port number when you create the service. Setting this port to 0 disables an HTTPS connection to the Administrator tool.
    Informatica Administrator shutdown port
    Port number that controls server shutdown for Informatica Administrator. Informatica Administrator listens for shutdown commands on this port. Default is 6009.
    Minimum port number
    Lowest port number in the range of dynamic port numbers that can be assigned to the application service processes that run on this node. Default is 6014.
    Maximum port number
    Highest port number in the range of dynamic port numbers that can be assigned to the application service processes that run on this node. Default is 6114.
  46. Click
    Next
    .
    The
    Windows Service Configuration
    page appears.
    This image describes about the windows service configuration information.
  47. On the
    Windows Service Configuration
    page, select whether to run the Windows service under a different user account.
    The installer creates a service to start Informatica. By default, the service runs under the same user account as the account used for installation. You can run the Windows service under a different user account.
    The following table describes the properties that you set to run Informatica under a different account:
    Property
    Description
    Run Informatica under a different user account
    Indicates whether to run the Windows service under a different user account.
    User name
    User account with which to run the Informatica Windows service.
    Use the following format:
    <domain name>\<user account>
    This user account must have the Act as operating system permission.
    Password
    Password for the user account with which to run the Informatica Windows service.
  48. Click
    Next
    .
    If you do not choose to create the services, the installer displays the
    Post-Installation Summary
    page. The
    Post-Installation Summary
    page indicates whether the installation completed successfully. Skip to step 81.
    If you select to configure the Informatica application services, the installer displays the
    Model Repository Service Database
    page appears.
    The image describes about configuring the Model Repository database.
  49. On the
    Model Repository Service Database
    page, enter the database and user account information for the Model repository.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the repository. Select one of the following databases:
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    • PostgreSQL
    Database user ID
    User account for the repository database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
    If you enable secure communication for the domain, you can create the Model repository in a database secured with the SSL protocol. To create a secure Model repository, skip to step 51.
  50. Enter the database connection information.
    If you do not create a secure Model repository, you can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      The following table describes the JDBC URL properties that you specify:
      Property
      Description
      Database address
      Host name and port number for the database in the format
      host_name:port
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      • PostgreSQL: Enter the database name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.
    • To enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
      IBM DB2
      jdbc:Informatica:db2://<host name>:<port number>;DatabaseName=
      Oracle
      jdbc:Informatica:oracle://<host name>:<port number>;ServiceName=
      Use the following connection string to connect to the Oracle database through the Oracle Connection Manager:
      jdbc:Informatica:oracle:TNSNamesFile=<fully qualified path to the tnsnames.ora file>;TNSServerName=<TNS name>;
      Microsoft SQL Server
      jdbc:Informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=
      PostgreSQL
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=
      Verify that the connection string contains all the connection parameters required by your database system.
  51. Choose whether to create a secure Model repository.
    If you create the repository on a secure database, you must provide the truststore information for the database. You must also provide a JDBC connection string that includes the security parameters for the database.
    The following table describes the properties you must set for a secure database:
    Property
    Description
    Database truststore file
    Path and file name of the truststore file for the secure database.
    Database truststore password
    Password for the truststore file.
    Custom JDBC Connection String
    JDBC connection string to connect to the secure database, including the host name and port number and the security parameters for the database.
    For information about the security parameters you must include in the JDBC connection for a secure database, see Connection String to a Secure Database.
  52. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  53. Click
    Next
    .
    The Data Integration Service page appears.
  54. On the
    Data Integration Service
    page, configure the Data Integration Service properties.
    The following table describes services parameters that you must set:
    Port
    Description
    Data Integration Service name
    Name of the Data Integration Service to create in the Informatica domain.
    HTTP protocol type
    Type of connection to the Data Integration Service. Select one of the following options:
    • HTTP. Requests to the service uses an HTTP connection.
    • HTTPS. Requests to the service uses a secure HTTP connection.
    • HTTP&HTTPS. Requests to the service can use either an HTTP or HTTPS connection.
    HTTP port
    Port number to used for the Data Integration Service. Default is 6030.
  55. If you select an HTTPS connection, specify whether to use the default Informatica SSL certificates or to use your SSL certificates to secure the connection to the Data Integration Service.
    The following table describes the SSL certificate options for securing the Data Integration Service:
    Option
    Description
    Use the default Informatica SSL certificate files
    Use the default SSL certificates provided by Informatica.
    If you do not provide an SSL certificate, Informatica uses the same default private key for all Informatica installations. If you use the default Informatica keystore and truststore files, the security of your domain could be compromised. To ensure a high level of security for the domain, select the option to specify the location of the SSL certificate files.
    Enter the location of the SSL certificate files
    Use SSL certificates that you provide. You must specify the location of the keystore and truststore files.
    If you provide the certificate, specify the location and passwords of the keystore and truststore files.
    The following table describes the parameters that you must enter for the SSL certificate files:
    Property
    Description
    Keystore file
    Required. Path and file name of the keystore file that contains the private keys and SSL certificates for the database.
    Keystore password
    Required. Password for the keystore file for the secure database.
    Truststore file
    Required. Path and file name of the truststore file that contains the public key for the database.
    Truststore password
    Required. Password for the truststore file for the secure database.
  56. Click
    Next
    .
    The installer creates the Model Repository Service and Data Integration Service and starts the services.
  57. If you chose to create a monitoring Model Repository Service to monitor domain statistics, the
    Model Repository Database for monitoring
    page appears.
  58. On the
    Model Repository Database for monitoring
    page, enter the database and user account information for the monitoring Model repository.
    Property
    Description
    Database type
    Database for the repository. Select one of the following databases:
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    • PostgreSQL
    Database user ID
    User account for the repository database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
  59. Enter the database connection information.
    You can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      The following table describes the JDBC URL properties that you specify:
      Property
      Description
      Database address
      Host name and port number for the database in the format
      <host name>:<port number>
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      • PostgreSQL: Enter the database name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.
    • To enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
  60. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  61. Click
    Next
    .
  62. If you chose to create a Content Management Service during the installation, the
    Content Management Service
    page appears.
  63. Enter the Content Management Service parameters.
    The following table describes the service parameters that you must set:
    Port
    Description
    Content Management Service name
    Name of the Content Management Service to create in the Informatica domain.
    HTTP Protocol
    Type of connection to the Content Management Service. Select one of the following options:
    • HTTP. Requests to the service uses an HTTP connection.
    • HTTPS. Requests to the service uses a secure HTTP connection.
    • HTTP&HTTPS. Requests to the service can use either an HTTP or HTTPS connection.
    HTTP Port
    Port number to use for the Content Management Service.
  64. If you select an HTTPS connection, specify whether to use the default Informatica SSL certificates or to use your SSL certificates to secure the connection to the Content Management Service.
    The following table describes the SSL certificate options for securing the Content Management Service:
    Option
    Description
    Use the default Informatica SSL certificate files
    Use the default SSL certificates provided by Informatica.
    If you do not provide an SSL certificate, Informatica uses the same default private key for all Informatica installations. If you use the default Informatica keystore files, the security of your domain could be compromised. To ensure a high level of security for the domain, select the option to specify the location of the SSL certificate files.
    Enter the location of the SSL certificate files
    Use the SSL certificates that you provide. You must specify the location of the keystore files.
    If you provide the certificate, specify the location and passwords of the keystore files.
    The following table describes the parameters that you must enter for the SSL certificate files:
    Property
    Description
    Keystore file
    Required. Path and file name for the keystore file that contains the private keys and SSL certificates for the database.
    Keystore password
    Required. Password for the keystore file for the secure database.
  65. Click
    Next
    .
  66. On the
    Content Management Service
    page, enter the database and user account information for the reference data warehouse database.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the reference data warehouse. Select one of the following databases.
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    Database user ID
    User account for the reference data warehouse database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
  67. Enter the database connection information.
    You can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      Property
      Description
      Database address
      Host name and port number for the database in the format
      <host name>:<port number>
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.
    • To enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
  68. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  69. Click
    Next
    .
  70. If you selected the Profiling Warehouse Connection during the installation, the
    Profiling Warehouse Connection
    page appears.
  71. On the
    Profiling Warehouse Connection
    page, enter the database and user account information for the profiling warehouse.
    The following table describes the properties that you specify for the database and user account:
    Property
    Description
    Database type
    Database for the profiling warehouse. Select one of the following databases.
    • Oracle
    • IBM DB2
    • Microsoft SQL Server
    Database user ID
    User account for the profiling warehouse database.
    User password
    Password for the database user account.
    If you select IBM DB2, specify the tablespace for the repository tables:
    Property
    Description
    Tablespace
    Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
    In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
    In a multipartition database, select this option and specify the name of the tablespace that resides in the catalog partition of the database.
    If you select Microsoft SQL Server or PostgreSQL, specify the schema for the repository tables and database connection:
    Property
    Description
    Schema name
    Name of the schema that will contain the repository tables. If not selected, the installer creates the tables in the default schema.
    Trusted connection
    Indicates whether to connect to Microsoft SQL Server through a trusted connection. Trusted authentication uses the security credentials of the current user to make the connection to Microsoft SQL Server. If not selected, the installer uses Microsoft SQL Server authentication.
  72. Enter the database connection information.
    You can specify the connection properties for the JDBC URL or provide the JDBC connection string.
    • To enter the connection information using the JDBC URL, select
      JDBC URL
      and specify the database connection properties.
      Property
      Description
      Database address
      Host name and port number for the database in the format
      <host name>:<port number>
      .
      Database service name
      Service or database name:
      • Oracle: Enter the service name.
      • Microsoft SQL Server: Enter the database name.
      • IBM DB2: Enter the service name.
      JDBC parameters
      Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the database. Verify that the parameter string is valid. The installer does not validate the parameter string before it adds the string to the JDBC URL. If not selected, the installer creates the JDBC URL string without additional parameters.
    • To enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
  73. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  74. Click
    Next
    .
  75. If you selected to create a PowerCenter Repository Service and a PowerCenter Integration Service during the installation, the
    PowerCenter Repository Service and PowerCenter Integration Service
    page appears.
  76. Select the database to configure for the PowerCenter repository.
    The following table lists the databases you can configure for the PowerCenter repository:
    Prompt
    Description
    Database type
    Type of database for the PowerCenter repository. Select from the following options:
    1 - Oracle
    2 - Microsoft SQL Server
    3 - PostgreSQL
  77. Enter the properties for the database user account.
    The following table lists the properties for the database user account:
    Property
    Description
    Database user ID
    Name for the PowerCenter repository database user account.
    User password
    Password for the PowerCenter database user account.
    Database service name
    Service or database name for PowerCenter:
    • Oracle: Enter the service name.
    • Microsoft SQL Server: Enter the database name.
    • PostgreSQL: Enter the database name.
    Database host name
    Enter the PowerCenter repository database.
  78. Enter the name of the PowerCenter Repository Service to create.
  79. Enter the name of the PowerCenter Integration Service to create.
  80. Click
    Next
    .
  81. Click
    Done
    to close the installer.
    The installer creates the PowerCenter Repository Service and PowerCenter Integration Service and starts the services.
    The
    Post-Installation Summary
    page indicates whether the installation completed successfully. The summary also shows the status of the installed components and their configuration.
You can view the files to get more information about the tasks performed by the installer and to view configuration properties for the installed components.

0 COMMENTS

We’d like to hear from you!