Skip to main content

Connect

Establishes a connection to an Oracle database.

Common Properties​

  • Name - The custom name of the node.
  • Color - The custom color of the node.
  • Delay Before (sec) - Waits in seconds before executing the node.
  • Delay After (sec) - Waits in seconds after executing node.
  • Continue On Error - Automation will continue regardless of any error. The default value is false.
info

If the ContinueOnError property is true, no error is caught when the project is executed, even if a Catch node is used.

Inputs​

  • Host Name - The hostname or IP address of the Oracle database server.
  • Port - The port number on which the Oracle database is listening.
  • SID - The System Identifier (SID) of the Oracle database.
  • Service Name - The service name of the Oracle database (alternative to SID).
  • Credentials - The username and password credentials for the Oracle database.

Output​

  • Connection Id - The unique identifier for the established database connection.

How It Works​

The Connect node establishes a connection to an Oracle database by:

  1. Collecting the connection parameters (Host Name, Port, SID/Service Name, Credentials)
  2. Generating a connection string based on the provided parameters
  3. Creating an OracleConnection object with the connection string
  4. Opening the connection to the database
  5. Storing the connection in a shared connections dictionary with a unique GUID
  6. Returning the connection ID as output

Requirements​

  • Valid Oracle database server with accessible endpoint
  • Correct Host Name, Port, SID/Service Name
  • Valid database credentials with appropriate permissions
  • Oracle.ManagedDataAccess client library

Error Handling​

The node will return specific errors in the following cases:

  • Empty or invalid connection string
  • Unable to connect to the database server
  • Invalid credentials
  • Network connectivity issues

Usage Notes​

  • Either SID or Service Name must be provided, but not both
  • The connection ID must be used in subsequent database operations
  • Connections should be properly closed using the Disconnect node when no longer needed
  • The default Oracle port is 1521