Set up the SCCM Usage Metering spoke

task australia Updated Mar 12, 2026 3 min read setup-sccm-usage-metering-spoke.md
Raw file servicenow.com

Integrate the ServiceNow instance and SCCM using Java Database Connectivity (JDBC) credentials to authenticate ServiceNow requests.

Before you begin

  • Request an Integration Hub subscription.
  • Activate the SCCM Usage Metering spoke.
  • Role required: admin.

Create Connection records for the SCCM Usage Metering spoke

Create Connection records to the SCCM server. The SCCM Usage Metering spoke connection and credential aliases use these connections to perform actions in SCCM.

Before you begin

Role required: admin.

Procedure

  1. Navigate to All > Credentials & Connections > Connections.

  2. Click New and select JDBC Connection.

  3. On the form, fill in the fields.

    The database selection in the Format field determines which fields are available.

Field

Description

Name

Unique name of the JDBC connection. For example, JDBC MySQLProd.

Credential

Credential for the JDBC provider. Enter the user name and password of the database.

Connection alias

Alias record associated with the connection.

Query timeout

Maximum elapsed time the JDBC query allowed to run without a response.

Connection timeout

Maximum elapsed time for the JDBC activity to wait while attempting to connect to the target database.

Active

Option to make the connection active.

Domain

Domain for the table. By default, the JDBC Connection [jdbc_connection] table runs in the global domain.

Format

Database type for the connection. The choices are:- MySQL

  • Oracle
  • SQLServer
  • None

Host

Host name or IP address of the database server.

Oracle port

Port that the Oracle database is using. The default value is 1521.Note: This field is available when Oracle is selected from the Format list.

Oracle sid

Oracle database site identifier. The default value is orcl.Note: This field is available when Oracle is selected from the Format list.

Database name

Name of the database. Note: This field is available when MySQL or SQLServer is selected from the Format list.

Override default port

Port that the selected database is using. Note: This field is available when MySQL or SQLServer is selected from the Format list.

Instance name

Instance name for the selected SQLServer. Note: This field is available when SQLServer is selected from the Format list.

Connection URL

URL that MID Server uses to connect to the specified database. The URL is created automatically when you save the form, and is read-only for the default databases. For example, jdbc:<database>://<hostname>;selectMethods=cursor;databaseName=<database_name>.Note: If the format selected is not one of the default databases, you must create the connection URL manually. So that the MID Server can create the connection.

Use MID server

Option to use a MID Server for the action. If selected, define fields in the Advanced MID Server Configuration section.

Capabilities

Capabilities that the MID Server must support to be eligible for selection. Only displays if Use MID server is selected. To learn more about how a MID Server is selected during runtime, see MID Server selection.

MID Application

Application that the MID Server must support to be eligible for selection. Only displays if Use MID server is selected. To learn more about how a MID Server is selected during runtime, see MID Server selection.

## Create Credential records for the SCCM Usage Metering spoke

Create Credential records to the SCCM server. The SCCM Usage Metering spoke connection and credential alias uses these credentials to authorize actions.

Before you begin

Role required: admin.

Procedure

  1. Navigate to All > Connections & Credentials > Credentials.

  2. Click New.

  3. Select JDBC Credentials.

  4. On the form, fill these values.

    Field Description
    Name Name to uniquely identify the credential.
    Active Option to use the credentials.
    Applies to Option to verify if the credentials apply to All MID servers in your network, or to one or more Specific MID servers. Specify the MID Servers that should use these credentials in the MID servers field.
    Order Order to apply this credential. For example, enter 100.
    User name User name to access the database.
    Password Password to access the database.
    Credential alias Credential alias associated with the spoke.
  5. Click Submit.

Search documentation
Search document titles and file paths on the australia branch