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 Graphical Mode

Run the Pre-Installation (i10Pi) System Check Tool in Graphical 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. Go to the root of the directory that contains the installation files and run install.bat as administrator.
  4. Select
    Install
    Informatica 10.5.4
    .
  5. Select
    Run the Pre-Installation (i10Pi) System Check Tool
    to verify whether the machine meets the system requirements for the installation or upgrade.
    This image describes about pre-installation system check tool. The pre-installation system check tool verifies if the machine meets the system requirements for the installation.
  6. Click
    Start
    .
    The Informatica Pre-Installation (i10Pi) System Check Tool
    Welcome
    page appears. The image displays the Welcome Page for i10Pi and also displays the copyright and patent information in Informatica.
  7. Click
    Next
    .
    The
    System Information
    page appears. The image describes about the system information.
  8. Enter 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. 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.
  10. Click
    Next
    .
    The
    Database and JDBC Connection Information
    page appears.
    This image describes about configuring the database for the domain configuration repository.
  11. Enter the information for the domain configuration repository database.
    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.
    The domain configuration repository must be accessible to all gateway nodes in the domain.
  12. If you plan to use a secure database for the domain configuration repository, select the
    Secure database
    option.
  13. Enter the database connection information.
    • To enter the connection information using the JDBC URL information, select
      JDBC URL
      and specify the JDBC URL 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 enter the connection information using a custom JDBC connection string, select
      Custom JDBC connection string
      and type the connection string.
      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.
    • If you select the
      Secure database
      option, select
      Custom JDBC connection 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.
  14. Click
    Test Connection
    to verify that you can connect to the database, and then click
    OK
    to continue.
  15. Click
    Next
    to start the system check.
    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
    page appears, displaying the results of the system check.
  16. 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
  17. Click
    Done
    to close the Pre-Installation (i10Pi) System Check Tool.
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!