Oracle Destination Connector

The Oracle destination connector writes extracted and transformed data from DataSync into an Oracle database. It serves as the storage destination for your reporting and analytics. DataSync supports two connection methods: EasyConnect and ConnectDescriptor. Once your destination connection is ready, create your extraction to define what data gets loaded and how.

Create the destination connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Destination Connections, click New.
4. Select Oracle.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any advanced parameters.
7. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: Oracle.
Connection Type	Connection method for authenticating to Oracle. EasyConnect for a simplified host and service name connection string. ConnectDescriptor for a full Oracle connect descriptor string.
Username	Login account for accessing the database. Example: admin.
Password	Password for this account.
Connection Timeout	Time in seconds to wait for a connection before the attempt is cancelled.
Server Name	EasyConnect only Server name or IP address hosting the Oracle database. Example: oracle-server.company.com.
Instance Name	EasyConnect onlyDatabase instance name or service alias for the connection. Example: ORCL.
Port	EasyConnect only Port number for the Oracle database connection. Default: 1521.
Descriptor Value	ConnectDescriptor only Full connect descriptor string for the connection. Example: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=sales-server)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))).
Enable Pooling	Enables connection pooling, which keeps a set of database connections open and reuses them across extractions instead of opening a new one each time. This reduces overhead and improves performance when multiple extractions run at the same time.
Min Pool Size	Minimum number of connections kept open in the pool at all times. Default: 1.
Max Pool Size	Maximum number of connections allowed in the pool at the same time. Default: 100.
Decr Pool Size	Number of idle connections closed when the pool has more connections than needed. Default: 5.
Incr Pool Size	Number of new connections opened when all existing pool connections are in use. Default: 5.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
SelfTuning	Controls Oracle's self-tuning feature. When true, Oracle automatically adjusts connection settings for optimal performance. When false, settings are managed manually.
StatementCacheSize	Number of SQL statements cached for reuse across requests. Set to 0 to disable statement caching.
MetadataPooling	Controls whether metadata is shared across connections in the pool. When true, metadata is cached and shared. When false, it is retrieved individually per connection.