VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User Manual download pdf (Page 8)

ADM Repository Reference Guide

8 VMware, Inc.

Figure 1-1. Collection, Management, and Storage of ADM Data

ThedatastoredintheADMdatabasecannotbecustomizedormanipulatedforcreatingcustomreports.

Therefore,ADMprovidesfunctionalityforexportingthedataintoanADMexternalrepository,fromwhich

customreportsarecreated.

Thedatatransferredtotheexternalrepositoryisnotreal‐timedata.Itissynchronized

atregularintervalsas

definedintheExternalReportsSchemeConfigurationpolicy.

Synchronizing the External Database

Figure 1‐2illustrateshowtheADMexternaldatabaseissynchronizedwiththeADMrepositorythroughthe

ETL(Extract‐Transform‐Load)process.ExtractionandtransformationisdonethroughADMandloadingis

donebytheadm_olapcomponentontheexternaldatabasehost.

Figure 1-2. External Database Synchronization Process

Thesynchronizationprocesscomprisesofthefollowingsteps:

1Thesynchronization

istriggeredaccordingtothesettingsintheExternalReportsSchemeConfiguration

policy.

2ADMchecksthestatusofthereplicationtoensurethattheprevioussynchronizationandthatanyreport

requestsagainsttheexternaldatabasehascompleted.

3ADMextractsthedatafilesfortheloadprocessasfollows:

aTheReportSchema

isextractedandtranslatedto.csvfiles.

bThedatafilesarecompressedandplacedtogetherinasingleZiparchive.

cTheZipfileisuploadedtotheassignedFTPserver.

Database

detail

passive

Discovery

Management

database

server

flat files

data download

ADM_OLAP

Reporting Schema

FTP server

ADM

flat files

data upload

load flat files into

ADM_OLAP Schema

1 2 3 4 5 6 7 8 9 10 11 12 13 ... 41 42

No comments

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User Manual Page 8