Oracle Source Connector

The Oracle source connector in DataSync lets you retrieve data from Oracle databases for loading or synchronizing in your data warehouse. After creating all required source connections, configure your destination source to complete the connection setup.

Create a source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select Oracle.
5. In the Connection Properties panel, enter the connection properties.
6. (Optional) In the Additional Connection Properties panel, select Add property and enter the parameters for each property.
7. In the Advanced Settings panel, configure the settings, including the Tracking Type and other values according to your requirements.
8. Click Save.

Parameters

Connection properties

Parameter	Description
Description	Unique name for the connection. Example: Oracle
Connection Type	Connection method to use for authentication: EasyConnect – Simplified host and service name connection string. ConnectDescriptor – Full Oracle connect descriptor string.
Username	Oracle database account username. Example: admin
Password	Password for the specified username.
Connection Timeout	Time, in seconds, to wait for a connection to the server before terminating the attempt and generating an error.
Descriptor Value	Full connect descriptor string used to establish the connection. Example: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))
Server Name	Hostname or IP address of the server hosting the Oracle database. Example: oracle-server.company.com
Instance Name	Database instance name or service alias used for the connection. Example: ORCL
Port	Port number used to connect to the Oracle database server. Default: 1521
Enable Pooling	Connection pooling option for performance.
Min Pool Size	Minimum number of connections maintained in the pool.
Max Pool Size	Maximum number of connections allowed in the pool.
Decr Pool Size	Number of idle connections closed when there are more connections than needed.
Incr Pool Size	Number of new connections created when all connections in the pool are in use.

Additional connection properties

Additional connection string properties not specified in the Connection Properties panel. For each property added, you can choose Visible or Encrypted. Selecting Encrypted hides the value from the interface and stores it encrypted in the back end, such as when defining passwords.

Property	Value
SelfTuning	Setting that controls Oracle's self-tuning feature for connection management. When true, Oracle automatically adjusts settings for optimal performance; when false, manual configuration is used. Example: false
StatementCacheSize	Number of SQL statements stored in the cache for reuse. Reducing this value disables statement caching. Example: 0
MetadataPooling	Setting that controls whether metadata information is cached for multiple connections in the pool. When true, metadata is shared; when false, it is retrieved per connection. Example: false

Advanced settings

Advanced settings control how the Oracle connector tracks changes, handles regional and time configuration, and processes data batches during extraction. These options allow fine‑tuning for performance and accuracy, and should be configured according to your system environment and operational requirements.

Setting	Description
Tracking Type	Method for tracking changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching the Oracle application server.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum value is 0; maximum is 3600 seconds.
Batch Size	Quantity of records processed in each batch during extraction. Larger batch sizes increase memory usage but can improve performance up to a point. The default value is 2000 and the maximum should not exceed 10000 records. Adjust according to your network speed and disk performance; in most cases the default (2000) works best.

Example