Integration - SQL Connect
Type identifier:
integration:sql:connectCategory: 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
Handle | Type | Description |
|---|---|---|
| control | Triggers the connection attempt. |
| secret | (Dynamic) Full connection string. |
|
| (Dynamic) Database server hostname. |
|
| (Dynamic) Database server port. |
|
| (Dynamic) Database name. |
|
| (Dynamic) Database username. |
| secret | (Dynamic) Database password. |
Note: Available input handles depend on the selected dialect and connection mode.
Output Handles
Handle | Type | Description |
|---|---|---|
| SQL connection | The established database connection. |
| control | Triggered when connection succeeds. |
| control | Triggered when connection fails. |
Configuration Options
Dialect Selection
Dialect | Description |
|---|---|
PostgreSQL | Connect to PostgreSQL databases. |
SQL Server | Connect to Microsoft SQL Server databases. |
PostgreSQL Options
Connection via string:
Option | Type | Description |
|---|---|---|
Connection String | dynamic (secret) | Full PostgreSQL connection URI. |
Connection via credentials:
Option | Type | Default | Description |
|---|---|---|---|
Host |
| - | Database server hostname. |
Port |
|
| Database server port. |
Database |
| - | Database name. |
User |
| - | Database username. |
Password | dynamic (secret) | - | Database password. |
SSL |
| - | Use SSL connection. |
SQL Server Options
Connection via string:
Option | Type | Description |
|---|---|---|
Connection String | dynamic (secret) | Full SQL Server connection string. |
Connection via credentials:
Option | Type | Default | Description |
|---|---|---|---|
Server |
| - | Database server hostname. |
Port |
|
| Database server port. |
Database |
| - | Database name. |
User |
| - | Database username. |
Password | dynamic (secret) | - | Database password. |
Encrypt |
| - | Encrypt connection. |
Trust Server Certificate |
| - | Trust self-signed certificates. |
Behaviour
- Receives trigger to initiate connection
- Resolves all connection parameters (from literals, dynamic inputs, or secrets)
- Establishes connection to the database
- Returns connection object for use by SQL Query nodes
- Triggers
successorerrorcontrol 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