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.

VMware, Inc. 11
2
TheADMConsoleprovidesthenecessaryfunctionalityto:
“SetUpandMonitortheExternalReportsSchemeConfigurationPolicy”onpage 11
“ChecktheStatusoftheSynchronizationProcess”onpage 13
Set Up and Monitor the External Reports Scheme Configuration Policy
TheExternalReportsSchemeConfigurationpolicydefinestheFTPsitewherethedatabasefilesaresentand
howoftenextractionisperformed.TheExternalReportsSchemeConfigurationprovidesfunctionalityfor
runningthepolicyautomaticallyatascheduledtime,orstartingthesynchronizationnow.
Thispolicyonlycontrolsthefollowingstepsofthesynchronizationprocess:
Databasedataextraction
Databasefilescreation
PostingthedatabasefilestotheFTPsite
YoumustconfiguretheexternaldatabasehosttoretrievethedatafilesfromtheFTPsiteandcompletethe
synchronizationprocess.Chapter 3,“ExternalDatabaseSetup,”onpage 15providescompletedetails.
Creating the External Reports Scheme Configuration Policy
To set up the External Reports Scheme Configuration policy
1LogintotheADMConsoleasadminuser.
2FromtheADMConsole,navigatetoConnectors>ReportsandclickConfigurationintheleftpane.
Set Up the External Reports Scheme
Configuration Policy 2

ADM Repository Reference Guide
12 VMware, Inc.
3InthePublishertab,entertheFTPsitetowhichthedatafilesarepublishedasshownbelow.
where:
TargetHost:ThesystemhostingtheFTPserver.
TargetDirectory:ThedirectoryontheFTPserverhosttowhichthefilesaresent.
UserName:ThenameofauserwithaccesstotheFTPserver.
Password:Thepasswordassociatedwiththeusername.
TransportChannel:AllowsusertochoosebetweenFTPandSecuredFTP(SFTP)fordataupload
fromthedrop‐downmenu.
NumberofRetries:Thenumberoftimesthesynchronizationprocessattempts,incaseoffailure.
4ClickTestConnectiontotesttheconnectiontotheFTPserverbasedonthepublishingcredentialyou
entered.IfyouhaveenteredinvalidcredentialsoriftheFTPserverisdown,thetesttimesoutorfails.
5ClickCreatepolicy.Ifyouhavepreviouslydefinedthepolicy,clickUpdate.
Running the Synchronization Process at Scheduled Times
To schedule the synchronization process
1AftercreatingtheExternalReportsSchemeConfigurationpolicy,selecttheEnableAutomatic
Schedulingoptionatthebottomofthepageasshownbelow.
2IntheSchedulingtab,selectoneormoredaysoftheweektoschedulethestartofthesynchronization.
NOTEEnsurethattheusernameandpasswordarethesame,asusedtoconfigurethe
synchronizationontheexternaldatabasesystemasdescribedin“InstallingandConfiguringthe
ExternalDatabaseforOracle”onpage 16forOracledatabasesuserand“InstallingandConfiguring
theExternalDatabaseforMSSQL”onpage 20forMSSQLServerusers.

VMware, Inc. 13
Chapter 2 Set Up the External Reports Scheme Configuration Policy
3Enterthetimeofdaythesynchronizationoccurs.
IntheaboveexamplethesynchronizationautomaticallybeginseverySaturdayat11:00A.M.
4ClickUpdatetosavethesetting.
Running the Synchronization Process Now
To start the synchronization process on demand
AftercreatingtheExternalReportsSchemeConfigurationpolicy,clickCompleteSynchronizationunderthe
Actionsmenuintheleftpane.
Check the Status of the Synchronization Process
TheADMConsoledisplaysthestatusoftheExternalReportsSchemaConfigurationpolicythatincludesthe
followingsynchronizationsteps:
Extractionofthedatabasefile.
Creationofthedatabasefile.
PostingthedatabasefilestotheFTPsite.
To check the status of the synchronization process
1LogintotheADMConsoleasadminuser.
2FromtheADMConsole,navigatetoConnectors>ReportsandclickStatusintheleftpane.
3Thedisplaypaneliststhefollowingparameters:
LastSync.Time:ThelasttimetheexternaldatabasewassynchronizedwiththeADMrepository.The
timeisbasedonthelocationoftheappliance.
SynchronizationStatus:Thestatusofthesynchronizationprocess.
ScheduledSynchronizationStatus:thestatusofthesynchronizationschedule.
PopulatedElements:Liststheelementsthatwerepopulatedtotheexternaldatabaseduringthelast
synchronization.
Count:Givesthenumberofelementsthatwerepopulatedtotheexternaldatabase.
4ClickLogintheleftpanetoviewthemessages,describingtheeventsofthesynchronizationprocess.
IMPORTANTIfanexistingsynchronizationprocesshasnotcompleted,thenADMdoesnotstartthe
synchronizationprocess.
NOTEStatusofthesynchronizationprocessisoneofthefollowing:
Idle:Theprocessisidle.Nothingiscurrentlyrunning.
Syncinprogress:TheADMsynchronizationprocessisinprogress.
Complete:TheADMsynchronizationiscompleteandtheFTPfilesareloadedtotheFTPServer.
NOTEStatusofthesynchronizationscheduleisoneofthefollowing:
Active:Thesynchronizationscheduleissetandrunsatthescheduledtime.
NotActive:Thereisnoscheduleassociatedwiththepolicy.

