Oracle Database Nodes
MaestroHub delivers full support for Oracle Database with native SQL and PL/SQL syntax, parameter binding, and connection tuning so you can integrate enterprise workloads seamlessly.
Configuration Quick Reference
| Field | What you choose | Details |
|---|---|---|
| Parameters | Connection, Function, Function Parameters, Timeout Override | Select the connection profile, function, configure function parameters with expression support, and optionally override timeout. |
| Settings | Description, Timeout (seconds), Retry on Timeout, Retry on Fail, On Error | Node description, maximum execution time, retry behavior on timeout or failure, and error handling strategy. All execution settings default to pipeline-level values. |
Oracle Query Node
Oracle Query Node
Execute Oracle Database queries and stored procedures with parameter binding.
Supported Function Types:
| Function Name | Purpose | Common Use Cases |
|---|---|---|
| Execute Query | Run SQL statements or PL/SQL procedure calls | Production reporting, MES integrations, transactional updates, data analytics |