Skip to main content

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 DB is a relational database management system. In Prophecy, you can connect to Oracle to read from and write to database tables as part of your pipelines. This page explains how to set up the connection, including required parameters, permissions, and how connections are shared within teams.

​
Prerequisites

Prophecy connects to Oracle using the database credentials you provide. These credentials are used to authenticate your session and authorize all data operations performed during pipeline execution. To use an Oracle connection effectively, your user account must have:
  • Read access to query data from tables
  • Write access to insert, update, or delete data

​
Feature support

The table below outlines whether the connection supports certain Prophecy features.
FeatureSupported
Read data with a Source gemYes
Write data with a Target gemNo
Browse data in the Environment browserYes
Index tables in the Knowledge GraphNo

​
Connection parameters

To create a connection with Oracle, enter the following parameters:
ParameterDescription
Connection nameA name to identify your connection in Prophecy
ServerHostname of the Oracle database server
PortPort used by the Oracle database (default is 1521)
UsernameUsername for connecting to the Oracle database
DatabaseOracle Service Name or SID of the target database
Password (Secret required)Password for the specified user

​
Data type mapping

When Prophecy processes data from Oracle using SQL warehouses, it converts Oracle-specific data types to formats compatible with your target warehouse. This table shows how Oracle data types are transformed for Databricks, BigQuery, and Snowflake.
OracleDatabricksBigQuerySnowflake
NUMBERdecimal(38,5)
Alias: Decimal		bignumeric(38,5)
Alias: BigNumeric		number(38,10)
Alias: Number
SMALLINT / INTEGER / NUMBER(38)bigint
Alias: Bigint		int64
Alias: Integer		number
Alias: Number
FLOATdouble
Alias: Double		float64
Alias: Float		float
Alias: Float
REAL / FLOAT(63)double
Alias: Double		float64
Alias: Float		float
Alias: Float
DOUBLE PRECISION / FLOAT(126)double
Alias: Double		float64
Alias: Float		float
Alias: Float
BINARY_FLOATdouble
Alias: Double		float64
Alias: Float		float
Alias: Float
BINARY_DOUBLEdouble
Alias: Double		float64
Alias: Float		float
Alias: Float
DECIMALdecimal(38,5)
Alias: Decimal		bignumeric(38,5)
Alias: BigNumeric		number(38,10)
Alias: Number
NUMERICdecimal(38,5)
Alias: Decimal		bignumeric(38,5)
Alias: BigNumeric		number(38,10)
Alias: Number
CHARstring
Alias: String		string
Alias: String		string
Alias: String
VARCHARstring
Alias: String		string
Alias: String		string
Alias: String
VARCHAR2string
Alias: String		string
Alias: String		string
Alias: String
NCHARstring
Alias: String		string
Alias: String		string
Alias: String
NVARCHAR2string
Alias: String		string
Alias: String		string
Alias: String
LONGstring
Alias: String		string
Alias: String		string
Alias: String
CLOBstring
Alias: String		string
Alias: String		string
Alias: String
NCLOBstring
Alias: String		string
Alias: String		string
Alias: String
BLOBbinary
Alias: Binary		bytes
Alias: Bytes		binary
Alias: Binary
DATEtimestamp
Alias: Timestamp		timestamp
Alias: Timestamp		timestamp
Alias: Timestamp
TIMESTAMPtimestamp
Alias: Timestamp		timestamp
Alias: Timestamp		timestamp
Alias: Timestamp
TIMESTAMP WITH TIME ZONEtimestamp
Alias: Timestamp		timestamp
Alias: Timestamp		timestamp
Alias: Timestamp
TIMESTAMP WITH LOCAL TIME ZONEtimestamp
Alias: Timestamp		timestamp
Alias: Timestamp		timestamp
Alias: Timestamp
INTERVAL YEAR TO MONTHstring
Alias: String		string
Alias: String		string
Alias: String
INTERVAL DAY TO SECONDstring
Alias: String		string
Alias: String		string
Alias: String
RAWbinary
Alias: Binary		bytes
Alias: Bytes		binary
Alias: Binary
LONG RAWbinary
Alias: Binary		bytes
Alias: Bytes		binary
Alias: Binary
XMLTypestring
Alias: String		string
Alias: String		string
Alias: String
BOOLEANboolean
Alias: Boolean		bool
Alias: Boolean		boolean
Alias: Boolean
URITypestring
Alias: String		string
Alias: String		string
Alias: String
DBURITypestring
Alias: String		string
Alias: String		string
Alias: String
XDBURITypestring
Alias: String		string
Alias: String		string
Alias: String
HTTPURITypestring
Alias: String		string
Alias: String		string
Alias: String
LongVarCharstring
Alias: String		string
Alias: String		string
Alias: String
LongRawbinary
Alias: Binary		bytes
Alias: Bytes		binary
Alias: Binary
For Oracle number types with explicit precision and scale, Prophecy preserves those values when mapping to Snowflake. For example, Oracle number(10,2) maps to Snowflake number(10,2).
Learn more in Supported data types.

​
Sharing connections within teams

Connections in Prophecy are stored within fabrics, which are assigned to specific teams. Once an Oracle connection is added to a fabric, all team members who have access to the fabric can use the connection in their projects. No additional authentication is required—team members automatically inherit the access and permissions of the stored connection credentials.
Be mindful of the access level granted by the stored credentials. Anyone on the team will have the same permissions—including access to sensitive data if allowed.To manage this securely, consider creating a dedicated fabric and team for high-sensitivity connections. This way, only approved users have access to those credentials.