Oracle Query

Query an Oracle database.

Example

engine: oracle:query
connection:
  host: db.example.com:1521
  user: admin
  password: MyP4$$w0rd
  service_name: XEPDB1
query: |
  SELECT EMPLOYEE_ID, FIRST_NAME, LAST_NAME
  FROM EMPLOYEES
schema:
  type: object
  properties:
    id:
      type: integer
      source: EMPLOYEE_ID
    firstName:
      type: string
      source: FIRST_NAME
    lastName:
      type: string
      source: LAST_NAME

Properties

NameType
engineString=oracle:query
connectionObject
queryString
schemaObject

engine

Must be oracle:query.

Required
Yes

connection

The SQL connection parameters.

Required
Yes

Properties

NameType
hostString
userString
passwordString
service_nameString
sidString
instance_nameString
connection.host

The network address of the Oracle server e.g. `db.example.com:1521`.

Required
Yes
connection.user

The username to authenticate to Oracle.

Required
Yes
connection.password

The password to authenticate to Oracle. Requires `username`.

Required
Yes
connection.service_name

The service name of the Oracle database.

Required
No
connection.sid

The SID of the Oracle database.

Required
No
connection.instance_name

The name of the Oracle instance.

Required
No

query

The SQL query to retrieve the data.

Required
Yes

schema

Define the schema of the data, entering the field name returned by the SQL query into `Source`.

Required
Yes