ADM Repository Reference Guide
14 VMware, Inc.

VMware, Inc. 15
3
Tousetheexternaldatabasefunctionalityyouneedtoperformthefollowingsteps:
“ExternalDatabaseSystemRequirements”onpage 15
“InstallingandConfiguringtheExternalDatabaseforOracle”onpage 16
“InstallingandConfiguringtheExternalDatabaseforMSSQL”onpage 20
“ManuallyLoadingDatatotheExternalDatabase”onpage 23
“CheckingtheStatusoftheExternalDatabaseLoadProcess”onpage 23
“UpgradingtheExternalDatabase”onpage 24
External Database System Requirements
ToincorporateanexternaldatabaseintoyourADMenvironment,youneedthefollowingcomponents:
AccesstoanFTPserver.
Theexternalreportingdatabaseclienthastobeinstalledonthesameserverasthedatabase.
Thehardwareandsoftwarerequirementsasfollows.
Minimum Hardware Requirements
Ensurethatyoursystemmeetsthefollowinghardwarerequirements:
2GBmemory.
Dualcore1.8GHZCPU.
500MBfortheclientinstallation.IfthedataZipfilesareretainedontheserver,morediskspaceisneeded.
1GBforthedatabaseinstance.
Software Requirements
Thesoftwarerequirementsforeachtypeofdatabaseareasfollows:
Oracle as the External Database
EnsurethesystemmeetsthefollowingrequirementswhenusingOracleasexternaldatabase:
RedHatEnterpriseLinux4.0
Oracle10gR2(10.2.0.1.0)
PerlwiththeArchive::Zipmodule:
External Database Setup 3

ADM Repository Reference Guide
16 VMware, Inc.
PerlisbundledwithRHEL4.0,buttheArchive::ZipmoduleforhandlingZipfilesneedstobeinstalled
manually.
ToverifythattheArchive::Zipmoduleisloaded,runthefollowing:
perl -MArchive::Zip -e 'print'
Iftheresultis:Archive::Zip module is installed,thenthemoduleisinstalledcorrectly.
Iftheresultstartswith:can't find Archive/Zip,thenitisnotinstalled.
Toinstallthis,executethefollowingcommandfromthecommandprompt,withrootpermissions:
cpan -i Archive::Zip
PerlwithExpectmodule:
Toinstall,runthefollowing:
yum install perl-Expect
MS SQL as the External Database
EnsurethesystemmeetsthefollowingrequirementswhenusingMSSQLastheexternaldatabase:
Windows2003ServicePack2
MSSQL2005
psftpinstalledandaddedtothePATHenvproperties
PerlwiththeArchive::Zipmodule
CommonPerldistributionforWindowsisActivePerlfromActiveState.ThenecessaryArchive::Zip
moduleisbundledwithActivePerl.
Installing and Configuring the External Database for Oracle
UsethefollowingprocedurestoinstallandconfiguretheexternaldatabaseforOracle.
Install the Client-Side Script
To install the client-side script
1CopytheADMexternaldatabaseinstallationfile(adm_olap_
v.X.X-XXX .zip,wherev.X.X‐XXXisthe
ADMversionandbuildnumber)fromhttp://downloads.vmware.com/ApplicationDiscoveryManager.
2LogintotheLinuxServer.
3 Changedirectoriestothelocationoftheinstallationfile.
4Unziptheadm_olap_
v.X.X-XXX .ziptoadirectoryofyourchoice.
Adirectorynamedadm_olapiscreatedwithalltheclient‐sidescriptsinit.
5 Changetheadm_olapdirectorypermissiontoallowreadaccesstoallusers.
Toenablereadpermission,inLinuxrun:
chmod 777 -R adm_olap

