Input
Oracle Input
Reads a whole table or view from an Oracle database and turns it into rows — Thin mode, so no Oracle Client needs installing on the server.
When to use it
Use it for ERP and legacy data kept in Oracle: invoices, ledgers, master data.
In a pipeline
Oracle InputFilter RowsExport CSV
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Table | select | Yes | Select a table |
Example
Legacy ERP extract
- Table=INVOICES
| INVOICE_NO | AMOUNT |
|---|---|
| INV-1042 | 860 |
| INV-1043 | 312.5 |
Worth knowing
- The connection's Service name is the database service (host:1521/ORCLPDB1 → ORCLPDB1). Tables and views of the signed-in user are listed.
- Oracle folds plain names to capitals, so a column called order_id in your rows writes to ORDER_ID; mixed-case names are quoted exactly.
- Shares its connections with Oracle Output; the password stays in the connection, never in the node.