Microsoft Azure SQL Database Spoke
Summarize
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 from their 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 within the customer's Azure subscription.
Show less
This integration requires an IntegrationHub subscription and depends on specific ServiceNow plugins to function correctly. It supports API version 2021-11-01 and may be compatible with later versions.
Key Features
- Database Management Actions: Automate common Azure SQL database tasks such as creating generic, Hyperscale, or VCore databases, deleting databases, renaming, updating database properties or SKU, and retrieving database details or operational status.
- Streamlined Connection Management: Uses IntegrationHub aliases to manage connection and credential details efficiently across multiple environments, reducing the need to update individual actions when connection information changes.
- Dependency on Azure Resource Management Spoke: Requires the Microsoft Azure Resource Management spoke (version 2.0.0) to be installed and configured first, as it provides the foundational resource management capabilities.
Practical Considerations
- Prerequisites: Users must have full access to Microsoft Azure and Azure Cloud Computing resources.
- Plugin Dependencies: Ensure the necessary ServiceNow plugins like IntegrationHub Runtime, REST action steps, Complex Object, Flow Designer Dynamic Inputs, and Action Template Data Stream are installed. Some plugins may require additional licensing.
- Setup: No separate configuration for the Azure SQL Database Spoke is needed beyond setting up the Azure Resource Management Spoke. Follow the setup instructions for the Azure Resource Management Spoke to get started.
Expected Outcomes
By leveraging this spoke, ServiceNow customers can seamlessly automate and manage their Azure SQL databases within the ServiceNow platform, improving operational efficiency and reducing manual management overhead. The integration simplifies database lifecycle management and ensures consistent handling of Azure SQL resources aligned with organizational workflows.
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 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
- 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.
Spoke actions
| 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 .
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.