SQL Server Integration Module for Azure Automation and Runbook Studio
Connect, control and automate Microsoft SQL Server from Kelverion Runbook Studio and Azure Automation with a smart integration module designed to remove complexity, reduce scripting effort and make database automation easier to build, maintain and support.
Microsoft SQL Server is an enterprise relational database platform used to store, process, secure and analyse business-critical data. Organisations rely on SQL Server to support applications, reporting, operational processes and data-driven services across on-premises, cloud and hybrid environments. It provides the performance, availability, security and developer capabilities needed to run everything from departmental applications to mission-critical enterprise workloads.
For IT operations and automation teams, SQL Server is often more than a database. It is a source of truth, a system of record and a key dependency in service delivery workflows. Automating SQL Server interactions helps teams keep processes consistent, reduce manual administration and connect database activity with wider IT service management and infrastructure automation.
Typical Automation Scenarios
- Service Request Fulfilment
Trigger database updates, lookups or validation steps as part of employee onboarding, application access or operational service requests - Incident Enrichment
Query SQL Server for application, asset or user data and publish the results into downstream IT service management workflows - Operational Reporting
Extract runbook, service or application data from SQL Server to support automation reporting and audit processes - Data-Driven Remediation
Use SQL Server records to determine the next automation action, such as identifying affected systems, validating status or updating process state - Application Administration
Automate routine database-backed administration tasks such as inserting, updating, retrieving or deleting records where permitted - Workflow Orchestration
Combine SQL Server activities with service desk, infrastructure, cloud and application integrations to deliver end-to-end automation
Benefits at a Glance
- Build Runbooks Faster
Reduce the time required to create SQL Server automation by using discovered database structures, mapped inputs and reusable activities - Reduce Scripting Dependency
Automate database operations without needing every runbook designer to write SQL or PowerShell - Improve Reliability
Control access to read-only fields, enforce mandatory inputs and guide users with value browsers for common data types - Standardise Database Automation
Use repeatable, reusable Smart Connections to connect Runbook Studio to one or more SQL Server databases - Support Least-Privilege Design
Create different Smart Connections for different databases or security contexts, including multiple connections to the same database with different user privileges - Extend Azure Automation
Add SQL Server-aware activities to Azure Automation runbooks while keeping the execution model aligned to Microsoft’s automation platform - Enable Wider Team Participation
Let automation teams, service desk teams and operations staff contribute to runbook design through a graphical Runbook Studio experience
Key Capabilities
- Automatically discovers SQL Server databases, structures and properties
- Builds and executes the necessary SQL commands without requiring the runbook designer to write or understand PowerShell
- Automatically maps table columns to input properties, filters and published data items
- Provides guided configuration to reduce design errors and improve runbook consistency
- Controls access to read-only fields and enforces mandatory input values
- Includes value browsers for common data types to simplify runbook activity configuration
- Supports reusable Smart Connections to specific SQL Server databases
- Allows multiple Smart Connections across multiple databases or security contexts
- Provides rich bi-directional SQL Server integration for Microsoft Azure Automation
- Works with Kelverion Runbook Studio’s graphical, low-code/no-code runbook authoring experience
Integration Activities
| Activity Name | Description |
|---|---|
| Delete-SQLRow | Delete rows from a database table or view using filter criteria to determine which rows should be deleted |
| Get-SqlRowCount | Count the rows in a database table or in a limited result set using filter criteria. |
| Insert-SQLRow | Insert a row into a database table or view |
| Invoke-SQLCommand | Invoke an SQL statement and return the results as a sequence of comma separated values |
| Invoke-SQLProcedure | Invoke a stored procedure and return the results |
| Select-SQLRow | Retrieve rows from a database table or view and return the results as a sequence of PSObject instances |
| Update-SQLRow | Update rows in a database table or view using filter criteria to determine which rows should be updated |