Purpose

Local Oracle Database 12.1 or later; an Oracle client is not required.

Connection fields

FieldRule and default valueExplanation
Server (name or IP address)
host		RequiredSet the value according to your service configuration.
Port
port		As configured
Default: 1521
Range: 1–65535		Set the value according to your service configuration.
Service name
service_name		RequiredSet the value according to your service configuration.
User
username		RequiredSet the value according to your service configuration.
Protocol
protocol		As configured
Default: tcp		tcp — TCP
tcps — TCPS (TLS)
Password
secret		Separate protected fieldThe secret is not displayed after saving. An empty field in an existing connection preserves its current secret.

Setup and validation

  1. Create a connection and give it a clear name.
  2. Complete required fields and the separate secret field.
  3. Run “Test” and read the diagnostics.
  4. Save the connection and select it in the appropriate flow block.

A successful test does not replace checking access to the required object and specific write mode.

Use in a flow

Server and account settings are stored in the connection. The specific object, fields and flow behavior are defined in the block. Go to data-handling rules →