Connections > Oracle connection > Connect to Oracle

Connect to Oracle

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

Before you begin

Check out the Prerequisites to learn about the authentication requirements before you configure a connection.

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.
Use Secret Vault	Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. Note: If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option. For information about how to configure and use a secrets manager, see Secrets manager configuration.
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 modes

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

•Oracle Database authentication
•Kerberos authentication

Note: You can't configure LDAP authentication when you connect to Oracle databases.

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

Default is Oracle Database Authentication.

Oracle Database authentication

Oracle Database authentication uses your Oracle user name and password to connect to Oracle.

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	The schema name to select tables during object selection in a mapping. If you want to select tables from multiple schemas, leave the field blank. When left blank, all schemas you have access to are displayed and you can select tables from the available schemas.
Code Page	The code page of the database server.

Kerberos authentication

Kerberos authentication does not apply to a Data Loader task.

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.