Oracle

Schema for configuring Oracle database connection parameters

Properties

Name Type Description Required
type string Connection type
Constant Value: "oracle"
yes
host string DB host
yes
port integer DB port
Minimum: 1
Maximum: 65535
yes
driver string Driver
no
database string DB name
yes
user string DB user
yes
password string DB password
no
oracle_thick_mode boolean Enable oracle’s thick mode(requires installed Oracle Client)
Default: false
no
oracle_thick_mode_lib_dir string Path to Oracle Client libraries
no
connect_args object Additional arguments to use when connecting to the DB
no
query_args object Additional query string arguments to use when connecting to the DB
no

Example

hr:
  type: oracle
  host: localhost
  port: 5432
  database: orcl
  user: scott
  password: tiger
  oracle_thick_mode: true
  oracle_thick_mode_lib_dir: /opt/oracle/instantclient_21_8/

connect_args: object

Additional arguments to use when connecting to the DB

Additional Properties: allowed

query_args: object

Additional query string arguments to use when connecting to the DB

Additional Properties: allowed