VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 -... User manual

Application Discovery Manager
Repository Reference Guide
vCenter Application Discovery Manager 6.1.1
This document supports the version of each product listed and
supports all subsequent versions until the document is replaced
by a new edition. To check for more recent editions of this
document, see http://www.vmware.com/support/pubs.
EN-000452-01

VMware, Inc.
3401 Hillview Ave.
Palo Alto, CA 94304
www.vmware.com
2VMware, Inc.
ADM Repository Reference Guide
You can find the most up-to-date technical documentation on the VMware Web site at:
http://www.vmware.com/support/
The VMware Web site also provides the latest product updates.
If you have comments about this documentation, submit your feedback to:
[e-mail]
Copyright © 2010 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and
intellectual property laws. VMware products are covered by one or more patents listed at
http://www.vmware.com/go/patents.
VMware is a registered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks
and names mentioned herein may be trademarks of their respective companies.

VMware, Inc. 3
Contents
AboutThisBook 5
1Introduction 7
Overview 7
HowDataIsCollected 7
SynchronizingtheExternalDatabase 8
2SetUptheExternalReportsSchemeConfigurationPolicy 11
SetUpandMonitortheExternalReportsSchemeConfigurationPolicy 11
CreatingtheExternalReportsSchemeConfigurationPolicy 11
ChecktheStatusoftheSynchronizationProcess 13
3ExternalDatabaseSetup 15
ExternalDatabaseSystemRequirements 15
MinimumHardwareRequirements 15
SoftwareRequirements 15
InstallingandConfiguringtheExternalDatabaseforOracle 16
InstalltheClient‐SideScript 16
CreatetheExternalReportingDatabaseUser 17
Createtheadm_olapTables 17
ConfiguretheSynchronizationProcess 18
InstallingandConfiguringtheExternalDatabaseforMSSQL 20
InstalltheClient‐SideScripts 20
InstalltheExternalDatabaseforMSSQLServer 20
ConfiguretheSynchronizationProcess 21
ManuallyLoadingDatatotheExternalDatabase 23
CheckingtheStatusoftheExternalDatabaseLoadProcess 23
UpgradingtheExternalDatabase 24
UpgradingforMSSQL 24
UpgradingforOracle 25
4ADMERDSchema 27
OverviewofExternalDatabaseTables 28
DatabaseStructureandDependencies 28
Address 29
Change_Log 29
CPU 29
Database 30
Dependency 30
Group_Membership 31
Installed_Software 32
IP_Route 32
Java_EE 33
Network_Element 33
Network_Interface 34

ADM Repository Reference Guide
4VMware, Inc.
Port 35
Property 35
Service 36
Storage_Device 36
Switch_Address_Forwarding 37
Time 37
Usage_Metric 38
Usage_Metric_Baseline 38
Virtual_System_Settings 38
5ADMCustomReports 41
CreatingCustomReports 41
HostInventory 41
ConnectionInventory 41
MostUsedServices 41
ApplicationDependency 42
Index 43

VMware, Inc. 5
TheVMwarevCenter™ApplicationDiscoveryManager(ADM)RepositoryReferenceGuideprovides
informationaboutsettingupandconfiguringtheADMexternalrepository.Itdescribesthetablestructureand
dependencieswithintheADMexternaldatabaseandalsoillustratesthetables.Tohelpyouwiththecustom
reports,thebookprovidesexamplesofreportsthatcanbegeneratedfromtheADMexternaldatabase.
Intended Audience
ThisdocumentispartoftheVMwarevCenterApplicationDiscoveryManagerdocumentationset,andis
intendedforusebycorporateInformationTechnology(IT)personnelwhoneedtomonitorenterprise
applicationsandresourcesandmakedecisionsaboutacquiring,allocating,andmodifyingtheseresources.
Readersofthisguideareexpectedtobefamiliarwiththesetopics:
Oracledatabase
SQL
VMware Technical Publications Glossary
VMware®TechnicalPublicationsprovidesaglossaryoftermsthatmightbeunfamiliartoyou.Fordefinitions
oftermsastheyareusedinVMwaretechnicaldocumentationgotohttp://www.vmware.com/support/pubs.
Document Feedback
VMwarewelcomesyoursuggestionsforimprovingourdocumentation.Ifyouhavecomments,sendyour
feedbackto[e-mail].
Technical Support and Education Resources
Thefollowingsectionsdescribethetechnicalsupportresourcesavailabletoyou.Toaccessthecurrentversion
ofthisbookandotherbooks,gotohttp://www.vmware.com/support/pubs.
Online and Telephone Support
Touseonlinesupporttosubmittechnicalsupportrequests,viewyourproductandcontractinformation,and
registeryourproducts,gotohttp://www.vmware.com/support.
Customerswithappropriatesupportcontractsshouldusetelephonesupportforthefastestresponseon
priority1issues.Gotohttp://www.vmware.com/support/phone_support.
Support Offerings
TofindouthowVMwaresupportofferingscanhelpmeetyourbusinessneeds,goto
http://www.vmware.com/support/services.
About This Book

