Skip to main content

MSSQL

MSSQL Plugin – Delete, Custom, Insert, Select, Update, Upsert​

Summary (SEO Meta Description):
The MSSQL Plugin in WeHub connects workflows to Microsoft SQL Server databases.
It supports actions for querying, inserting, updating, deleting, and upserting records, as well as running custom SQL queries.
This enables workflows to manage enterprise-grade relational data directly inside automation pipelines.

Overview​

The MSSQL Plugin integrates workflows with Microsoft SQL Server (MSSQL).
It allows direct execution of SQL operations such as Select, Insert, Update, Delete, and Upsert, while also supporting custom SQL queries for advanced data operations.

This plugin is ideal for workflows requiring enterprise relational data storage, transactional consistency, or reporting.

Typical Use Cases:

  • Store workflow results in MSSQL Server tables
  • Run complex queries against enterprise databases
  • Insert new data and avoid duplicates using Upsert
  • Clean up or archive records with Delete
  • Use Custom SQL for stored procedures, reports, or advanced logic

Available Actions​

  • Delete – Remove records from a table based on conditions.
  • Custom – Run any custom SQL query with dynamic inputs and outputs.
  • Insert – Add new records into a table.
  • Select – Fetch records from a table with filtering, ordering, and pagination.
  • Update – Modify existing records based on conditions.
  • Upsert – Insert or update records to avoid duplicates.

FAQ​

Q: Can I call stored procedures with the Custom action?
A: Yes. The Custom action supports executing stored procedures and advanced MSSQL queries.

Q: Does the plugin support schema mapping?
A: Yes. You can map workflow inputs and outputs to SQL queries using manual or schema-based configuration.

Q: Can I handle enterprise-scale data loads?
A: Yes. MSSQL Plugin is designed for high-volume transactions and integrates smoothly with enterprise MSSQL deployments.

Keywords: WeHub MSSQL Plugin, Microsoft SQL Server Workflow, MSSQL Custom Query, MSSQL Insert, MSSQL Select, MSSQL Update, MSSQL Delete, MSSQL Upsert