Skip to main content
This gem runs in .

​
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:
1

Add a Source gem to the pipeline

  1. Open your pipeline in the Studio.
  2. Click on Source/Target in the canvas.
  3. Select Source from the dropdown.
  4. Click on the gem to open the configuration.
2

Select Oracle format

In the Type tab, select Oracle. Then, click Next.
3

Set location details

In the Location tab, set your connection details and table location. To learn more, jump to Source location.
4

Set table properties

In the Properties tab, set the table properties. To learn more, jump to Source properties.
5

Preview data

In the Preview tab, load a sample of the data and verify that it looks correct.

​
Source configuration

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

​
Source location

ParameterDescription
Format typeTable format for the source. For Oracle tables, set to oracle.
Select or create connectionSelect or create a new Oracle connection in the Prophecy fabric you will use.
Read usingChoose table or query.
  • Table: Provide the schema and name of the table you want to read.
  • Query: Enter a SQL query directly in the gem to select a table.

​
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.