The Kelverion Integration Module for SQL Server provides significantly improved capabilities and an enhanced user experience over writing native SQL interaction via PowerShell in Azure Automation Runbooks.
Using Kelverion smart discovery the Integration Module interrogates the SQL instance and discovers the databases, their structure and properties.
SQL Server database interaction includes:
• Provides script free interaction with SQL Server
• Simplifies Runbook design by automatically mapping table columns to Azure Automation input properties, filters and published data items.
Provides ready built activities to:
• Select , Insert, Delete, Update Rows
• Execute a SQL Stored Procured
The Integration Module supports SQL Server 2012, 2016 and Azure SQL Server.
To take full advantage of Kelverion Integration Module for SQL Server please review the Kelverion Runbook Studio authoring application here, where you will be able to download a free trial.
As a designer you no longer need to be an expert in the target system to build Azure Automation Runbooks, significantly reducing build time and increasing supportability of your automation solutions.
Current List of Integration Modules
Integration Modules by Vendor:
Microsoft: SQL Server
BMC: Remedy, Atrium