The Kelverion Integration Module for SQL Server provides significantly improved capabilities and an enhanced user experience over writing native SQL integrations 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.
SQL Server versions 2012 and up:
Select, Insert, Delete, Update Rows
Execute a SQL Stored Procedure
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.