Oracle Export

Export data to an Oracle database.

Example

engine: oracle:export
connection:
  host: db.example.com:1521
  user: admin
  password: MyP4$$w0rd
  service_name: XEPDB1
table: EMPLOYEES

Properties

Name		Type
engine		String=oracle:export
connection		Object
table		String
schema		Object

---

engine

Must be oracle:export.

Required

Yes

---

connection

The SQL connection parameters.

Required

No

Properties

Name		Type
host		String
user		String
password		String
service_name		String
sid		String
instance_name		String

---

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

---

table

The name of the Oracle table.

Required

Yes

---

schema

Define a schema for the data.

Required

Yes