Microsoft Azure SQL Database Spoke

  • Release version: Washingtondc
  • Updated August 3, 2023
  • 2 minutes to read
    • Summarize
    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 you to configure and manage Azure SQL databases directly within your ServiceNow instance. It is bundled with the Microsoft Azure SQL Resource Management Spoke, which allows for comprehensive resource management in your Azure subscription. This spoke requires an Integration Hub subscription to utilize its functionalities.

    Show full answer Show less

    Key Features

    • Latest Version: The current version is 2.0.0, built for API version 2021-11-01 with potential compatibility for later versions.
    • Essential Dependencies: Ensure that the following plugins are installed:
      • ServiceNow IntegrationHub Runtime
      • ServiceNow IntegrationHub Action Step - REST
      • Complex Object
      • ServiceNow Flow Designer - Dynamic Inputs
      • ServiceNow IntegrationHub Action Template - Data Stream
      • Azure Resource Management Spoke v 2.0.0
    • Actions for Automation: Automate Azure SQL tasks, including creating, deleting, updating databases, and retrieving operational status.

    Key Outcomes

    With the Microsoft Azure SQL Database Spoke, you can streamline database management tasks within ServiceNow, allowing for efficient handling of database resources. By using connection and credential aliases, you simplify the management of multiple environments and enhance your operational efficiency. This integration ultimately enables you to have greater control over your Azure SQL databases while reducing manual overhead.

    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.