Oracle

The Oracle components allow you to natively connect to enterprise-grade Oracle Relational Database Management Systems (RDBMS) directly within your Robility Flow workflows. Use these components to execute complex SQL queries, run stored procedures, manage transactional records, extract structural metadata, and ingest structured data at scale.

Oracle Database support in Robility Flow simplifies database operations by allowing workflows to interact directly with structured enterprise tables without requiring external scripts or custom integration code.

Key Capabilities

a. Native Connectivity: Direct communication with on-premises or cloud-hosted Oracle Database instances.
b. Full Query Support: Execute standard SQL operations including SELECT, INSERT, UPDATE, and DELETE.
c. Procedural Execution: Call PL/SQL functions and stored procedures with input and output bindings.
d. Transactional Reliability: Ensure data consistency across automated workflow steps with robust error handling.

Prerequisites

a. Connection Details: Oracle host, port, service name or SID, username, and password.
b. Network Access: Connectivity to the Oracle database must be available (commonly via port 1521).

Oracle Components

1. Oracle Query Runner: Execute SQL statements directly against your Oracle database to read and manipulate live data within a workflow.

a. Supports: SELECT, INSERT, UPDATE, DELETE, and compatible DDL operations.
b. Returns results as: Data, JSON, DataFrame, or Message.
c. Use Case: Fetching rows, inserting entries, updating values, or deleting data.

2. Oracle Schema to DataTable: Extracts structural metadata from your Oracle database without touching the underlying row data.

a. Retrieves: Table names, column definitions, data types, and constraints.
b. Returns results as: DataTable or DataFrame.
c. Use Case: Inspecting the shape of your database before building pipelines, transforming data, or debugging workflows.