Microsoft SQL Server Integration
No sections found for this integration
The integration documentation may not have the expected structure
Overview
The Microsoft SQL Server node in Lamatic connects to your SQL Server database and runs SQL statements from your flows. This integration supports Action mode only and does not support Trigger or Batch Trigger modes.
Features
Key Functionalities
- Action-only execution: Run SQL queries whenever the flow reaches this node.
- Credential-based connection: Reuse saved SQL Server credentials across nodes and flows.
- Configurable SSL mode: Choose the right encryption and certificate verification level for your environment.
Benefits
- Simple database operations in flows: Query data without leaving Lamatic.
- Reusable credentials: Configure once and reference credentials in multiple action nodes.
- Flexible security posture: Pick SSL mode based on internal, staging, or production requirements.
Prerequisites
Before using the Microsoft SQL Server node, ensure the following:
- A reachable Microsoft SQL Server host.
- A database user with permission to run the SQL queries you plan to execute.
- Network/firewall settings that allow access from your Lamatic environment.
- SSL certificates available if you plan to use certificate verification modes.
If the server is protected by IP-based network rules, review IP Allowlisting before connecting.
Setup
Step 1: Configure Microsoft SQL Server credentials in Lamatic
In the Integrate Microsoft SQL Server dialog, provide the following:
| Field | Description | Required | Example |
|---|---|---|---|
| Credential Name | Name to identify this SQL Server connection | ✅ | mssql-prod |
| Host | SQL Server hostname or IP address | ✅ | sqlserver.example.com |
| Port | SQL Server port | ✅ | 1433 |
| Username | Database username | ✅ | lamatic_user |
| Password | Database user password | ✅ | — |
| Database | Database name to connect to | ✅ | appdb |
| SSL Mode | SSL connection mode (see SSL connection modes) | ✅ | require |
SSL connection modes
| Mode | Description |
|---|---|
| disable | No encryption. |
| require | Always require encryption, but do not verify the server certificate (use for self-signed certs on internal servers). |
| verify-ca | Always require encryption and verify the server certificate against an uploaded CA. |
| verify-full | The most secure mode. Require encryption, verify the CA, and verify the hostname matches the certificate. |
Configuration Reference
Action node configuration
Use the Microsoft SQL Server node as an Action with the following fields:
| Parameter | Description | Required | Example |
|---|---|---|---|
| Credential | Saved Microsoft SQL Server credential | ✅ | mssql-prod |
| Action | Operation to run | ✅ | run query |
| Query | SQL query to execute | ✅ | SELECT TOP 10 * FROM users |
How to use
- Add a Microsoft SQL Server node to your flow.
- Select your Credential.
- Set Action to run query.
- Enter your Query.
- Run the flow and inspect node output.
Output
- Rows: Query result set for
SELECTqueries. - Execution result: Status or affected-row metadata for non-SELECT queries (depends on query type).
Troubleshooting
Common issues
| Problem | Solution |
|---|---|
| Connection failed | Verify host, port, database, and network/firewall access. See IP Allowlisting. |
| Login failed for user | Recheck username/password and SQL Server user permissions. |
| SSL error | Use the correct SSL mode and ensure CA/certificate settings are valid for your environment. |
| Query execution error | Validate SQL syntax and confirm the user has required table/schema permissions. |