Oracle Destination Connector
The Oracle destination connector in DataSync lets you write extracted and transformed data into an Oracle Database. This connector supports inserting data into Oracle tables for storage, reporting, and integration with downstream applications. After creating all required destination connections, create your extraction.
Create a destination connection in DataSync
- Log in to DataSync.
- From the welcome screen, select Connections.
- Next to Destination Connections, click New.
- Select Oracle.
- In the Connection Properties panel, enter the connection properties.
- (Optional) In the Additional Connection Properties panel, select Add property and enter the parameters for each property.
- Click Save.
Parameters
Connection properties
| Parameter | Description |
|---|---|
| Description | Unique name for the connection. Example: Oracle |
| Connection Type | Connection method to use for authentication:
|
| 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 |