Previous Topic: Enterprise and Domain ComponentsNext Topic: MDB Installation


The Management Database in the Enterprise and Domain Concept

CA Technologies's product suites are integrated through a common enterprise data repository, the management database (MDB). The MDB provides a unified structure for the storage of management data from all CA Technologies products. The MDB integrates management data from all IT disciplines and CA Technologies products. Customers and third-party partners can extend the MDB to include additional IT management data from non-CA Technologies software products and tools.

CA IT Client Manager is based on MDB r1.5 SP1, which by default installs only the common asset and DSM schemas. If any other CA product is going to use the MDB created by CA ITCM, and that product also supports MDB r1.5, then it should install its own schema on top of the existing MDB.

If, however, a CA product supports MDB r1.0.4 only, the installation will fail. In this case, install the MDB with the “Compatibility mode” option checked. CA ITCM will install the latest MDB r1.0.4 patches first, and afterwards the MDB will be upgraded to MDB r1.5. Hence, all schema definitions are present, and only the schema definitions for common asset and DSM are on the same level as for MDB r1.5. For more information, see either Preparing to Work with a Microsoft SQL Server MDB or Preparing to Work with an Oracle MDB.

For general information on the MDB, including deployment and administration, see the MDB Overview which is available as part of the CA IT Client Manager documentation set (Bookshelf).

Within the multi-tier architecture, instances of the management database (MDB) can be implemented at the enterprise and domain manager tiers. Both tiers support Microsoft SQL Server and Oracle MDBs. You can also implement MDBs on different database providers on the individual tiers, for example, you can select SQL Server for the domain manager and Oracle for the enterprise manager.

In mixed configurations, for example, a domain manager with SQL Server-based MDB and an enterprise manager with Oracle-based MDB, you need the appropriate database clients on the managers; in this example, you need the Oracle client on the domain and the SQL client on the enterprise manager.

Currently, an Oracle-based MDB is supported only as a remote database on a computer running a Sun Solaris operating environment. For information about the current database versions and operating environments supported, see the CA IT Client Manager Release Notes which are available as part of the CA IT Client Manager documentation set (Bookshelf).

The supported database scenarios include:

Local SQL Server MDB

DSM domain or enterprise manager on Windows with the MDB located on the same computer and the MDB based on SQL Server.

Remote SQL Server MDB

DSM domain or enterprise manager on Windows with the MDB located on a remote server computer running Windows and the MDB based on SQL Server.

Remote Oracle MDB

DSM domain or enterprise manager on Windows with the MDB located on a remote server computer running Solaris and the MDB based on Oracle.

All MDBs in the enterprise and domain structure have the same schema. Any domain database holds information about how to connect to the enterprise manager. The enterprise database holds information about how to connect to all the domains that are "linked" to it, and which managers are available and where they are located.

CA ITCM provides a feature that lets you synchronize data collected on a Microsoft SQL Server MDB on a domain or enterprise manager with data on a remote SQL Server MDB or Oracle MDB. This database synchronization feature supports, for example, existing installations of CA Technologies's Service Desk Manager and Asset Portfolio Management products that use an SQL Server or Oracle MDB. For more information about the synchronization feature, see Data Synchronization from an MDB to a Separate Target MDB.

Note: To fully support Unicenter Asset Portfolio Management product integration, you must install the RO02252 patch. For installation instructions, see the Unicenter Asset Portfolio Management readme, RO02252. For more information about Unicenter Asset Portfolio Management and CA Service Desk Manager, see their respective documentation.