Oracle Database

This page describes how to sync data into your Oracle Database instance.

Getting Started

This guide will walk you through connecting to Oracle Database as a destination.

Visit the Destinations page and click + New Destination.
Select Oracle Database from the menu.
Enter the requested database credentials:

Credential	Description
Hostname	Host name or IP address of database
Port	Port of database (1521 by default for Oracle Database) If port 2484 is specified, connection will be made using TLS. Your root certificate must be from a publicly-trusted CA.
Database Name	Name of database within Oracle Database to connect to
Username	Username Census will use to connect
Password	Password Census will use to connect
Number of Client Connections	Value between 1 and 8 (default is 1). This is the maximum number of concurrent connections Census will use to connect to database. The default should be fine in most cases, but increasing this value can increase throughput on very large syncs.
Use SSH Tunnel	Default: Off - Toggle on to indicate that Census should connect via an SSH Tunnel. For more information, see Network Access Controls
SSH Hostname	Hostname of the Census accessible SSH Tunnel bastion.
SSH Port	Port of SSH Tunnel bastion.
SSH Username	Username Census will use to connect to bastion.

Credential

Description

Hostname

Host name or IP address of database

Port

Port of database (1521 by default for Oracle Database) If port 2484 is specified, connection will be made using TLS. Your root certificate must be from a publicly-trusted CA.

Database Name

Name of database within Oracle Database to connect to

Username

Username Census will use to connect

Password

Password Census will use to connect

Number of Client Connections

Value between 1 and 8 (default is 1). This is the maximum number of concurrent connections Census will use to connect to database. The default should be fine in most cases, but increasing this value can increase throughput on very large syncs.

Use SSH Tunnel

Default: Off - Toggle on to indicate that Census should connect via an SSH Tunnel. For more information, see Network Access Controls

SSH Hostname

Hostname of the Census accessible SSH Tunnel bastion.

SSH Port

Port of SSH Tunnel bastion.

SSH Username

Username Census will use to connect to bastion.

🔑 Permissions

To use Oracle Database as a destination, Census requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.

-- Create Census user the ability to sign in with a password
CREATE USER CENSUS IDENTIFIED BY '<strong, unique password>';

-- Give the Census user the ability to connect to the database and
-- sync data to it:
GRANT
    CONNECT,
    SELECT ANY TABLE,
    INSERT ANY TABLE,
    UPDATE ANY TABLE,
    DELETE ANY TABLE
TO CENSUS;

-- It may be possible to restrict the privileges granted to the Census
-- user to specific operations and database objects depending on your
-- use-case.

Supported Objects and Behaviors

Object Name

Supported?

Sync Keys

Behaviors

Table

✅

Primary keys or columns with uniqueness constraints

Update or Create, Update Only, Mirror

Advanced Network Configuration

Census can successfully connect to Oracle Database instances that are using advanced networking controls including region constraints, IP address allow lists, or SSH Tunneling. For more information, see our Network Access Controls documentation.

Need help connecting to Oracle Database?

PreviousOptimizely NextOracle Eloqua

Last updated 4 months ago