Installation for PowerCenter and Data Quality

10.5.5
- 10.5.6
- 10.5.5.1
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

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.

Close all other applications.

On a shell command line, run the install file.

The installer displays the message to verify that the locale environment variables are set.

If the environment variables are not set, press

to exit the installer and set them as required.

If the environment variables are set, press

to continue.

Press

to install or upgrade Informatica.

Press

to run the Pre-Installation (i10Pi) System Check Tool that verifies whether the machine meets the system requirements for the installation or upgrade.

From the Informatica Pre-Installation (i10Pi) System Check Tool

Welcome

section, press

Enter

The

System Information

section appears.

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.

Press

Enter

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.

Press

Enter

The

Database and Connection Information

section appears.

To enter the JDBC connection information using a custom JDBC connection string, press

. To enter the JDBC connection information using the JDBC URL information, press

To connect to a secure database, you must enter the JDBC connection using a custom JDBC connection string.

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

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.

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

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.

To continue to the Informatica service installation or upgrade immediately, press

To end the system check and continue with the installation or upgrade later, press

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.

Rename Saved Search

Table of Contents

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