Integration with AM

The AM integration uses the SAP BusinessObjects Data Services drivers for data store connections.

This section describes the integration, contexts, KPIs, Metrics, and reports, if any, associated with the integration with the Asset Manager data source.

The Asset Manager (AM) content pack enables you to receive data information from the AM application. AM is a fully integrated suite of modules delivered as part of the Service Management Center software package. AM software manages the physical, virtual, financial, and contractual aspects of assets.

For details about Asset Manager (AM), see http://www8.hp.com/us/en/software-solutions/asset-management-software/index.html.

ClosedTo access:

Select ADMIN > Data Management > Connect Data Source then click Add data source and select AM to activate the integration processes for the AM data source.

Closed Activate the integration

  1. Prerequisite:

    The AM data source can have either the Oracle or the SQL Server type.

ClosedAM Activation Page

The data warehouse is connected to Asset Manager through high-level integration processes.

User interface elements are described below:

ClosedFor the SQL server:

The following is an example of the AM Activation page when the database backup of Asset Manager is restored on an SQL Server.

Note If you are working with an MSSQL database, change to case insensitive COLLATION as case sensitive COLLATION is not supported.

Mandatory fields are marked with a red asterisk.

UI Element

Description

Instance name Enter a name for the data source instance you are activating.
AM Version

Select the relevant AM version. For details, see the ..

Time Zone Select the time zone for the data source.
Data Source Type AM should be configured to run on an SQL Server.
Username Enter the username used to log on to the AM database.
Password Enter the password used to log on to the AM database.
Hostname/IP Address

Enter the SQL server database hostname or IP address.

Port Enter the server port number.
Database Name Enter the database name used by AM.
Initial Load Period (months) Select the number of months from which you want the initial data loaded.

ClosedFor the Oracle Server:

The following is an example of the AM Activation page when the database backup of Asset Manager is restored on an Oracle Server.

Mandatory fields are marked with a red asterisk.

Note The Oracle database can have both Server ID (SID) and Service Name properties, but the user should specify only one. If you define the SID, then the SID is used, and if you define Service Name, then Service Name is used. If you define both in the UI, only SID is used.

UI Element

Description

Instance name Enter a name for the data source instance you are activating.
AM Version

Select the relevant AM version. For details, see the ..

Time Zone Select the time zone for the data source.
Data Source Type AM should be configured to run on an Oracle server.
Username Enter your username used to log on to the AM database.
Password Enter your password used to log on to the AM database.
Hostname/IP Address Enter the Oracle server hostname or IP address.
Port Enter the server port number.
SID Enter the unique name of the database.
Service Name Enter the alias used when connecting.
Initial Load Period (months) Select the number of months from which you want the initial data loaded.

ClosedAM-Related KPIs and Metrics

For a list of the AM-related KPIs and Metrics, see KPIs and Metrics.