| |
|
The database user name for the Model repository.
|
|
Repository database password for the database user.
|
| The JDBC connection string to connect to the Model repository database. Use the following syntax for each supported database:
IBM Db2.
"jdbc:informatica:db2://<host name>:<port number>;DatabaseName=<database name>;BatchPerformanceWorkaround=true;DynamicSections=3000"
Microsoft SQL Server that uses the default instance.
"jdbc:informatica:sqlserver://<host name>:<port number>;DatabaseName=<database name>;SnapshotSerializable=true"
Microsoft SQL Server that uses a named instance.
"jdbc:informatica:sqlserver://<host name>\<named instance name>;DatabaseName=<database name>;SnapshotSerializable=true"
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"
Azure SQL Server.
"jdbc:informatica:sqlserver://<host name>:<port number>;DatabaseName=<database name>;SnapshotSerializable=true; SnapshotSerializable=true;EncryptionMethod=SSL;HostNameInCertificate=*.<hostnameincertificate>;ValidateServerCertificate=true"
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>"
Oracle. "jdbc:informatica:oracle://<host name>:<port number>;SID=<database name>;MaxPooledStatements=20;CatalogOptions=0;BatchPerformanceWorkaround=true"
To connect to Oracle using Oracle Connection Manager, use the following connection string:
" jdbc:Informatica:oracle:TNSNamesFile=<fully qualified path to the tnsnames.ora file>;TNSServerName=<TNS server name>; "
PostgreSQL.
"jdbc:informatica:postgresql://<host name>:<port number>;DatabaseName= "
|
Secure JDBC Parameters
|
If the Model repository database is secured with the SSL protocol, you must enter the secure database parameters.
Enter the parameters as
name=value pairs separated by semicolon characters (;). For example:
param1=value1;param2=value2
|
|
The SQL dialect for a particular database. The dialect maps java objects to database objects.
org.hibernate.dialect.Oracle9Dialect
|
|
The Data Direct driver used to connect to the database.
com.informatica.jdbc.oracle.OracleDriver
|
Database Schema
| The schema name for a particular database.
|
Database Tablespace
| The tablespace name for a particular database. For a multi-partition IBM Db2 database, the tablespace must span a single node and a single partition.
|