Settings for Oracle

This topic describes how to set up Oracle for DataSync.

  1. In DataSync, create a new source connection for Oracle.

  2. Fill out the fields in the New Connection dialog box as described below.

  3. Click Save.

Connection Properties Description
Description Enter a name for the source connection.
Connection Type

Select the connection type to use for authentication:

  • EasyConnect

  • ConnectDescriptor

Username Enter the Oracle user account used to authenticate.
Password Enter the password used to authenticate the user.
Connection Timeout

Length of time in seconds to wait for a connection to the server before terminating the attempt and generating an error.

Server Name The host name or IP of the server hosting the Oracle database.
Instance Name The database name or alias used for the connection.
Port The port used to connect to the server hosting the Oracle database.
Enable Pooling

This parameter enables connection pooling. When it is selected, the three following properties are displayed:

  • Pool idle timeout: The allowed idle time for a connection before it is closed.

  • Max pool size: The maximum number of connections in the pool.

  • Pool wait time: The maximum number of seconds to wait for an available connection.