ADM Repository Reference Guide
6VMware, Inc.
VMware Professional Services
VMwareEducationServicescoursesofferextensivehands‐onlabs,casestudyexamples,andcoursematerials
designedtobeusedason‐the‐jobreferencetools.Coursesareavailableonsite,intheclassroom,andlive
online.Foronsitepilotprograms andimplementationbestpractices,VMwareConsultingServicesprovides
offeringsto helpyouassess,plan,build,andmanageyourvirtualenvironment.Toaccessinformationabout
educationclasses,certificationprograms,andconsultingservices,gotohttp://www.vmware.com/services.

VMware, Inc. 7
1
ThischapterintroducestheVMwarevCenter™ApplicationDiscoveryManager(ADM)repositoryand
providesanoverviewthatincludesdescriptionsofdatacollection,tabletypes,andkeyfields.
Thischapterincludesthefollowingtopics:
“Overview”onpage 7
“SynchronizingtheExternalDatabase”onpage 8
Overview
TheADMprovidesstandardreportsbasedonthedatacollectedandstoredintheADMRepository.The
schemaofthenewADMExternalDatabaseissimpletounderstandandallowsyoutowritereportingqueries
overitwithoutdisruptingtheperformanceoftheotherADMservices.
How Data Is Collected
TheADMcollects,manages,andstoresdatathroughthecomponentslistedinTable 1‐1.
Figure 1‐1illustrateshowdataiscollectedandstoredintheADMdatabase.
Introduction 1
Table 1-1. ADM Components
Component Description
ActiveDiscovery‐
Unix
Collectsdatafromtheconfigurationobjectsinyourdatacenter.Thefollowingdiscoverytypes
apply:
IPdiscovery:DetectshostsorotherconfigurationitemswithaspecificIPaddresswhen
passivediscoveryfailstodiscoverthem.
Detaildiscovery:ExtendstheinformationobtainedusingpassiveandIPdiscovery.Ituses
commonnetworkprotocolstoremotelyqueryserversinthemanagednetworkandobtains
supplementaryinformationaboutnetworkhoststhatisaddedtothedatabase.
ActiveDiscovery‐
Windows
AdiscoveryenginethatusesWMIbaseddiscoverypoliciesforperformingactivediscoveryon
Windowsmachines.
PassiveDiscovery Passivelyobservesthenetworktrafficbyperformingadeep‐packetanalysistodiscover
applicationsandcomponentrelationshipsinphysicalandvirtualenvironments.
Passivediscoveryalsoallowsyoutodothefollowing:
Mapdependencies.
Counttheactivityofthesedependencies.
Identifyservices.
Aggregator Receivesdatafromthediscoverycomponentsandreconcilesthedatabeforetransferringittothe
databasecomponent.TheaggregatoralsoprovidestheuserinterfaceforusingADMandisthe
integrationpointforvariousintegrations,forexample,ERDB.
Database AnOracleRDBMSusedtostorediscovereddataandADMconfiguration.

ADM Repository Reference Guide
8VMware, 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.
4ThesystemrunningtheexternaldatabaseperiodicallycheckstheFTPserverfordatafilesbasedonthe
synchronizationscheduledefinedontheexternaldatabasesystem.
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

VMware, Inc. 9
Chapter 1 Introduction
5Whenadatafileisfound,thefollowingprocesstakesplaceontheexternaldatabasesystem:
aThelatestZipfileisdownloaded.
bTheZipfileisextractedtothedecompressed.csvdatafiles.
cThedatabaseloadingisperformedusingthedatabasespecificloader.
Performance and Scalability
Thefollowingstepsindicatetheamountoftimerequiredtocompleteeachprocess:
Extractionandflatfilecreation:ThissteputilizestheADMresourcestothemaximum.Therefore,itis
scheduledtoextractthedataatnightorsomeotherperiodoflowresourceconsumptionandtoallow
enoughtimetocomplete.
Transferringthedatafiles:ThisstepinvolvesuploadingoftheflatfilesfromtheADMRepository
appliancetotheexternaldatabasehost.ThisstepdoesnotconsumemanyADMresources.However,the
transfertimemightvarygreatlybecauseofnetworkconditionsattheexternaldatabasehostsite.
Loadingthedatabase:Thisstepmighttakefewhourstocomplete.

ADM Repository Reference Guide
10 VMware, Inc.