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: Managing Distribution Packages
  10. Appendix C: Connecting to Databases from UNIX or Linux
  11. Appendix D: Connecting to Databases from Windows
  12. Appendix E: Updating the DynamicSections Parameter of a DB2 Database

Installation for PowerCenter and Data Quality

Installation for PowerCenter and Data Quality

Run the Pre-Installation (i10Pi) System Check Tool in Console Mode

Run the Pre-Installation (i10Pi) System Check Tool in Console Mode

Run the Pre-installation (i10Pi) System Check Tool to verify whether the machine meets the system requirements for installation or upgrade.
Ensure that you verified the system requirements and prepared the domain configuration repository database.
  1. Log in to the machine with a system user account.
  2. Close all other applications.
  3. On a shell command line, run the install file.
    The installer displays the message to verify that the locale environment variables are set.
  4. If the environment variables are not set, press
    n
    to exit the installer and set them as required.
    If the environment variables are set, press
    y
    to continue.
  5. Press
    1
    to install or upgrade Informatica.
  6. Press
    1
    to run the Pre-Installation (i10Pi) System Check Tool that verifies whether the machine meets the system requirements for the installation or upgrade.
  7. From the Informatica Pre-Installation (i10Pi) System Check Tool
    Welcome
    section, press
    Enter
    .
    The
    System Information
    section appears.
  8. Type the absolute path for the installation directory.
    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.
  9. Press
    Enter
    .
  10. Enter the starting port number for the node that you will create or upgrade on the machine. The default port number for the node is 6005.
  11. Press
    Enter
    .
    The
    Database and Connection Information
    section appears.
  12. To enter the JDBC connection information using a custom JDBC connection string, press
    1
    . To enter the JDBC connection information using the JDBC URL information, press
    2
    .
    To connect to a secure database, you must enter the JDBC connection using a custom JDBC connection string.
  13. Enter the JDBC connection information.
    • To enter the connection information using a custom JDBC connection string, type the connection string and specify the connection parameters.
      Use the following syntax in the JDBC 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=
      Microsoft SQL Server with Windows NT credentials
      If you specified the Windows NT credentials for the Model repository database on Microsoft SQL Server, specify the connection string syntax to include the authentication method as NTLM.
      Microsoft SQL Server that uses the default instance with Windows NT credentials:
      "jdbc:informatica:sqlserver://<host name>:<port number>;DatabaseName=<database name>;SnapshotSerializable=true;authenticationMethod=NTLM"
      Microsoft SQL Server that uses a named instance with Windows NT credentials:
      "jdbc:informatica:sqlserver://<host name>\<named instance name>;DatabaseName=<database name>;SnapshotSerializable=true;authenticationMethod=NTLM"
      Microsoft Azure SQL
      jdbc:Informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=<database name>;SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.database.windows.net;ValidateServerCertificate=false
      Azure SQL Database with Active Directory authentication
      jdbc:informatica: sqlserver://<host_name>:<port_number>;database=<database_name>;encrypt=true;AuthenticationMethod=ActiveDirectoryPassword;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=<seconds>
      PostgreSQL
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=
      Azure PostgreSQL
      jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=<database name>;EncryptionMethod=SSL;ValidateServerCertificate=true;CryptoProtocolVersion=TLSv1.2;
      Sybase
      jdbc:Informatica:sybase://<host name>:<port number>;DatabaseName=
      Verify that the connection string contains all the connection parameters required by your database system.
    • To enter the connection information using the JDBC URL information, specify the JDBC URL properties.
      The following table describes the connection information:
      Prompt
      Description
      Database type
      Type of database for the domain configuration repository. Select from the following database types:
      • 1 - Oracle
      • 2 - Microsoft SQL Server
      • 3 - IBM DB2
      • 4 - Sybase ASE
      • 5 - PostgreSQL
      Database user ID
      User ID for the database user account for the domain configuration repository.
      Database user password
      Password for the database user account.
      Database host name
      Host name for the database server.
      Database port number
      Port number for the database.
      Database service name
      Service name for Oracle and IBM DB2 databases, or database name for PostgreSQL, Microsoft SQL Server, and Sybase ASE.
    • To connect to a secure database, select
      1
      to use a custom string and type the connection string.
      You must include the security parameters in addition to the connection parameters. For information about the security parameters you must include in the JDBC connection for a secure database, see Connection String to a Secure Database.
    The tool checks the settings of the hard drive, the availability of the ports, and the configuration of the database. After the system check is complete, the
    System Check Summary
    section displays the results of the system check.
  14. Analyze the results of the system check.
    Each requirement is listed, along with one of the following check statuses:
    • [Pass] - The requirement meets the criteria for the Informatica installation or upgrade.
    • [Fail] - The requirement doesn't meet the criteria for the Informatica installation or upgrade. Resolve the issue before you proceed with the installation or upgrade.
    • [Information] - Verify the information and perform any additional tasks as outlined in the details.
    The results of the system check are saved to the following file:
    ...<Informatica installation directory>/Server/I10PI/I10PI/en/I10PI_summary.txt
  15. Press
    Enter
    to close the Pre-Installation (i10Pi) System Check Tool.
    You can continue to the Informatica service installation or upgrade immediately or end the system check and continue with the installation or upgrade later. If you continue to the installation or upgrade immediately, you do not have to restart the installer.
  16. To continue to the Informatica service installation or upgrade immediately, press
    y
    .
    To end the system check and continue with the installation or upgrade later, press
    n
    .
If the Pre-Installation (i10Pi) System Check Tool finishes with failed requirements, resolve the failed requirements and run the Pre-Installation (i10Pi) System Check Tool again.
If the Informatica Pre-Installation (i10Pi) System Check Tool check finishes with failed requirements, you can still perform the Informatica installation or upgrade. However, Informatica highly recommends that you resolve the failed requirements before you proceed.

0 COMMENTS

We’d like to hear from you!