Oracle Data Transforms

oci Workeroci-data-transforms

Code-free ELT tool that pushes data loads, data flows and workflows down to the target database.

Provider: oci
Kind: Worker
Category: Compute
Official docs: https://docs.oracle.com/en/database/data-integration/data-transforms/using/introduction-oracle-data-transforms.html

Properties · 2 set by this component

property	type	values	required	kind default	this component
accelerator	enum	none \| gpu \| asic	no	none	inherited
concurrency	integer	—	no	—	inherited
deployment · component property	enum	autonomous-database-embedded \| marketplace-instance \| goldengate \| compute-cloud-at-customer	no	autonomous-database-embedded	inherited
fanoutStrategy · advanced	enum	none \| push \| pull \| hybrid	no	none	inherited
fanoutThreshold · advanced	integer	—	no	—	inherited
idempotent	boolean	—	no	false	inherited
instances	integer	—	no	—	inherited
managed	boolean	—	no	false	▸ true
pushdown · component property	boolean	—	no	true	inherited
rateControl · advanced	enum	none \| fixed \| aimd	no	none	inherited
repositoryOnAutonomousDatabase · component property	boolean	—	no	true	inherited
schedule	string	—	no	—	inherited
trigger	enum	queue \| stream \| schedule \| batch \| manual	yes	—	▸ 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 fan-out without a celebrity thresholdwarning

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 queueswarning

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 redundancyerror

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-transforms", component: "oci-data-transforms" }

Other Worker products · 82

SchedulerXalibaba-schedulerxalibabacloudworker Amazon AppFlowaws-appflowawsworker AWS B2B Data Interchangeaws-b2b-data-interchangeawsworker AWS Batchaws-batchawsworker AWS Glue DataBrewaws-databrewawsworker AWS DataSyncaws-datasyncawsworker AWS Deadline Cloudaws-deadline-cloudawsworker AWS Entity Resolutionaws-entity-resolutionawsworker Amazon EventBridge Scheduleraws-eventbridge-schedulerawsworker AWS Fault Injection Serviceaws-fisawsworker AWS Glue crawleraws-glue-crawlerawsworker AWS Glue for Ray jobaws-glue-ray-jobawsworker AWS Application Migration Serviceaws-mgnawsworker Amazon MSK Connectaws-msk-connectawsworker Amazon SageMaker AI Training Jobaws-sagemaker-training-jobawsworker AWS Systems Manageraws-systems-managerawsworker AWS Thinkbox Deadline 10aws-thinkbox-deadlineawsworker AWS Glue jobglue-jobawsworker Azure Automationazure-automationazureworker Azure Batchazure-batchazureworker Azure Chaos Studioazure-chaos-studioazureworker Azure Data Factoryazure-data-factoryazureworker Azure Data Shareazure-data-shareazureworker Azure Database Migration Serviceazure-database-migration-serviceazureworker Microsoft Entra Connect Syncazure-entra-connect-syncazureworker Microsoft Graph Data Connectazure-graph-data-connectazureworker Azure Storage Moverazure-storage-moverazureworker Azure Update Managerazure-update-managerazureworker Browser Runcloudflare-browser-runcloudflareworker Cloudflare Snippetscloudflare-snippetscloudflareworker Cloudflare Zarazcloudflare-zarazcloudflareworker Airbyteairbyteworker Airflow DAGairflow-dagworker Chaos Meshchaos-meshworker Chunkrchunkrworker Container workercontainer-workerworker Cron jobcron-jobworker Daytonadaytonaworker E2Be2bworker Embulkembulkworker

and 42 more → Worker page

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# Oracle Data Transforms: the Oracle Data Integrator based, code-free ELT tool for data loads, data flows and
3# workflows ("Introduction to Oracle Data Transforms"). It generates code and pushes the transformation down
4# to the target, keeps its repository in an Autonomous Database, and ships either embedded in Autonomous
5# Database Data Tools or as the "Data Integrator: Web Edition" Marketplace instance you run yourself.
6schemaVersion: "1"
7type: "component"
8id: "oci-data-transforms"
9kind: "worker"
10provider: "oci"
11docs: "https://docs.oracle.com/en/database/data-integration/data-transforms/using/introduction-oracle-data-transforms.html"
12defaults:
13  managed: true
14  trigger: "schedule"
15properties:
16  deployment:
17    type: "enum"
18    values: ["autonomous-database-embedded", "marketplace-instance", "goldengate", "compute-cloud-at-customer"]
19    default: "autonomous-database-embedded"
20  pushdown:
21    type: "boolean"
22    default: true
23  repositoryOnAutonomousDatabase:
24    type: "boolean"
25    default: true

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