--- sourceDocument: Australia Workflow Data Fabric sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications Release : - australia ft:locale : - en-US ft:publication_title : - Australia Workflow Data Fabric ft:clusterId : - crint bundleId : - crint workflow : - Creator --- # Microsoft Azure SQL Database Spoke # Microsoft Azure SQL Database Spoke {#ariaid-title1} Release version: Australia Updated August 3, 2023 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## 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 your subscription. Show full answer Show less This spoke requires an IntegrationHub subscription and is built for the Azure API version 2021-11-01, though it may support later versions. ## Key Features * **Database Management Actions:** Automate Azure SQL database tasks such as creating generic, Hyperscale, or VCore databases; deleting and renaming databases; retrieving database details; listing databases in elastic pools or servers; checking operational status; and updating database SKUs or properties. * **Connection and Credential Aliases:** IntegrationHub manages Azure connection and credential information via aliases, simplifying configuration across multiple environments and avoiding the need for updating actions when credentials change. * **Dependency on Azure Resource Management Spoke:** The Azure SQL Database Spoke requires that the Azure Resource Management Spoke (v2.0.0) is installed and configured with a connection alias on your instance. * **Plugin Dependencies:** Installation requires several ServiceNow plugins such as IntegrationHub Runtime, REST action step, Complex Object, Dynamic Inputs, Data Stream action template, and the Azure Resource Management Spoke. ## Setup and Requirements * A user with full access to Microsoft Azure Cloud Computing is necessary. * No separate configuration is needed for the Azure SQL Database Spoke beyond setting up the Azure Resource Management Spoke. * Proper licensing for IntegrationHub and any dependent plugins is required; consult your account manager for license details. ## Practical Benefits ServiceNow customers can seamlessly automate and orchestrate Microsoft Azure SQL database operations within their existing workflows. This integration reduces manual effort, ensures consistent resource management, and streamlines credential management across environments, enhancing operational efficiency and governance. 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 {#azuresql-spoke__section_xcf_3df_mjb} Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).{#azuresql-spoke__inline-send-to-store} ## IntegrationHub subscription {#azuresql-spoke__section_jwm_5vd_ykb} This spoke requires an Integration Hub subscription. For more information, see [Legal schedules - IntegrationHub overview](https://www.servicenow.com/content/dam/servicenow-assets/public/en-us/doc-type/legal/snc-addendum-integrationhub.pdf). ## Spoke version {#azuresql-spoke__section_lqp_2mw_bsb} Microsoft Azure SQL Database spoke v2.0.0 is the latest version. For version history of the spoke, see [Microsoft Azure SQL Database spoke release notes](https://www.servicenow.com/docs/r/store-release-notes/store-integrationhub-rn-azure-sql.html).{#azuresql-spoke__azuresql-ver} ## Supported versions {#azuresql-spoke__section_a55_b55_wlb} This spoke was built for the API version 2021-11-01, but may be compatible with the later versions. ## Spoke requirements {#azuresql-spoke__section_g1j_zlt_pkb} User with full access to Microsoft Azure Azure Cloud Computing. ## Spoke dependencies {#azuresql-spoke__section_j52_bmn_fnb} 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. {#azuresql-spoke__ul_k52_bmn_fnb} 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 {#azuresql-spoke__section_t31_1mt_pkb} The provides actions to automate Microsoft Azure Microsoft Azure SQL tasks when events occur in the ServiceNow instance. Available actions include:{#azuresql-spoke__table_gvv_pl5_pkb__entry__3} | Category | Action | Description | |-|-|-| | Database Management | Create Generic Database | Creates a generic database in Microsoft Azure. | | Database Management | Create Hyperscale Database | Creates a Hyperscale database in Microsoft Azure. | | Database Management | Create VCore Database | Creates a VCore database in Microsoft Azure. | | Database Management | Delete Database | Deletes the required database in a server. | | Database Management | Look up Database | Retrieves details of a database. | | Database Management | Look up Databases Stream by Elastic Pool | Retrieves a list of databases in an elastic pool. | | Database Management | Look up Databases Stream by Server | Retrieves a list of databases in a server. | | Database Management | Look up Operational Status | Generates the operational status of a database that is created or updated. | | Database Management | Rename Database | Renames a database. | | Database Management | Update Database | Updates the SKU or the properties of a database. | [ ] {#azuresql-spoke__table_gvv_pl5_pkb} ## Connection and credential alias requirements {#azuresql-spoke__section_yw5_3s5_pmb} 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](https://www.servicenow.com/docs/access?context=r-credentials&version=australia&pubname=australia-platform-security&ft:locale=en-US). ## Set up the Microsoft Azure SQL Database Spoke {#azuresql-spoke__section_w52_bmn_fnb} 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](https://www.servicenow.com/docs/lcXviIIdwwyokCl7tDsThw#setup-res-mngmt "Integrate the ServiceNow instance and the Microsoft Azure Resource Management by configuring the Microsoft Azure Resource Management connection record on your ServiceNow instance.").