Skip to main content

Write to Oracle

This guide shows you how to create an Oracle Write Component.

Prerequisites​

  • Oracle Connection with write permissions
  • An Ascend Flow with a Component that contains data

Create a new Write Component​

From your workspace Super Graph view, follow these steps to create your Write Component:

  1. Double-click the Flow where you want to create your Component
  2. Right-click on any Component
  3. Hover over Create Downstream -> Write, and select your target Connection menu
  4. Complete the form with these details:
    • Select your Flow
    • Enter a descriptive Component Name like write_mysql form

Configure your Oracle Write Component

Follow these steps to configure your Oracle Write Component:

  1. Set up your Connection
    • Enter your Oracle Connection name in the connection field
  2. Define your data source
    • Set input to the Component that contains your source data
  3. Configure the write destination
    • Set up the oracle write connector options
    • Specify your target table name, schema, and other required properties
  4. Choose a write strategy

    Select the strategy that best fits your use case:

    StrategyDescriptionBest for
    full (default)Replaces the entire target table during each Flow RunReference tables, complete data refreshes
    partitionedUpdates only the partitions that have changedTime-series data, regional datasets, date-partitioned tables
    snapshotCreates flexible output as a single file or multiple chunksData exports, analytical datasets, flexible output formats

For detailed guidance on when to use each strategy, see the write strategies guide.

Example​

write_oracle.yaml
component:
write:
connection: write_oracle
input:
name: my_component
flow: my_flow
strategy:
full:
mode: drop_and_recreate
oracle:
table:
name: my_output_table

This configuration:

  • References an Oracle Connection named write_oracle
  • Uses my_component from my_flow as the input data
  • Applies a full write strategy with drop_and_recreate mode
  • Writes to an Oracle table named my_output_table

🎉 Congratulations! You successfully created an Oracle Write Component in Ascend.