VMware, Inc. 17
Chapter 3 External Database Setup
Create the External Reporting Database User
To create an external reporting database user
1Switchtoauserwithoraclepermissionsforexample:
$ su - oracle
$Password:
2 Changedirectorytounzip_path/adm_olap/schema/oracle/:
cd unzip_path/adm_olap/schema/oracle/
whereunzip_path/adm_olap/schema/oracle/isthedirectoryinwhichthe
adm_olap_
v.X.X-XXX .zipfilewasextracted.
3LogintotheSQLplusserver:
$ sqlplus '/as sysdba'
SQL*Plus: Release 10.1.0.2.0 - Production on Wed Dec 12 14:17:01 2007
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Release 10.1.0.2.0 - Production
4Verifythattheinstanceisrunning,thedatabaseismounted,andthelistenerisstarted.
5RuntheSQLscripttocreatetheadm_olapuser:
sql> @create_olap_user.sql
User created.
Grant succeeded.
6Typequittoexitthesqlplusprompt.
Create the adm_olap Tables
To create the adm_olap tables
1LogintoSQLplusasadm_olap:
sqlplus adm_olap/adm_olap
2RuntheSQLscripttocreatethetables:
SQL> @create_tables.sql
3Typequittoexitthesqlplusprompt.
NOTEYoumusthavedatabaseadministratorpermissionstocreateanadm_olapuserandhave
$ORACLE_HOME/bin dirinthePATHtoinstallandconfigurethehostonwhichtheexternaldatabaseis
installed.
NOTETheusercreatedheremustbethesameuserthatwasdefinedwhensettinguptheExternalReports
SchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationdefinestheFTPserverwhere
theextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.
NOTETheadm_olapschemacreationismeanttobemanagedbytheclientDatabaseAdministrator(DBA).
SimpleSQLscriptsareprovidedtosupportthebasicADMtables.Tosupportadditionalinformationadd
externaltables.ChangestothetablesprovidedwithADMareoverwrittenwitheachload.Thescriptsare
locatedwheretheadm_olap_
v.X.X-XXX .zipfilewasextractedfollowedby/schema/oracle.
NOTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.

ADM Repository Reference Guide
18 VMware, Inc.
Configure the Synchronization Process
To configure the synchronization process
1Configurethesync.propertiesfilelocatedintheadm_olapdirectory:
aMakeacopyofthesync.properties.examplefileandnameitsync.properties:
cp sync.properties.example sync.properties
bInthesync.propertiesfile,modifytheFTPinformation.Enterthepropercredentials,hostremote
directory,andwhetherornottodeletethefilesfromtheFTPserverafterthesynchronizationprocess
completes:
ftp.user=ftp-user
ftp.password=ftp-password
ftp.host=ftp-hostname
ftp.dir=remote-dir
ftp.local.dir=tmp
# filter FTP files: consider only files starting with the prefix.
ftp.file.prefix=adm_olap
# delete files from FTP when done?
ftp.delete.files=true
cInthesync.propertiesfile,ensurethattheloaderinformationpointstotheOracle:
loader.exec=./load_oracle.pl
loader.dir=load
loader.data.dir=data
dInthesync.propertiesfile,modifythearchivingifnecessary:
# archive option will save a local copy of the compressed data at the specified directory
archive=true
archive.dir=archive
archiveandarchive.dirdefineswhetherornottostorethezippedfileslocallyforhistory
tracking.
Youcanaddthehooksifnecessary.hook.before.load=andhook.after.load=allowcustom
behaviorjustbeforethedataloadingandaftertheloadingiscomplete.Suchhooksareusedtoadd
ordropindices,toaddclientspecificdataforloadingtogetherwithADMdata,oranyotherdesired
actions.Thepropertycontainsthepathtoanexecutablescript:
# This can be used, for example, to remove indexes before the data loading
# and re-create the indexes after the load is complete.
#hook.before.load=
#hook.after.load=
2ConfigurethedatabaseloaderforOracle.
TheOracleloaderscriptisconfiguredusingtheoracle.propertiesfile,thatislocatedinthe
unzip_path/adm_olap/load/directory.Anexamplefile,oracle.properties.example,hasbeen
providedinunzip_path/adm_olap/load/:
aMakeacopyoftheoracle.properties.examplefileandnameitoracle.properties:
cp oracle.properties.example oracle.properties
bIfyouhaddefinedacustomadm_olapusernameandpasswordwhenyouhadcreatedthedatabase
userasdescribedin“CreatetheExternalReportingDatabaseUser”onpage 17,thenchangetheuser
nameandpasswordcredentialsaccordingly:
NOTEAnexamplefile,sync.properties.example,isprovidedinadm_olap,touseasatemplateto
configurethesynchronizationprocess.
NOTEUsethesameusercredentialswhensettinguptheExternalReportsSchemeConfiguration
policyasdescribedin“CreatingtheExternalReportsSchemeConfigurationPolicy”onpage 11

