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

Application Discovery Manager
Repository Reference Guide
vCenter Application Discovery Manager 6.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-00

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 24
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 30
Change_Log 30
CPU 30
Database 31
Dependency 31
Group_Membership 32
Installed_Software 33
IP_Route 33
Java_EE 34
Network_Element 34
Network_Interface 36

ADM Repository Reference Guide
4VMware, Inc.
Port 36
Property 37
Service 37
Storage_Device 38
Switch_Address_Forwarding 38
TimeDimension 39
UsageMetric 39
Usage_Metric_Baseline 40
Virtual_System_Settings 40
5ADMCustomReports 41
CreatingCustomReports 41
HostInventory 41
ConnectionInventory 41
MostUsedServices 41
ApplicationDependency 42

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.
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
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.
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,whichisoneofthefollowing:
Idle—theprocessisidle.Nothingiscurrentlyrunning.
Complete—theADMsynchronizationiscompleteandtheFTPfilesareloadedtotheFTP
Server.
Syncinprogress—theADMsynchronizationprocessisinprogress.
ScheduledSynchronizationStatus—thestatusofthesynchronizationschedule,which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.
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.

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 24
“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)
External Database Setup 3

ADM Repository Reference Guide
16 VMware, Inc.
PerlwiththeArchive::Zipmodule:
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
bModifythefollowinginformationinthesync.propertiesfile:
iFor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
ii EnsurethattheloaderinformationpointstotheOracle:
loader.exec=./load_oracle.pl
loader.dir=load
loader.data.dir=data
iii 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.
Ifnecessaryaddthehooks: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
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
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:
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,performthefollowingstepsonthesystemonwhichthedatabaseis
installed:
iLoginasauserwithOraclepermissions.
ii 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.