Integration - SQL Connect

Type identifier: integration:sql:connect Category: Integration Operations

Description

The Integration - SQL Connect node creates a connection to a SQL database that can be used by subsequent Integration - SQL Query nodes. It supports PostgreSQL and Microsoft SQL Server databases with various authentication options including connection strings and individual credential fields.

Input Handles

Note: Available input handles depend on the selected dialect and connection mode.

Output Handles

Configuration Options

Dialect Selection

PostgreSQL Options

Connection via string:

Connection via credentials:

SQL Server Options

Connection via string:

Connection via credentials:

Behaviour

1. Receives trigger to initiate connection
2. Resolves all connection parameters (from literals, dynamic inputs, or secrets)
3. Establishes connection to the database
4. Returns connection object for use by SQL Query nodes
5. Triggers success or error control flow

Connection Lifecycle

• Connections are managed within the run
• Use Integration - SQL Disconnect to explicitly close connections
• Connections are cleaned up when the run ends

Security

• Local/internal database connections are blocked by default, including when a hostname's DNS answer points to an internal address.

Examples

Connect to PostgreSQL

Configuration:

• Dialect: PostgreSQL
• Host: db.example.com
• Port: 5432
• Database: myapp
• User: app_user
• Password: (from secret)
• SSL: true

Connect to SQL Server With Connection String

Configuration:

• Dialect: SQL Server
• Connection String: (from secret containing full connection string)

Dynamic Connection

Configuration:

• Dialect: PostgreSQL
• All fields set to dynamic
• Connection details provided at runtime