import-from-oracle

Description

import-from-oracle adaptor imports data from an Oracle database and returns the results as a datatable in Data-flo.

This adaptor allows users to set up a connection to an Oracle database, set a query, and extract data from the database into a Data-flo datatable.

Inputs

connection string Type: text Required: Yes An Easy Connect string (e.g., hostname:port/service), a Connect Descriptor string, or the SID of a local Oracle Database instance.

username Type: text Required: No The username to connect to the database.

password Type: text Required: No The password to connect to the database.

query Type: text Required: Yes The SQL query reading from the database (e.g. SELECT * from table WHERE ...).

Outputs

data Type: datatable A datatable containing the imported data.

Examples

Example 1: Default behaviour.

Inputs:

connection string: localhost:1521/demoDB

username: demo_user

password: demo_password

query:

SELECT 1 AS field1, 'a' AS field2
UNION
SELECT 2 AS field1, 'b' AS field2
UNION
SELECT 3 AS field1, 'c' AS field2

Outputs:

data:

field1	field2
1	a
2	b
3	c

-> Imported data from Oracle database into Data-flo.