oracle-database

Imports data from an Oracle Database and returns the results as a datatable.

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

Arguments

Inputs:

connectionString: An Easy Connect string (e.g. hostname:port/service), a Connect Descriptor string, or the SID of a local Oracle Database instance. If unspecified, defaults to "localhost:1521/XEPDB1".

username: The username to connect to the database.

password: The password to connect to the database. TIP: when binding, consider treating the value as secret.

query: The SQL query reading from the database (e.g. "SELECT * from table WHERE ...").

Output:

data: The datatable containing the imported data.