Oracle Query Runner
The Oracle Schema to DataTable component connects to an Oracle database and retrieves schema metadata for selected tables, information such as table names, column names, data types, and constraints.
It is primarily used to build a reusable schema reference that supports validation, data mapping, documentation, and schema-driven workflow design.
Note: This component works with database structure only. It does not read, modify, or return actual table data – for that, use Oracle Query Runner.
Pre-requisites
| Requirement | Details |
|---|---|
| Database Connection | A valid Oracle database address (host, port, and service name/SID) along with login credentials (username and password). |
| Network Access | The system must be able to reach the Oracle database over the required network and port (commonly 1521). |
| Required Permissions |
The database user must have sufficient privileges to access system metadata views (e.g., table and column information) for the selected tables.
Read-only access to schema metadata is required. |
Parameters
| Parameter | Description |
|---|---|
| Connection String |
The Oracle database connection details needed to establish a connection: host, port, service name, username, and password.
Format: username/password@hostname:port/service_name |
| DataTable Name |
The name of the DataTable to be created to hold the retrieved schema information (table names, columns, data types, etc.).
Note: Saved under the DataTable section of the menu for reuse in workflows. |
| DataTable Description | A description for the created DataTable, helpful for identifying its purpose later. |
| Overwrite DataTable (Toggle) |
Disabled by default.
Enabled — Replaces the existing DataTable if one with the same name already exists. Disabled — Prevents accidental overwriting of existing data. |
Output
| Output | Description |
|---|---|
| Oracle Schema Create (Data) | Extracts schema details from the Oracle database, creates the specified DataTable, and returns the schema information as structured data output. |
| Oracle Schema DataFrame | Extracts schema details from the Oracle database and returns the schema metadata as a DataFrame for further processing within the workflow. |
When to Use This Component
Use Oracle Schema to DataTable when you need to:
a. Understand a database’s structure before designing or debugging a workflow
b. Build a reference table of columns and data types for validation or mapping logic
c. Generate structural documentation of an Oracle database
d. Feed schema metadata into downstream, schema-driven automation steps