VMware, Inc. 19
Chapter 3 External Database Setup
user.id=adm_olap/adm_olap
c Changethedelete.data.filesparameterto=trueifyouwanttodeletethedatafilesafterthey
areloaded.Ifyoukeepthedefault,youneedadditionaldataspacethandefinedin“ExternalDatabase
SystemRequirements”onpage 15:
delete.data.files=false
3Loadthetimedata.
Thecurrentadm_olapschemahasatimedimensiontablethatisstatic.Fillthetimetableonceandleave
itunchangedthereafter.Performthefollowingstepsbeforetheloaderfirstrun:
cd adm_olap
unzip static_data/time.csv.zip -d data/
Thetime.csvdataisloadedthenexttimethesynchronizationprocessruns.
4Testtheconfigurationtoensurethatyouhaveinstalledandconfiguredtheclientcorrectly:
aRunacompletesynchronizationfromtheADMConsoleasdescribedin“Runningthe
SynchronizationProcessNow”onpage 13.
bAftertheuploadcompletes,loginasauserwithOraclepermissions,onthesystemonwhichthe
databaseisinstalled.
c Changedirectoriestounzip_path/adm_olap/andrunthesynchronizationprocess:
cd <unzip_path>/adm_olap/
chmod 755 sync_adm_olap.pl
$ ./sync_adm_olap.pl
5SchedulethesynchronizationprocessonLinux.
aLoginasauserwithoraclepermissionsandenter:
crontab -e
bVerifythefollowinginformation.Ithastobepartofthecrontabforittorunproperly:
PATH=... <oracle home full path/bin>
ORACLE_SID=<>
ORACLE_HOME=<>
<cron expression><install dir>/adm_olap/sync_adm_olap.pl >>
<install_dir>/adm_olap/log/sync.log 2>&1
ThefollowingisanexampleofacronentryinLinux,wheretheprocessisscheduledtorunafterevery15
minutes:
PATH=...
ORACLE_SID=...
ORACLE_HOME=...
*/15 * * * * <install dir>/adm_olap/sync_adm_olap.pl >> <install dir>/adm_olap/log/sync.log
2>&1
NOTEForsecureFTP,usethesync_adm_olap_sftp_oracle.plscriptinsteadof
sync_adm_olap.pl
NOTEForsecureFTP,usethesync_adm_olap_sftp_oracle.plscriptinsteadofsync_adm_olap.pl
andformoreinformationaboutcronexpressionpleasecontactyourunixadmin.

ADM Repository Reference Guide
20 VMware, Inc.
Installing and Configuring the External Database for MS SQL
UsethefollowingprocedurestoinstallandconfiguretheexternaldatabaseforMSSQL.
Install the Client-Side Scripts
To install the client-side script
1CopytheADMexternaldatabaseinstallationfile(adm_olap_ v.X.X-XXX .zip)from
http://downloads.vmware.com/ApplicationDiscoveryManager.
2Unziptheadm_olap_
v.X.X-XXX .ziptoadirectoryofyourchoice.
Adirectorynamedadm_olapiscreatedwithalltheclient‐sidescriptsinit.
Install the External Database for MS SQL Server
To install the external database for MS SQL
1FromtheWindowsStartmenu,selectRunandtypecmd.Thecommandpromptappears.
2 Changedirectoriestounzip_path/adm_olap/schema/sqlserver/:
cd <path>\adm_olap\schema\sqlserver
3Runthecreate_database.sqlscripttocreatetheADMexternaldatabase:
sqlcmd -S <serverName> -i create_database.sql
4Runthecreate_olap_schema.sqlscripttocreatetheadm_olap schema:
sqlcmd -S <serverName> -i create_olap_schema.sql
5Runthecreate_adm_olap_login.sqlscripttocreatethelogin:
sqlcmd -S <serverName> -i create_adm_olap_login.sql
6Runthecreate_user_for_login.sqlscripttocreatetheloginuser:
sqlcmd -S <serverName> -i create_user_for_login.sql
7Runthecreate_tables.sqlscripttocreatetheadm_olaptables:
sqlcmd -S <serverName> -i create_tables.sql
NOTEYoumusthaveadministratorprivilegestoinstalltheclient‐sidescriptsonWindows.
NOTEYoucanuseeitherSQLServerManagementStudioorSQLCMDcommandtoruntheinstallation
scripts.ThefollowingstepsdemonstratethecommandsusingSQLCMD.
NOTETheusercreatedhere,mustbethesameuserthatwasdefinedwhensettinguptheExternal
ReportsSchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationpolicydefinestheFTP
serverwheretheextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.
NOTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.