Oracle Data Integrator on OCI

ociWorkeroci-data-integrator

ODI Studio and agent deployed from Marketplace with its repository in an Autonomous Database.

Provider
oci
Kind
Worker
Category
Compute
Properties · 1 set by this component
propertytypevaluesrequiredkind defaultthis component
acceleratorenumnone | gpu | asicnononeinherited
agentType · component propertyenumstandalone | collocated | java-eenostandaloneinherited
concurrencyinteger—no—inherited
fanoutStrategy · advancedenumnone | push | pull | hybridnononeinherited
fanoutThreshold · advancedinteger—no—inherited
idempotentboolean—nofalseinherited
instancesinteger—no—inherited
licensing · component propertyenumbring-your-own-license | license-includednobring-your-own-licenseinherited
managedboolean—nofalseinherited
rateControl · advancedenumnone | fixed | aimdnononeinherited
repository · component propertyenumautonomous-database | mysql-embeddednoautonomous-databaseinherited
schedulestring—no—inherited
triggerenumqueue | stream | schedule | batch | manualyes—▸ schedule
Rules that apply · 3

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.

push-fanout-without-celebrity-path

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
shared-worker-pool-across-queues

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
stateful-node-without-zone-redundancy

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
Use it in a design
nodes:
  - { id: "data-integrator", component: "oci-data-integrator" }
Other Worker products · 82
SchedulerXalibaba-schedulerxalibabacloudworkerAmazon AppFlowaws-appflowawsworkerAWS B2B Data Interchangeaws-b2b-data-interchangeawsworkerAWS Batchaws-batchawsworkerAWS Glue DataBrewaws-databrewawsworkerAWS DataSyncaws-datasyncawsworkerAWS Deadline Cloudaws-deadline-cloudawsworkerAWS Entity Resolutionaws-entity-resolutionawsworkerAmazon EventBridge Scheduleraws-eventbridge-schedulerawsworkerAWS Fault Injection Serviceaws-fisawsworkerAWS Glue crawleraws-glue-crawlerawsworkerAWS Glue for Ray jobaws-glue-ray-jobawsworkerAWS Application Migration Serviceaws-mgnawsworkerAmazon MSK Connectaws-msk-connectawsworkerAmazon SageMaker AI Training Jobaws-sagemaker-training-jobawsworkerAWS Systems Manageraws-systems-managerawsworkerAWS Thinkbox Deadline 10aws-thinkbox-deadlineawsworkerAWS Glue jobglue-jobawsworkerAzure Automationazure-automationazureworkerAzure Batchazure-batchazureworkerAzure Chaos Studioazure-chaos-studioazureworkerAzure Data Factoryazure-data-factoryazureworkerAzure Data Shareazure-data-shareazureworkerAzure Database Migration Serviceazure-database-migration-serviceazureworkerMicrosoft Entra Connect Syncazure-entra-connect-syncazureworkerMicrosoft Graph Data Connectazure-graph-data-connectazureworkerAzure Storage Moverazure-storage-moverazureworkerAzure Update Managerazure-update-managerazureworkerBrowser Runcloudflare-browser-runcloudflareworkerCloudflare Snippetscloudflare-snippetscloudflareworkerCloudflare Zarazcloudflare-zarazcloudflareworkerAirbyteairbyteworkerAirflow DAGairflow-dagworkerChaos Meshchaos-meshworkerChunkrchunkrworkerContainer workercontainer-workerworkerCron jobcron-jobworkerDaytonadaytonaworkerE2Be2bworkerEmbulkembulkworker
and 42 more → Worker page
Source
# 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"

The same page as markdown, for an agent: /catalogue/components/oci-data-integrator.md