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 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.

Close all other applications.

Go to the root of the directory that contains the installation files and run install.bat as administrator.

Select

Install

Informatica 10.5.4
.

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.

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.

Click

The

System Information

page appears. The image describes about the system information.

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.

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.

Click

The

Database and JDBC Connection Information

page appears.

This image describes about configuring the database for the domain configuration repository.

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.

If you plan to use a secure database for the domain configuration repository, select the

Secure database

option.

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.

Click

Test Connection

to verify that you can connect to the database, and then click

to continue.

Click

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.

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

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.

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

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