Cloud Data Integration for PowerCenter
- Cloud Data Integration for PowerCenter
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Property
| Description
|
|---|---|
Database type
| Type of database for the domain configuration repository.
Select from the following options:
Default is Oracle.
|
Database User ID
| Name for the domain configuration database user account.
|
User Password
| Password for the domain configuration database user account.
|
Property
| Description
|
|---|---|
Tablespace
| Name of the tablespace in which to create the tables. Specify a tablespace that meets the pageSize requirement of 32768 bytes.
In a single partition database, if this option is not selected, the installer creates the tables in the default tablespace.
In a multi-partition database, select this option and specify the name of the non-partitioned tablespace that resides in the catalog partition of the database.
|
Property
| Description
|
|---|---|
Database Address
| Host name and port number for the database in the format host_name:port_number.
|
Database Service Name
| Service or 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.
|
Property
| Description
|
|---|---|
Database Truststore File
| Absolute path to the truststore file for the secure database.
|
Database Truststore Password
| Password for the truststore file.
|
Custom JDBC Connection String
| JDBC connection string to connect to the secure database, including the host name and port number and the security parameters for the database.
|
Database parameter
| Description
|
|---|---|
EncryptionMethod
| Required. Indicates whether data is encrypted when transmitted over the network. Set to
SSL.
|
ValidateServerCertificate
| Optional. Indicates whether Informatica validates the certificate that the database server sends.
If this parameter is set to True, Informatica validates the certificate that the database server sends. If you specify the HostNameInCertificate parameter, Informatica also validates the host name in the certificate.
If this parameter is set to False, Informatica doesn't validate the certificate that the database server sends. Informatica ignores any truststore information that you specify
|
HostNameInCertificate
| Optional. 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 certificate.
|
cryptoProtocolVersion
| Required. Specifies the cryptographic protocol to use to connect to a secure database.
Based on the cryptographic protocol used by the database server, set to one of the following values:
|
Database
| Connection string syntax
|
|---|---|
IBM DB2
| jdbc:Informatica:db2://<host name>:<port number>;DatabaseName=<database name>;EncryptionMethod=SSL;HostNameInCertificate=<database host name>;ValidateServerCertificate=<true or false>
|
Oracle
| jdbc:Informatica:oracle://<host name>:<port number>;ServiceName=<service name>;EncryptionMethod=SSL;HostNameInCertificate=<database host name>;ValidateServerCertificate=<true or false>
|
Micrososft SQL Server
| jdbc:Informatica:sqlserver://<host name>:<port number>;SelectMethod=cursor;DatabaseName=<database name>;EncryptionMethod=SSL;HostNameInCertificate=<database host name>;ValidateServerCertificate=<true or false>
|
PostgreSQL
| jdbc:Informatica:postgresql://<host name>:<port number>;DatabaseName=<database name>;EncryptionMethod=SSL;HostNameInCertificate=<database host name>;ValidateServerCertificate=<true or false>
|
