Oracle Table
Oracle Database is a relational database management system, commonly used for running online transaction processing, data warehousing and mixed database workloads. The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL).
The Oracle Table destination supports batch and real-time syncs.
The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).
Destination Details
Column Mapping
Filter
The following parameters will help to define your data sync destination and how it functions.
Parameter | Description | Example |
|---|---|---|
Destination | Mandatory. Select your destination from the drop down menu. | Oracle Table |
Connection String | Mandatory. The encrypted Connection String used to connect to your Oracle instance. The Connections UI will automatically encrypt this value for you. | |
Table | Mandatory. The name of the Oracle table that you want to sync your data to, including the schema | dbo.employees |
ID Column | The name of the identity column that exists in the destination (or a single column that is guaranteed to be unique and automatically populated for every new record) | |
ID Column Data Type | The data type of the above ID Column. | |
The Column Mapping section is where you define which source columns you want to sync to which destination columns. You can repeat the values for multiple columns.
Parameter | Description | Example |
|---|---|---|
Source Column | Mandatory. The name of your column as it appears in the source. | Name |
Target Column | Mandatory. The name of your column as it appears in the destination. | Name |
You have the option to add a destination filter to your data sync. Please review the documentation here for more information on destination filters.
Image 2: Define your Destination
- If you are running a batch sync, click Jobs > Start a Job to begin your sync.
Last modified 3mo ago