Oracle Connection

This is a step-by-step tutorial for creating an Oracle connection.

Prerequisite

To connect to Oracle, you must whitelist our IPs.

Establishing a Connection

1. Type in the Connection Name.
2. Enter your Host name.
3. Fill in the Port (typically 1521 is the most common).
4. Input the name of your Database.
5. Select whether to connect using the System Identifier (SID) or Service Name.
   Please be aware of the following details regarding each option:

• System Identifier (SID) - Ensure that you enter the distinct name that uniquely identifies your instance or database in the Database field.
• Service Name - Ensure that you input the TNS alias name used for remote connection to your database in the Database field.

6. Enter your Username and Password.
7. Use the Test Connection function to see if your connection is up to the task. If the connection succeeded, you can now use this connection in Rivery.

SSH (Optional)

Secure Shell Protocol (SSH) is used to provide secure and encrypted access to internal databases from Rivery servers in order to retrieve data.

Configure your SSH Tunnel server in your network to use SSH Tunneling via Rivery. This server will be able to connect to your database server via the internal IP or address, and will accept SSH connections from Rivery IPs. Rivery uses a key file to connect to the SSH server.