Skip to main content

Oracle table

Overview

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).

info

Before you set up your data sync destination, make sure to configure your Source.

tip

The Oracle Table destination supports batch and real-time syncs.

Destination tab

The following table outlines the mandatory and optional parameters you will find on the Destination tab (Image 1).

The following parameters will help to define your data sync destination and how it functions.

ParameterDescriptionExample
DestinationMandatory. Select your destination from the drop down menu.Oracle Table
Connection StringMandatory. The encrypted Connection String used to connect to your Oracle instance. The Connections UI will automatically encrypt this value for you.You can find an example Connection String here.
TableMandatory. The name of the Oracle table that you want to sync your data to, including the schemadbo.employees
ID ColumnThe name of the identity column that exists in the destination (or a single column that's guaranteed to be unique and automatically populated for every new record)
ID Column Data TypeThe data type of the above ID Column.
Test ConnectionYou can use the "Test Connection" button to ensure that your credentials are properly configured to access your destination. If configured correctly, a "Connection Successful" pop-up will appear. If configured incorrectly, a "Connection Failed" pop-up will appear along with a link to the applicable error logs to help you troubleshoot.

Image 2: Define your Destination

Next steps