Set up the SCCM Usage Metering spoke
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
Navigate to All > Credentials & Connections > Connections.
Click New and select JDBC Connection.
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
Navigate to All > Connections & Credentials > Credentials.
Click New.
Select JDBC Credentials.
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. Click Submit.