Integration Pack for SQL Server
The Integration Pack for SQL Server is compliant with Microsoft System Center 2012 R2 Orchestrator or System Center 2016 Orchestrator.
The Integration Pack supports the following SQL Server versions:
-Microsoft SQL Server 2005
-Microsoft SQL Server 2008 & 2008 R2
-Microsoft SQL Server 2012
-Microsoft SQL Server 2014
-Microsoft SQL Server 2016
-Microsoft Azure SQL Database
It enables users to interact with MS SQL Server databases without writing SQL code, and improves capabilities over the Standard Activities shipped with Orchestrator.
The key capabilities added to your Orchestrator solution include:
-Automatically builds and executes the necessary commands without the user having to write or understand SQL.
-Simplifies Runbook design by automatically mapping table columns to Orchestrator input properties, filters and published data items.
-Prevents errors by controlling access to readonly fields, enforcing mandatory inputs and by providing value browsers for common data types.
-Improves performance by using connection pooling to reduce the overhead of repeatedly opening and closing database connections.
-Introduces the ability to monitor database tables for new and/or modified rows.