Preliminary step: Creating Maximo views
This task is only for Centennial Discovery 2006 and Centennial Discovery 2007 adapters. Perform this task to run database scripts that create Maximo® views. The database scripts run against the SQL Server (the source database for Centennial Discovery), adding the Maximo views needed for the Centennial Discovery data schema.
About this task
Before you can use the Centennial Discovery 2006 or Centennial Discovery 2007 integration adapter, you have to run a script (for creating Maximo views) against your Centennial Discovery database. To do so, use the following file (where installation_dir is the directory where Integration Composer was installed):
installation_dir\data\dataschema\centennial2006_2007\createViewsForMaximo.sql
| View name | View description |
|---|---|
| maximo_summary | Contains a list of deployed assets (computers, network devices, network printers) |
| maximo_computer | Contains data for computers |
| maximo_networkadapter | Contains data for network adapters installed on a computer |
| maximo_OS | Contains data for the operating system installed on a computer |
| maximo_processor | Contains data for processors installed on a computer |
| maximo_physicaldisk | Contains data for hard drives, CD-ROM, DVD-ROM and floppy drives on a computer |
| maximo_display | Contains data for monitors attached to a computer |
| maximo_logicaldrive | Contains data for partitions on a hard disk such as C:\ |
| maximo_mediaadapter | Contains data for sound cards and video cards installed on a computer |
| maximo_software | Contains data for software installed on a computer |
| maximo_networkdevice | Contains data for network devices |
| maximo_networkprinters | Contains data for network printers |
| maximo_tcpip | Contains TCP/IP data for a computer |
The steps for creating Maximo views follow.
Procedure
- Using a database query tool, run the createViewsForMaximo.sql script against your source SQL Server database.
- Resolve any script errors.