Skip to main content

Oracle

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.

Configuration tabs

When you create a new external Source gem, the gem dialog contains the following tabs.

  • Type: Select the Oracle table option.
  • Source location: Choose the connection and define the location where you will read/write tables in Oracle.
  • Properties: Infer or manually specify the schema, and optionally add properties that influence table behavior.
  • Preview: Load a preview of the dataset reflecting your configurations.

The following sections provide a detailed reference for source configuration.

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.