Microsoft Azure SQL Database Spoke

Release version: Zurich

Updated August 3, 2023

2 minutes to read

Summarize

Summarized using AI

Summary of Microsoft Azure SQL Database Spoke

The Microsoft Azure SQL Database Spoke enables ServiceNow customers to configure and manage Microsoft Azure SQL databases directly within the ServiceNow instance. Installing this spoke also includes the Microsoft Azure SQL Resource Management spoke, which leverages the Azure Resource Manager to create, update, and delete Azure resources in your subscription.

Show full answer Show less

This spoke requires an IntegrationHub subscription and is compatible primarily with the Azure API version 2021-11-01, with possible support for later versions.

Key Features

Database Management Actions: Automate tasks such as creating generic, Hyperscale, or VCore databases; deleting, renaming, and updating databases; and retrieving database details or operational status.
Connection and Credential Aliases: IntegrationHub uses aliases to manage connections and credentials efficiently across multiple environments, simplifying maintenance if connection details change.
Dependencies: Requires installation of several ServiceNow plugins including IntegrationHub Runtime, REST action steps, Complex Object support, Dynamic Inputs for Flow Designer, Data Stream action templates, and the Azure Resource Management Spoke (version 2.0.0).

Setup and Configuration

Before using the Microsoft Azure SQL Database Spoke, you must first install and configure the Microsoft Azure Resource Management Spoke. No additional configuration is needed specifically for the SQL Database Spoke after this setup.

Ensure you have a user account with full access to Microsoft Azure Cloud Computing to utilize the spoke effectively.

Practical Benefits for ServiceNow Customers

Streamline management of Azure SQL databases from within ServiceNow, reducing context switching and manual Azure portal interactions.
Automate routine database lifecycle tasks to improve operational efficiency and reduce errors.
Leverage IntegrationHub’s alias system to manage multiple Azure environments securely and flexibly.

Configure and manage the Microsoft Azure SQL databases from within the ServiceNow instance. When you install the Microsoft Azure SQL database spoke, you also get the Microsoft Azure SQL Resource Management spoke. The Microsoft Azure Resource Manager provides a management layer that enables you to create, update, and delete the resources in your Microsoft Azure subscription.

Request apps on the Store

Visit the ServiceNow Store website to view all the available apps and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

IntegrationHub subscription

This spoke requires an Integration Hub subscription. For more information, see Legal schedules - IntegrationHub overview.

Spoke version

Microsoft Azure SQL Database spoke v2.0.0 is the latest version.

Supported versions

This spoke was built for the API version 2021-11-01, but may be compatible with the later versions.

Spoke requirements

User with full access to Microsoft Azure Azure Cloud Computing.

Spoke dependencies

If you’re having trouble installing the app, confirm that these dependent plugins are installed:

ServiceNow IntegrationHub Runtime (com.glide.hub.integration.runtime)
ServiceNow IntegrationHub Action Step - REST (com.glide.hub.action_step.rest)
Complex Object (com.glide.cobject)
ServiceNow Flow Designer - Dynamic Inputs (com.glide.hub.dynamic_inputs)
ServiceNow IntegrationHub Action Template - Data Stream (com.glide.hub.action_type.datastream)
Azure Resource Management spoke (sn_azure_rm_spoke) v 2.0.0 is installed and a connection alias is created on your instance.

Note:

Some of these plugins are licensable features and require appropriate licenses, if used outside the spoke implementation. For more information on the licenses, contact your account manager.

Spoke actions

The provides actions to automate Microsoft Azure Microsoft Azure SQL tasks when events occur in the ServiceNow instance. Available actions include:


Category	Action	Description
Database Management	Create Generic Database	Creates a generic database in Microsoft Azure.
	Create Hyperscale Database	Creates a Hyperscale database in Microsoft Azure.
	Create VCore Database	Creates a VCore database in Microsoft Azure.
	Delete Database	Deletes the required database in a server.
	Look up Database	Retrieves details of a database.
	Look up Databases Stream by Elastic Pool	Retrieves a list of databases in an elastic pool.
	Look up Databases Stream by Server	Retrieves a list of databases in a server.
	Look up Operational Status	Generates the operational status of a database that is created or updated.
	Rename Database	Renames a database.
	Update Database	Updates the SKU or the properties of a database.

Connection and credential alias requirements

Integration Hub uses aliases to manage connection and credential information. Using an alias eliminates the need to configure multiple credentials and connection information profiles when using multiple environments. If the connection or credential information changes, you don't need to update any actions that use the connection. For more information, see Connections and Credentials.

Set up the Microsoft Azure SQL Database Spoke

To execute the actions of the Microsoft Azure SQL Database Spoke, you must first install and configure the Microsoft Azure Resource Management Spoke. No separate configuration of the Microsoft Azure SQL Database Spoke is necessary. To view the procedure to set up the Microsoft Azure Resource Management Spoke, see Set up the Microsoft Azure Resource Management spoke.