Oracle

Connect to an Oracle database

Setup

The following credentials keys are accepted:

• host (required) -> The hostname / ip of the instance

• user (required) -> The username to access the instance

• password (required) -> The password to access the instance

• schema (optional) -> This is the default schema

• sid (optional) -> The Oracle System ID / Service Name of the instance

• tns (optional) -> The Oracle TNS string of the instance

• port (optional) -> The port of the instance. Default is 1521.

Here is an example of setting a connection named ORACLE:

# URL format
export ORACLE="oracle://myuser:[e-mail]:1521/<sid>"

# YAML format
export ORACLE="{type: oracle, host: <host>, user: <user>, sid: <sid>, password: <password>, port:<port>, schema: <schema>}"