> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle external table gem

> Read and write from Oracle

export const execution_engine_0 = "Prophecy Automate"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

This page describes how to configure Oracle Source gems, including connection setup and schema options. Note that Prophecy does not support Oracle as a target destination.

## Create an Oracle gem

To create an Oracle Source gem in your pipeline:

<Steps>
  <Step title="Add a Source gem to the pipeline">
    1. Open your pipeline in the [Studio](/data-analysis/development/studio/studio).
    2. Click on **Source/Target** in the canvas.
    3. Select **Source** from the dropdown.
    4. Click on the gem to open the configuration.
  </Step>

  <Step title="Select Oracle format">
    In the **Type** tab, select **Oracle**. Then, click **Next**.
  </Step>

  <Step title="Set location details">
    In the **Location** tab, set your connection details and table location. To learn more, jump to [Source location](#source-location).
  </Step>

  <Step title="Set table properties">
    In the **Properties** tab, set the table properties. To learn more, jump to [Source
    properties](#source-properties).
  </Step>

  <Step title="Preview data">
    In the **Preview** tab, load a sample of the data and verify that it looks correct.
  </Step>
</Steps>

## Source configuration

Use these settings to configure an Oracle Source gem for reading data.

### Source location

| Parameter                   | Description                                                                                                                                                                               |
| --------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Format type                 | Table format for the source. For Oracle tables, set to `oracle`.                                                                                                                          |
| Select or create connection | Select or create a new [Oracle connection](/data-analysis/environment/connections/oracle) in the Prophecy fabric you will use.                                                            |
| Read using                  | Choose table or query.<ul><li>**Table**: Provide the schema and name of the table you want to read.</li><li>**Query**: Enter a SQL query directly in the gem to select a table.</li></ul> |

### Source properties

Infer or manually configure the schema of your Source gem. Optionally, add a description for your table. Additional properties are not supported at this time.