Oracle Data Integrator on OCI
ODI Studio and agent deployed from Marketplace with its repository in an Autonomous Database.
| property | type | values | required | kind default | this component |
|---|---|---|---|---|---|
| accelerator | enum | none | gpu | asic | no | none | inherited |
| agentType | enum | standalone | collocated | java-ee | no | standalone | inherited |
| concurrency | integer | — | no | — | inherited |
| fanoutStrategy | enum | none | push | pull | hybrid | no | none | inherited |
| fanoutThreshold | integer | — | no | — | inherited |
| idempotent | boolean | — | no | false | inherited |
| instances | integer | — | no | — | inherited |
| licensing | enum | bring-your-own-license | license-included | no | bring-your-own-license | inherited |
| managed | boolean | — | no | false | inherited |
| rateControl | enum | none | fixed | aimd | no | none | inherited |
| repository | enum | autonomous-database | mysql-embedded | no | autonomous-database | inherited |
| schedule | string | — | no | — | inherited |
| trigger | enum | queue | stream | schedule | batch | manual | yes | — | ▸ schedule |
Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.
Pure push fan-out over a social graph is brutal at the tail: one post from an account with millions of followers becomes millions of cache writes. A follower threshold above which readers merge at read time bounds that write amplification.
- — all of these hold:
- — the node's `fanoutStrategy` is "push"
- — the node's `fanoutThreshold` has no value
- — the design contains a node of kind graph-database
One worker pool consuming several queues lets a slow or poisoned queue starve the others. That is precisely what the design's per-queue isolation requirement forbids.
- — all of these hold:
- — the node has more than 1 incoming edge from a queue
- — the design requirement `isolation.perQueue` is true
A stateful compute node pinned to exactly one availability zone disappears with that zone, and its state goes with it. Nodes inside a cell are exempt, because there the cell is deliberately single-zone and redundancy comes from the other cells.
- — all of these hold:
- — the node's `stateless` is false
- — the node sits inside exactly 1 availability-zone group
- — this does not hold:
- — the node sits inside at least one cell group
nodes:
- { id: "data-integrator", component: "oci-data-integrator" }# yaml-language-server: $schema=../../schema/component.schema.json # Oracle Data Integrator on OCI: the ODI Studio and agent stack deployed from Marketplace as a Resource # Manager stack you run on your own compute ("Getting Started with Oracle Data Integrator on Oracle Cloud # Marketplace"). Installing it with the option to create a repository in an Autonomous Database produces an # empty ODI repository and a default standalone agent, which orchestrates ELT jobs against the target. schemaVersion: "1" type: "component" id: "oci-data-integrator" kind: "worker" provider: "oci" docs: "https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.4/dimgs/getting-started-oracle-cloud-marketplace.html" defaults: trigger: "schedule" properties: agentType: type: "enum" values: ["standalone", "collocated", "java-ee"] default: "standalone" repository: type: "enum" values: ["autonomous-database", "mysql-embedded"] default: "autonomous-database" licensing: type: "enum" values: ["bring-your-own-license", "license-included"] default: "bring-your-own-license"