Oracle

Prerequisites

• If your Oracle database is protected by security groups or other firewall settings, you will need to have the data syncing service's static IP available to complete Step 1.

Step 1: Allow access

Create a rule in a security group or firewall settings to whitelist:

• incoming connections to your host and port (usually 1521) from the static IP.
• outgoing connections from ports 1024 to 65535 to the static IP.

Step 2: Create writer user

Create a database user to perform the writing of the source data.

1. Open a connection to your Oracle database.
2. Create a user for the data transfer by executing the following SQL command.

CREATE USER <username> IDENTIFIED BY '<some-password>';
GRANT CREATE SESSION TO <username>;

3. Grant user required privileges on the database.

GRANT CREATE SESSION TO <username>;
GRANT ALTER USER TO <username>;
GRANT CREATE ANY TABLE TO <username>;
GRANT CREATE ANY INDEX TO <username>;
GRANT SELECT ANY TABLE TO <username>;
GRANT INSERT ANY TABLE TO <username>;
GRANT UPDATE ANY TABLE TO <username>;
GRANT DELETE ANY TABLE TO <username>;
GRANT DROP ANY TABLE TO <username>;
GRANT COMMENT ANY TABLE TO <username>;

🚧

If theschema/database already exists

By default, the service creates a new schema ( in Oracle,schema is synonomous withuser). If you prefer to create the schema yourself before connecting the destination, you must ensure that the writer user has the proper permissions on the schema.`

Step 3: Add your destination

Securely share your host name, database name, port, your chosen schema name, username, and password with us to complete the connection.