---
sourceDocument: Yokohama Data and Automation
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/integrate-applications

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Data and Automation

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Set up the SCCM Usage Metering spoke

# Set up the SCCM Usage Metering spoke {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

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.
{#setup-sccm-usage-metering-spoke__ul_l2l_mph_gfb}

## Create Connection records for the SCCM Usage Metering spoke {#ariaid-title2}

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 AllCredentials \& ConnectionsConnections.
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.{#create-connection-sccm-usage-metering__table_frf_bnz_wkb__entry__2}

   | Field | Description |
   |-|-|
   | Name | Unique name of the JDBC connection. For example, <kbd class="ph userinput">JDBC MySQLProd</kbd>. |
   | 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 {#create-connection-sccm-usage-metering__ul_hk3_34z_wkb} |
   | 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](https://www.servicenow.com/docs/access?context=c_MIDServerSelector&version=yokohama&pubname=yokohama-servicenow-platform&ft:locale=en-US). |
   | 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](https://www.servicenow.com/docs/access?context=c_MIDServerSelector&version=yokohama&pubname=yokohama-servicenow-platform&ft:locale=en-US). |
   [ ]

   {#create-connection-sccm-usage-metering__table_frf_bnz_wkb}

## Create Credential records for the SCCM Usage Metering spoke {#ariaid-title3}

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 AllConnections \& CredentialsCredentials.
2. Click New.
3. Select JDBC Credentials.
4. On the form, fill these values.  
   {#create-credential-sccm-usage-metering__table_eb5_4h3_xkb__entry__2}

   | 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 <kbd class="ph userinput">100</kbd>. |
   | User name | User name to access the database. |
   | Password | Password to access the database. |
   | Credential alias | Credential alias associated with the spoke. |
   [ ]

   {#create-credential-sccm-usage-metering__table_eb5_4h3_xkb}
5. Click Submit.

*[\>]: and then