Oracle

Prophecy Automate

Use a table from Oracle as an external source.

note

Oracle target not supported.

Source parameters

Parameter	Tab	Description
Connection type	Type	Location you want to connect from.
Format type	Source location	Format of the gem. In this case, oracle.
Select or create connection	Source location	Whether to select an existing connection, or to create a new one.
Read using	Source location	Choose 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.