Register Oracle Node

R

Data/DataFusion/Databases

Register Oracle

Register an Oracle database table for federated queries via ODBC. Requires Oracle Instant Client with ODBC driver installed.

df_register_oracledata

Inputs12

Outputs3

Security exposure4/10

Packagedata

Ratings

Scores range from 0 to 10. Higher values mean more impact, exposure, or operational weight.

SecurityAttack surface and exposure impact.

4/10Medium

PrivacyPotential sensitivity of processed data.

5/10Medium

PerformanceRuntime or resource pressure.

2/10High

GovernancePolicy, audit, or compliance impact.

2/10High

ReliabilityOperational stability considerations.

1/10High

CostExternal or compute cost impact.

6/10Medium

Input Pins

12

Input

Execution

exec_in

Trigger execution

Session

Struct

session

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Host

String

host

Oracle server host

Default localhost

Port

Integer

port

Oracle listener port

Default 1521

Service Name

String

service_name

Oracle service name or SID

Default FREEPDB1

Username

String

username

Database username

Password

String

password

Database password

Schema

String

schema

Oracle schema (defaults to username)

Source Table

String

source_table

Name of the table in Oracle

Table Name

String

table_name

Name to register in DataFusion

ODBC Driver

String

odbc_driver

ODBC driver name (e.g., 'Oracle 21 ODBC driver')

Default Oracle 21 ODBC driver

Read Only

Boolean

readonly

Open connection in read-only mode

Default true

Output Pins

3

Done

Execution

exec_out

Table registered

Session

Struct

session_out

DataFusion session

SchemaDataFusionSessionDataFusionSessionDataFusionSession1 fields

cache_keystringrequired

Connection URL

String

connection_url

Generated connection URL (without password)

Node Info

Internal name

df_register_oracle

Category

Data/DataFusion/Databases