Installation and Configuration Guide

10.2.2
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.1
- 10.2 HotFix 2
- 10.2 HotFix 1
- 10.2

Back Next

Configure the Model Repository Service and Model Repository Database Details

Choose whether to create a Model Repository Service and a Data Integration Service to associate with the Enterprise Data Lake Service, or to associate existing application services with Enterprise Data Lake. If you create a Model Repository Service, specify the connection details for the Model repository database.

If you choose to create a Model Repository Service, specify the connection details for the Model repository database.

Choose to either create a Model Repository Service and a Data Integration Service to associate with the Enterprise Data Lake Service, or to associate existing application services with Enterprise Data Lake.

To create to create a Model Repository Service and a Data Integration Service to associate with the Enterprise Data Lake Service on the node, press

To associate an existing Model Repository Service and an existing Data Integration Service with the Enterprise Data Lake Service, press

, and then enter the name of each service.

Enter the name of the Model Repository Service.

The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [

Specify the connection details for the Model repository database.

The following table describes the parameters you set:

Property	Description
Database Type	Database for the Model repository managed by the Model Repository Service.
Database User ID	User name of the database user account to use to log in to the Model repository database.
User Password	Password for the Model repository database user account.
Tablespace	Configure for a IBM DB2 database. Name of the tablespace in which to create the tables. The tablespace must be defined on a single node, and the page size must be 32K. This option is required for a multi-partition database. If this option is not selected for a single-partition database, the installer creates the tables in the default tablespace.
Schema Name	Configure for a Microsoft SQL Server database. Name of the schema that will contain domain configuration tables. If not selected, the installer creates the tables in the default schema.

Specify the truststore details required to access a secure Model repository database.

The following table describes the properties you set:

Property	Description
Database truststore file	Path and file name of the truststore file for the secure database.
Database truststore password	Password for the truststore.

Choose whether to configure the database connection using a JDBC URL or a custom JDBC connection string.

Press

to configure the database connection using a JDBC URL.

The following table describes the properties you set:

Property	Description
Database address	Host name and port number for the database in the format <host name>:<port>.
Database service name	Service name for Oracle and IBM DB2 databases, or database name for Microsoft SQL Server.
JDBC parameters	Optional parameters to include in the database connection string. Use the parameters to optimize database operations for the Model repository. You can use the default parameters or add or modify the parameters based on your database requirements. 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 without additional parameters. The following examples show the default connection strings for each database: Oracle. jdbc:Informatica:oracle://host_name:port_no ;ServiceName= IBM DB2. jdbc:Informatica:db2://host_name:port_no ;DatabaseName= Microsoft SQL Server. jdbc:Informatica:sqlserver://host_name:port_no ;SelectMethod=cursor;DatabaseName= Azure SQL Server. jdbc:informatica:sqlserver://host_name:port_number ;DatabaseName=<database_name>;SnapshotSerializable=true; SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.<hostnameincertificate>;ValidateServerCertificate=true

Press

to configure the database connection using a custom JDBC connection string.

The following table describes the properties you set:

Property	Description
EncryptionMethod	Indicates whether data is encrypted when transmitted over the network. This parameter must be set to SSL.
ValidateServerCertificate	Indicates whether Informatica validates the certificate that is sent by the database server. If this parameter is set to True, Informatica validates the certificate that is sent by the database server. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate. If this parameter is set to false, Informatica does not validate the certificate that is sent by the database server. Informatica ignores any truststore information that you specify.
HostNameInCertificate	Host name of the machine that hosts the secure database. If you specify a host name, Informatica validates the host name included in the connection string against the host name in the SSL certificate.