Microsoft SQL Server

microsoft.com

Microsoft SQL Server is a trusted relational database platform used by organizations to store, manage, and analyze structured data at scale. With strong performance, security controls, and wide ecosystem support, it’s a common backbone for applications that need reliable querying, reporting, and data-driven automation. SQL Server is widely adopted across industries for its maturity, tooling, and enterprise-grade capabilities.

Connecting Microsoft SQL Server gives BOBs direct access to your business’s core structured data. BOBs can retrieve exactly what they need using SQL queries, enrich it with context from connected tools, and write results back by inserting rows or executing SQL—so downstream apps stay up to date without manual exports or copy/paste.

With event-driven updates, BOBs can react immediately when new records arrive or existing rows change. That enables “hands-on” database automation such as updating customer or order status, maintaining audit/log tables, syncing master data to other systems, and kicking off operational workflows the moment data updates—helping teams respond faster and keep reporting consistent.

Available actions and events:
- Actions: Query SQL Database; Insert Row; Execute Query; Execute SQL Query
- Events: New Or Updated Row; New Column

What can BOBs do with Microsoft SQL Server?

Perform actions

  • Execute Query
  • Execute SQL Query
  • Insert Row
  • List Table Options
  • Query SQL Database

Listen to real-time events

  • New Column
  • New Or Updated Row