Connections > Oracle connection > Connect to Oracle

Connect to Oracle

Let's configure the Oracle connection properties to connect to Oracle databases.

Connection details

The following table describes the Oracle connection properties:

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	Type of connection. Select Oracle from the list.
Runtime Environment	The name of the runtime environment where you want to run the tasks. Select the Informatica Cloud Hosted Agent.
Oracle Subtype	The Oracle connection subtype that you can use to connect to Oracle on-premises or Oracle Autonomous Database. Select one of the following options: - Oracle ADB. Connects to Oracle Autonomous Database. - Oracle On-premise. Connects to Oracle on-premises.

Authentication types

You can configure one of the following authentication modes to connect to Oracle databases:

•Oracle Database Authentication: Uses your Oracle user name and password to connect to Oracle.
•Kerberos: Doesn't apply to a data loader task.

Select the required authentication type and then configure the authentication-specific parameters.

Default is Oracle Database Authentication.

Oracle Database authentication

The following table describes the basic connection properties for Oracle Database authentication:

Property	Description
User Name	User name for the database login. The user name can't contain a semicolon.
Password	Password for the database login. The password can't contain a semicolon.
Host	Name of the machine that hosts the database server.
Port	Network port number used to connect to the database server. Default is 1521.
Service Name	Service name that uniquely identifies the Oracle database.
Schema	Schema used for the Oracle connection.
Code Page	The code page of the database server.

Kerberos authentication

The following table describes the basic connection properties for Kerberos authentication:

Property	Description
Host	Name of the machine that hosts the database server.
Port	Network port number used to connect to the database server. Default is 1521.
Service Name	Service name that uniquely identifies the Oracle database.
Schema	Schema used for the Oracle connection.
Code Page	The code page of the database server.

Advanced settings

The following table describes the advanced connection property for Oracle Database authentication:

Property	Description
Encryption Method	Doesn't apply to a data loader task. This property doesn't apply if you use the Hosted Agent.
Crypto Protocol Version	Doesn't apply to a data loader task.
Validate Server Certificate	Doesn't apply to a data loader task.
Trust Store	Doesn't apply to a data loader task.
Trust Store Password	Doesn't apply to a data loader task.
Host Name in Certificate	Doesn't apply to a data loader task.
Key Store	Doesn't apply to a data loader task.
Key Store Password	Doesn't apply to a data loader task.
Key Password	Doesn't apply to a data loader task.
Connection Retry Period	Doesn't apply to a data loader task.
Metadata Advanced Connection Properties	Additional properties for the JDBC driver to fetch the metadata. Enter properties in the following format: <parameter name>=<parameter value> If you enter more than one property, separate each key-value pair with a semicolon. For example, enter the following property to configure the connection timeout when you test a connection: LoginTimeout=<value_in_seconds> Note: The default connection timeout is 270 seconds. To connect to an Oracle database enabled for advanced security, you can specify the Oracle advanced security options for the JDBC driver. For example, EncryptionTypes=AES256; EncryptionLevel=accepted;DataIntegrityLevel=accepted; DataIntegrityTypes=SHA1
Runtime Advanced Connection Properties	Additional properties for the ODBC driver to run data loader tasks. If you specify more than one property, separate each key-value pair with a semicolon. For example, charset=sjis; readtimeout=180 To connect to an Oracle database enabled for advanced security, you can specify the Oracle advanced security options for the ODBC driver. For example, EncryptionTypes=AES256;EncryptionLevel=1; DataIntegrityLevel=1;DataIntegrityTypes=SHA1; DataIntegrityTypes=SHA1

Oracle connection rules and guidelines

Consider the following rules and guidelines when you create an Oracle connection:

•An Oracle table name can have a maximum of 30 characters.
•When you run a task that contains an Oracle database in the Public schema, ensure that the schema does not contain too many objects. If the schema contains too many objects, the task times out. You can remove some objects from the Oracle database or move the objects into another database schema.
•When you run a task for an Oracle database target, ensure that the UTF-8 characters do not exceed the maximum length of the varchar or char fields. Data Integration might truncate UTF-8 characters if they exceed the maximum length of the varchar or char fields.
•If the data that you write from a flat file to Oracle contains Portugese characters, ensure that the code page for the Oracle server is not set to MS Windows Latin 1. Select the code page as ISO 8859-15 Latin 1 when you create an Oracle connection.
•Schema name is case sensitive when the name of the schema contains hyphens.