SQL Server Integration Pack for System Center Orchestrator
Script-free SQL Server automation for reliable, production-ready Orchestrator runbooks.
The SQL Server Integration Pack is a set of Orchestrator activities that allow runbooks to select, insert, update and delete database rows, run stored procedures, execute SQL queries and monitor tables or views for changes. Instead of building custom scripts for every database task, runbook authors can configure activities through Orchestrator and use automatically mapped inputs, filters and published data to connect SQL Server operations into wider IT automation processes.
Typical Automation Scenarios
- Trigger incident, change or request workflows when new records appear in a service management database.
- Update asset, configuration or reporting databases as part of provisioning and deprovisioning runbooks.
- Run stored procedures to complete approved operational tasks consistently and under Orchestrator control.
- Query SQL Server data to drive conditional logic in infrastructure, application or user lifecycle automation.
- Synchronise operational data between SQL Server, Azure SQL Database and other enterprise systems connected through Orchestrator.
- Monitor tables or views for changes and automatically notify teams, create tickets or launch remediation workflows
Benefits at a Glance
- Reduce Custom Scripting
Build SQL Server automation using configurable Orchestrator activities rather than hand-coded SQL scripts - Accelerate Runbook Design
Automatically map database table columns to Orchestrator input properties, filters and published data items - Improve Reliability
Help prevent errors by controlling access to read-only fields, enforcing mandatory inputs and offering value browsers for common data types - Increase Performance
Use connection pooling to reduce the overhead of repeatedly opening and closing database connections - Enable Event-Driven Automation
Monitor database tables or views for new or modified rows and trigger downstream runbook actions - Support Hybrid Data Automation
Automate processes across supported Microsoft SQL Server versions and Azure SQL Database
Key Capabilities
- Script-Free SQL Command Generation
Automatically builds and executes the required SQL commands so Orchestrator users can automate database tasks without writing or understanding SQL code - Runbook-Ready Database Mapping
Maps database table columns to Orchestrator input properties, filters and published data items, helping authors design SQL Server runbooks faster and with less manual configuration - Safer Data Operations
Helps reduce runbook errors by controlling access to read-only fields, enforcing mandatory inputs and providing value browsers for common data types - Connection Pooling for Performance
Reuses database connections to reduce the overhead created by repeatedly opening and closing connections during automation workflows - Database Monitoring Triggers
Monitors SQL Server tables or views for new or modified rows so database changes can launch downstream Orchestrator actions. - Comprehensive SQL Server Activities
Provides activities to select rows, select joined rows, insert rows, update rows, delete rows, run SQL queries and execute stored procedures - SQL Server and Azure SQL Support
Supports automation across current Microsoft SQL Server versions and Microsoft Azure SQL Database, enabling both on-premises and cloud database workflows
Integration Activities
| Activity Name | Description |
|---|---|
| Delete-Rows | Delete rows from a table or view in an SQL databse |
| Insert-Row | Insert a row into a table in an SQL database |
| Monitor-Rows | Monitor a table or view in an SQL database for changes |
| Run-Procedure | run a stroed procedure or function in an SQL databse |
| Run-Query | Run an SQL query for the database |
| Select-Join | Select rows from multiple joined tables in an SQL database |
| Select-Rows | Select rows from a table in an SQL database |
| Update-Rows | Update rows in a table or view in an SQL database |