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 Activations will use to connect |
| Password | Password Activations will use to connect |
| Number of Client Connections | Value between 1 and 8 (default is 1). This is the maximum number of concurrent connections Activations 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 Activations should connect via an SSH Tunnel. For more information, see regions-and-ip-addresses.md |
| SSH Hostname | Hostname of the Activations accessible SSH Tunnel bastion. |
| SSH Port | Port of SSH Tunnel bastion. |
| SSH Username | Username Activations will use to connect to bastion. |
🔑 Permissions
To use Oracle Database as a destination, Activations requires permission to write to the desired destination tables, as well as read metadata about the table and database structures.
-- Create Activations user the ability to sign in with a password CREATE USER CENSUS IDENTIFIED BY '<strong, unique password>'; -- Give the Activations 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 Activations -- 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 |
Contact Support if you want Activations to support more sync behaviors for Oracle Database.
Advanced Network Configuration
Activations 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.