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​

Begin 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 set up your Oracle Write Component:

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

    Choose one of these strategies based on your use case:

    StrategyDescriptionBest For
    partitionedUpdates only modified partitionsTime-series data, regional datasets, date-partitioned data
    fullReplaces entire target during each Flow RunReference tables, complete data refreshes
    snapshotFlexible output - single file or chunked based on pathData exports, analytical datasets, flexible output requirements

For complete details on output format options and when to use each approach, see the write output formats 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.