VMware vCenter Application Discovery Manager 6.1.1 User guide

Category
Database software
Type
User guide
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
2 VMware, 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:
docfeedback@vmware.com
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
AboutThisBook 5
1 Introduction 7
Overview 7
HowDataIsCollected 7
SynchronizingtheExternalDatabase 8
2 SetUptheExternalReportsSchemeConfigurationPolicy 11
SetUpandMonitortheExternalReportsSchemeConfigurationPolicy 11
CreatingtheExternalReportsSchemeConfigurationPolicy 11
ChecktheStatusoftheSynchronizationProcess 13
3 ExternalDatabaseSetup 15
ExternalDatabaseSystemRequirements 15
MinimumHardwareRequirements 15
SoftwareRequirements 15
InstallingandConfiguringtheExternalDatabaseforOracle 16
InstalltheClientSideScript 16
CreatetheExternalReportingDatabaseUser 17
Createtheadm_olapTables 17
ConfiguretheSynchronizationProcess 18
InstallingandConfiguringtheExternalDatabaseforMSSQL 20
InstalltheClientSideScripts 20
InstalltheExternalDatabaseforMS
SQLServer 20
ConfiguretheSynchronizationProcess 21
ManuallyLoadingDatatotheExternalDatabase 23
CheckingtheStatusoftheExternalDatabaseLoadProcess 23
UpgradingtheExternalDatabase 24
UpgradingforMSSQL 24
UpgradingforOracle 25
4 ADMERDSchema 27
OverviewofExternalDatabaseTables 28
DatabaseStructureandDependencies 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
4 VMware, 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
5 ADMCustomReports 41
CreatingCustomReports 41
HostInventory 41
ConnectionInventory 41
MostUsedServices 41
ApplicationDependency 42
Index 43
VMware, Inc. 5
TheVMwarevCenter™ApplicationDiscoveryManager(ADM)RepositoryReferenceGuideprovides
informationaboutsettingupandconfiguringtheADMexternalrepository.Itdescribesthetablestructureand
dependencieswithintheADMexternaldatabaseandalsoillustratesthetables.Tohelpyouwiththecustom
reports,thebookprovidesexamplesofreports
thatcanbegeneratedfromtheADMexternaldatabase.
Intended Audience
ThisdocumentispartoftheVMwarevCenterApplicationDiscoveryManagerdocumentationset,andis
intendedforusebycorporateInformationTechnology(IT)personnelwhoneedtomonitorenterprise
applicationsandresourcesandmakedecisionsaboutacquiring,allocating,andmodifyingtheseresources.
Readersofthisguideareexpectedtobefamiliar
withthesetopics:
Oracledatabase
SQL
VMware Technical Publications Glossary
VMware
®
TechnicalPublicationsprovidesaglossaryoftermsthatmightbeunfamiliartoyou.Fordefinitions
oftermsastheyareusedinVMwaretechnicaldocumentationgotohttp://www.vmware.com/support/pubs.
Document Feedback
VMwarewelcomesyoursuggestionsforimprovingourdocumentation.Ifyouhavecomments,sendyour
feedbacktodocfeedback@vmware.com.
Technical Support and Education Resources
Thefollowingsectionsdescribethetechnicalsupportresourcesavailabletoyou.Toaccessthecurrentversion
ofthisbookandotherbooks,gotohttp://www.vmware.com/support/pubs.
Online and Telephone Support
Touseonlinesupporttosubmittechnicalsupportrequests,viewyourproductandcontractinformation,and
registeryourproducts,gotohttp://www.vmware.com/support.
Customerswithappropriatesupportcontractsshouldusetelephonesupportforthefastestresponseon
priority1issues.Gotohttp://www.vmware.com/support/phone_support.
Support Offerings
TofindouthowVMwaresupportofferingscanhelpmeetyourbusinessneeds,goto
http://www.vmware.com/support/services.
About This Book
ADM Repository Reference Guide
6 VMware, Inc.
VMware Professional Services
VMwareEducationServicescoursesofferextensivehandsonlabs,casestudyexamples,andcoursematerials
designedtobeusedasonthejobreferencetools.Coursesareavailableonsite,intheclassroom,andlive
online.Foronsitepilotprograms andimplementationbestpractices,VMwareConsultingServicesprovides
offeringsto helpyouassess,plan,
build,andmanageyourvirtualenvironment.Toaccessinformationabout
educationclasses,certificationprograms,andconsultingservices,gotohttp://www.vmware.com/services.
VMware, Inc. 7
1
ThischapterintroducestheVMwarevCenter™ApplicationDiscoveryManager(ADM)repositoryand
providesanoverviewthatincludesdescriptionsofdatacollection,tabletypes,andkeyfields.
Thischapterincludesthefollowingtopics:
“Overview”onpage 7
“SynchronizingtheExternalDatabase”onpage 8
Overview
TheADMprovidesstandardreportsbasedonthedatacollectedandstoredintheADMRepository.The
schemaofthenewADMExternalDatabaseissimpletounderstandandallowsyoutowritereportingqueries
overitwithoutdisruptingtheperformanceoftheotherADMservices.
How Data Is Collected
TheADMcollects,manages,andstoresdatathroughthecomponentslistedinTable 11.
Figure 11illustrateshowdataiscollectedandstoredintheADMdatabase.
Introduction
1
Table 1-1. ADM Components
Component Description
ActiveDiscovery‐
Unix
Collectsdatafromtheconfigurationobjectsinyourdatacenter.Thefollowingdiscoverytypes
apply:
IPdiscovery:DetectshostsorotherconfigurationitemswithaspecificIPaddresswhen
passivediscoveryfailstodiscoverthem.
Detaildiscovery:ExtendstheinformationobtainedusingpassiveandIPdiscovery.Ituses
commonnetworkprotocolstoremotelyqueryserversinthemanagednetworkandobtains
supplementaryinformationaboutnetworkhoststhatisaddedtothedatabase.
ActiveDiscovery‐
Windows
AdiscoveryenginethatusesWMIbaseddiscoverypoliciesforperformingactive
discoveryon
Windowsmachines.
PassiveDiscovery Passivelyobservesthenetworktrafficbyperformingadeeppacketanalysistodiscover
applicationsandcomponentrelationshipsinphysicalandvirtualenvironments.
Passivediscoveryalsoallowsyoutodothefollowing:
Mapdependencies.
Counttheactivityofthesedependencies.
Identifyservices.
Aggregator Receivesdatafromthediscoverycomponentsandreconcilesthedatabeforetransferringittothe
databasecomponent.TheaggregatoralsoprovidestheuserinterfaceforusingADMandisthe
integrationpointforvariousintegrations,forexample,ERDB.
Database AnOracleRDBMSusedtostorediscovereddataandADMconfiguration.
ADM Repository Reference Guide
8 VMware, Inc.
Figure 1-1. Collection, Management, and Storage of ADM Data
ThedatastoredintheADMdatabasecannotbecustomizedormanipulatedforcreatingcustomreports.
Therefore,ADMprovidesfunctionalityforexportingthedataintoanADMexternalrepository,fromwhich
customreportsarecreated.
Thedatatransferredtotheexternalrepositoryisnotrealtimedata.Itissynchronized
atregularintervalsas
definedintheExternalReportsSchemeConfigurationpolicy.
Synchronizing the External Database
Figure 12illustrateshowtheADMexternaldatabaseissynchronizedwiththeADMrepositorythroughthe
ETL(ExtractTransformLoad)process.ExtractionandtransformationisdonethroughADMandloadingis
donebytheadm_olapcomponentontheexternaldatabasehost.
Figure 1-2. External Database Synchronization Process
Thesynchronizationprocesscomprisesofthefollowingsteps:
1Thesynchronization
istriggeredaccordingtothesettingsintheExternalReportsSchemeConfiguration
policy.
2ADMchecksthestatusofthereplicationtoensurethattheprevioussynchronizationandthatanyreport
requestsagainsttheexternaldatabasehascompleted.
3ADMextractsthedatafilesfortheloadprocessasfollows:
aTheReportSchema
isextractedandtranslatedto.csvfiles.
bThedatafilesarecompressedandplacedtogetherinasingleZiparchive.
cTheZipfileisuploadedtotheassignedFTPserver.
4ThesystemrunningtheexternaldatabaseperiodicallycheckstheFTPserverfordatafilesbasedonthe
synchronizationscheduledefinedonthe
externaldatabasesystem.
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
5Whenadatafileisfound,thefollowingprocesstakesplaceontheexternaldatabasesystem:
aThelatestZipfileisdownloaded.
bTheZipfileisextractedtothedecompressed.csvdatafiles.
cThedatabaseloadingisperformedusingthedatabasespecificloader.
Performance and Scalability
Thefollowingstepsindicatetheamountoftimerequiredtocompleteeachprocess:
Extractionandflatfilecreation:ThissteputilizestheADMresourcestothemaximum.Therefore,itis
scheduledtoextractthedataatnightorsomeotherperiodoflowresourceconsumptionandtoallow
enoughtimetocomplete.
Transferringthedatafiles:ThisstepinvolvesuploadingoftheflatfilesfromtheADMRepository
appliancetotheexternaldatabasehost.ThisstepdoesnotconsumemanyADMresources.However,the
transfertimemightvarygreatlybecauseofnetworkconditionsattheexternaldatabasehostsite.
Loadingthedatabase:Thisstepmighttakefewhourstocomplete.
ADM Repository Reference Guide
10 VMware, Inc.
VMware, Inc. 11
2
TheADMConsoleprovidesthenecessaryfunctionalityto:
“SetUpandMonitortheExternalReportsSchemeConfigurationPolicyonpage 11
“ChecktheStatusoftheSynchronizationProcess”onpage 13
Set Up and Monitor the External Reports Scheme Configuration Policy
TheExternalReportsSchemeConfigurationpolicydefinestheFTPsitewherethedatabasefilesaresentand
howoftenextractionisperformed.TheExternalReportsSchemeConfigurationprovidesfunctionalityfor
runningthepolicyautomaticallyatascheduledtime,orstartingthesynchronizationnow.
Thispolicyonlycontrolsthefollowingstepsof
thesynchronizationprocess:
Databasedataextraction
Databasefilescreation
PostingthedatabasefilestotheFTPsite
YoumustconfiguretheexternaldatabasehosttoretrievethedatafilesfromtheFTPsiteandcompletethe
synchronizationprocess.Chapter 3,“ExternalDatabaseSetup,”onpage 15providescompletedetails.
Creating the External Reports Scheme Configuration Policy
To set up the External Reports Scheme Configuration policy
1LogintotheADMConsoleasadminuser.
2FromtheADMConsole,navigatetoConnectors>ReportsandclickConfigurationintheleftpane.
Set Up the External Reports Scheme
Configuration Policy
2
ADM Repository Reference Guide
12 VMware, Inc.
3InthePublishertab,entertheFTPsitetowhichthedatafilesarepublishedasshownbelow.
where:
TargetHost:ThesystemhostingtheFTPserver.
TargetDirectory:ThedirectoryontheFTPserverhosttowhichthefilesaresent.
UserName:ThenameofauserwithaccesstotheFTPserver.
Password:Thepasswordassociatedwiththeusername.
TransportChannel:AllowsusertochoosebetweenFTPandSecuredFTP(SFTP)fordataupload
fromthedropdownmenu.
NumberofRetries:Thenumberoftimesthesynchronizationprocessattempts,incaseoffailure.
4ClickTestConnectiontotesttheconnectiontotheFTPserverbasedonthepublishingcredentialyou
entered.IfyouhaveenteredinvalidcredentialsoriftheFTPserverisdown,thetesttimesoutor
fails.
5ClickCreatepolicy.Ifyouhavepreviouslydefinedthepolicy,clickUpdate.
Running the Synchronization Process at Scheduled Times
To schedule the synchronization process
1AftercreatingtheExternalReportsSchemeConfigurationpolicy,selecttheEnableAutomatic
Schedulingoptionatthebottomofthepageasshownbelow.
2IntheSchedulingtab,selectoneormoredaysoftheweektoschedulethestartofthesynchronization.
N
OTEEnsurethattheusernameandpasswordarethesame,asusedtoconfigurethe
synchronizationontheexternaldatabasesystemasdescribedin“InstallingandConfiguringthe
ExternalDatabaseforOracle”onpage 16forOracledatabasesuserand“InstallingandConfiguring
theExternalDatabaseforMSSQL”onpage 20
forMSSQLServerusers.
VMware, Inc. 13
Chapter 2 Set Up the External Reports Scheme Configuration Policy
3Enterthetimeofdaythesynchronizationoccurs.
IntheaboveexamplethesynchronizationautomaticallybeginseverySaturdayat11:00A.M.
4ClickUpdatetosavethesetting.
Running the Synchronization Process Now
To start the synchronization process on demand
AftercreatingtheExternalReportsSchemeConfigurationpolicy,clickCompleteSynchronizationunderthe
Actionsmenuintheleftpane.
Check the Status of the Synchronization Process
TheADMConsoledisplaysthestatusoftheExternalReportsSchemaConfigurationpolicythatincludesthe
followingsynchronizationsteps:
Extractionofthedatabasefile.
Creationofthedatabasefile.
PostingthedatabasefilestotheFTPsite.
To check the status of the synchronization process
1LogintotheADMConsoleasadminuser.
2FromtheADMConsole,navigatetoConnectors>ReportsandclickStatusintheleftpane.
3Thedisplaypaneliststhefollowingparameters:
LastSync.Time:ThelasttimetheexternaldatabasewassynchronizedwiththeADMrepository.The
timeisbasedonthelocationoftheappliance.
SynchronizationStatus:Thestatusofthesynchronizationprocess.
ScheduledSynchronizationStatus:thestatusofthesynchronizationschedule.
PopulatedElements:Liststheelementsthatwerepopulatedtotheexternaldatabaseduringthelast
synchronization.
Count:Givesthenumberofelementsthatwerepopulatedtotheexternaldatabase.
4ClickLogintheleftpanetoviewthemessages,describingtheeventsofthesynchronizationprocess.
I
MPORTANTIfanexistingsynchronizationprocesshasnotcompleted,thenADMdoesnotstartthe
synchronizationprocess.
NOTEStatusofthesynchronizationprocessisoneofthefollowing:
Idle:Theprocessisidle.Nothingiscurrentlyrunning.
Syncinprogress:TheADMsynchronizationprocessisinprogress.
Complete:TheADMsynchronizationiscompleteandtheFTPfilesareloadedtotheFTPServer.
N
OTEStatusofthesynchronizationscheduleisoneofthefollowing:
Active:Thesynchronizationscheduleissetandrunsatthescheduledtime.
NotActive:Thereisnoscheduleassociatedwiththepolicy.
ADM Repository Reference Guide
14 VMware, Inc.
VMware, Inc. 15
3
Tousetheexternaldatabasefunctionalityyouneedtoperformthefollowingsteps:
“ExternalDatabaseSystemRequirements”onpage 15
“InstallingandConfiguringtheExternalDatabaseforOracle”onpage 16
“InstallingandConfiguringtheExternalDatabaseforMSSQL”onpage 20
“ManuallyLoadingDatatotheExternalDatabaseonpage 23
“CheckingtheStatusoftheExternalDatabaseLoadProcess”onpage 23
“UpgradingtheExternalDatabase”onpage 24
External Database System Requirements
ToincorporateanexternaldatabaseintoyourADMenvironment,youneedthefollowingcomponents:
AccesstoanFTPserver.
Theexternalreportingdatabaseclienthastobeinstalledonthesameserverasthedatabase.
Thehardwareandsoftwarerequirementsasfollows.
Minimum Hardware Requirements
Ensurethatyoursystemmeetsthefollowinghardwarerequirements:
2GBmemory.
Dualcore1.8GHZCPU.
500MBfortheclientinstallation.IfthedataZipfilesareretainedontheserver,morediskspaceisneeded.
1GBforthedatabaseinstance.
Software Requirements
Thesoftwarerequirementsforeachtypeofdatabaseareasfollows:
Oracle as the External Database
EnsurethesystemmeetsthefollowingrequirementswhenusingOracleasexternaldatabase:
RedHatEnterpriseLinux4.0
Oracle10gR2(10.2.0.1.0)
PerlwiththeArchive::Zipmodule:
External Database Setup
3
ADM Repository Reference Guide
16 VMware, Inc.
PerlisbundledwithRHEL4.0,buttheArchive::ZipmoduleforhandlingZipfilesneedstobeinstalled
manually.
ToverifythattheArchive::Zipmoduleisloaded,runthefollowing:
perl -MArchive::Zip -e 'print'
Iftheresultis:Archive::Zip module is installed,thenthemoduleisinstalledcorrectly.
Iftheresultstartswith:can't find Archive/Zip,thenitisnotinstalled.
Toinstallthis,executethefollowingcommandfromthecommandprompt,withrootpermissions:
cpan -i Archive::Zip
PerlwithExpectmodule:
Toinstall,runthefollowing:
yum install perl-Expect
MS SQL as the External Database
EnsurethesystemmeetsthefollowingrequirementswhenusingMSSQLastheexternaldatabase:
Windows2003ServicePack2
MSSQL2005
psftpinstalledandaddedtothePATHenvproperties
PerlwiththeArchive::Zipmodule
CommonPerldistributionforWindowsisActivePerlfromActiveState.ThenecessaryArchive::Zip
moduleisbundledwithActivePerl.
Installing and Configuring the External Database for Oracle
UsethefollowingprocedurestoinstallandconfiguretheexternaldatabaseforOracle.
Install the Client-Side Script
To install the client-side script
1CopytheADMexternaldatabaseinstallationfile(adm_olap_
v.X.X-XXX
.zip,wherev.X.XXXXisthe
ADMversionandbuildnumber)fromhttp://downloads.vmware.com/ApplicationDiscoveryManager.
2LogintotheLinuxServer.
3 Changedirectoriestothelocationoftheinstallationfile.
4Unziptheadm_olap_
v.X.X-XXX
.ziptoadirectoryofyourchoice.
Adirectorynamedadm_olapiscreatedwithalltheclientsidescriptsinit.
5 Changetheadm_olapdirectorypermissiontoallowreadaccesstoallusers.
Toenablereadpermission,inLinuxrun:
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
1Switchtoauserwithoraclepermissionsforexample:
$ su - oracle
$Password:
2 Changedirectorytounzip_path/adm_olap/schema/oracle/:
cd unzip_path/adm_olap/schema/oracle/
whereunzip_path/adm_olap/schema/oracle/isthedirectoryinwhichthe
adm_olap_
v.X.X-XXX
.zipfilewasextracted.
3LogintotheSQLplusserver:
$ 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
4Verifythattheinstanceisrunning,thedatabaseismounted,andthelistenerisstarted.
5RuntheSQLscripttocreatetheadm_olapuser:
sql> @create_olap_user.sql
User created.
Grant succeeded.
6Typequittoexitthesqlplusprompt.
Create the adm_olap Tables
To create the adm_olap tables
1LogintoSQLplusasadm_olap:
sqlplus adm_olap/adm_olap
2RuntheSQLscripttocreatethetables:
SQL> @create_tables.sql
3Typequittoexitthesqlplusprompt.
N
OTEYoumusthavedatabaseadministratorpermissionstocreateanadm_olapuserandhave
$ORACLE_HOME/bin dirinthePATHtoinstallandconfigurethehostonwhichtheexternaldatabaseis
installed.
N
OTETheusercreatedheremustbe thesameuserthatwasdefinedwhensettinguptheExternalReports
SchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationdefinestheFTPserverwhere
theextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.
NOTETheadm_olapschemacreationismeanttobemanagedbytheclientDatabaseAdministrator(DBA).
SimpleSQLscriptsareprovidedtosupportthebasicADMtables.Tosupportadditionalinformationadd
externaltables.ChangestothetablesprovidedwithADMareoverwrittenwitheachload.Thescriptsare
locatedwhere
theadm_olap_
v.X.X-XXX
.zipfilewasextractedfollowedby/schema/oracle.
N
OTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.
ADM Repository Reference Guide
18 VMware, Inc.
Configure the Synchronization Process
To configure the synchronization process
1Configurethesync.propertiesfilelocatedintheadm_olapdirectory:
aMakeacopyofthesync.properties.examplefileandnameitsync.properties:
cp sync.properties.example sync.properties
bInthesync.propertiesfile,modifytheFTPinformation.Enterthepropercredentials,hostremote
directory,andwhetherornottodeletethefilesfromtheFTPserverafterthesynchronizationprocess
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
cInthesync.propertiesfile,ensurethattheloaderinformationpointstotheOracle:
loader.exec=./load_oracle.pl
loader.dir=load
loader.data.dir=data
dInthesync.propertiesfile,modifythearchivingifnecessary:
# archive option will save a local copy of the compressed data at the specified directory
archive=true
archive.dir=archive
archiveandarchive.dirdefineswhetherornottostorethezippedfileslocallyforhistory
tracking.
Youcanaddthehooksifnecessary.hook.before.load=andhook.after.load=allowcustom
behaviorjustbeforethedataloadingandaftertheloadingiscomplete.Suchhooksareusedtoadd
ordropindices,toadd
clientspecificdataforloadingtogetherwithADMdata,oranyotherdesired
actions.Thepropertycontainsthepathtoanexecutablescript:
# 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=
2ConfigurethedatabaseloaderforOracle.
TheOracleloaderscriptisconfiguredusingtheoracle.propertiesfile,thatislocatedinthe
unzip_path/adm_olap/load/directory.Anexamplefile,oracle.properties.example,hasbeen
providedinunzip_path/adm_olap/load/:
aMakeacopyoftheoracle.properties.examplefileandnameitoracle.properties:
cp oracle.properties.example oracle.properties
bIfyouhaddefinedacustomadm_olapusernameandpasswordwhenyouhadcreatedthedatabase
userasdescribedin“CreatetheExternalReportingDatabaseUseronpage 17,thenchangetheuser
nameandpasswordcredentialsaccordingly:
N
OTEAnexamplefile,sync.properties.example,isprovidedinadm_olap,touseasatemplateto
configurethesynchronizationprocess.
NOTEUsethesameusercredentialswhensettinguptheExternalReportsSchemeConfiguration
policyasdescribedin“CreatingtheExternalReportsSchemeConfigurationPolicyonpage 11
VMware, Inc. 19
Chapter 3 External Database Setup
user.id=adm_olap/adm_olap
c Changethedelete.data.filesparameterto=trueifyouwanttodeletethedatafilesafterthey
areloaded.Ifyoukeepthedefault,youneedadditionaldataspacethandefinedin“ExternalDatabase
SystemRequirements”onpage 15:
delete.data.files=false
3Loadthetimedata.
Thecurrentadm_olapschemahasatimedimensiontablethatisstatic.Fillthetimetableonceandleave
itunchangedthereafter.Performthefollowingstepsbeforetheloaderfirstrun:
cd adm_olap
unzip static_data/time.csv.zip -d data/
Thetime.csvdataisloadedthenexttimethesynchronizationprocessruns.
4Testtheconfigurationtoensurethatyouhaveinstalledandconfiguredtheclientcorrectly:
aRunacompletesynchronizationfromtheADMConsoleasdescribedin“Runningthe
SynchronizationProcessNow”onpage 13.
bAftertheuploadcompletes,loginasa
userwithOraclepermissions,onthesystemonwhichthe
databaseisinstalled.
c Changedirectoriestounzip_path/adm_olap/andrunthesynchronizationprocess:
cd <unzip_path>/adm_olap/
chmod 755 sync_adm_olap.pl
$ ./sync_adm_olap.pl
5SchedulethesynchronizationprocessonLinux.
aLoginasauserwithoraclepermissionsandenter:
crontab -e
bVerifythefollowinginformation.Ithastobepartofthecrontabforittorunproperly:
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
ThefollowingisanexampleofacronentryinLinux,wheretheprocessisscheduledtorunafterevery15
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ForsecureFTP,usethesync_adm_olap_sftp_oracle.plscriptinsteadof
sync_adm_olap.pl
N
OTEForsecureFTP,usethesync_adm_olap_sftp_oracle.plscriptinsteadofsync_adm_olap.pl
andformoreinformationaboutcronexpressionpleasecontactyourunixadmin.
ADM Repository Reference Guide
20 VMware, Inc.
Installing and Configuring the External Database for MS SQL
UsethefollowingprocedurestoinstallandconfiguretheexternaldatabaseforMSSQL.
Install the Client-Side Scripts
To install the client-side script
1CopytheADMexternaldatabaseinstallationfile(adm_olap_
v.X.X-XXX
.zip)from
http://downloads.vmware.com/ApplicationDiscoveryManager.
2Unziptheadm_olap_
v.X.X-XXX
.ziptoadirectoryofyourchoice.
Adirectorynamedadm_olapiscreatedwithalltheclientsidescriptsinit.
Install the External Database for MS SQL Server
To install the external database for MS SQL
1FromtheWindowsStartmenu,selectRunandtypecmd.Thecommandpromptappears.
2 Changedirectoriestounzip_path/adm_olap/schema/sqlserver/:
cd <path>\adm_olap\schema\sqlserver
3Runthecreate_database.sqlscripttocreatetheADMexternaldatabase:
sqlcmd -S <serverName> -i create_database.sql
4Runthecreate_olap_schema.sqlscripttocreatetheadm_olap schema:
sqlcmd -S <serverName> -i create_olap_schema.sql
5Runthecreate_adm_olap_login.sqlscripttocreatethelogin:
sqlcmd -S <serverName> -i create_adm_olap_login.sql
6Runthecreate_user_for_login.sqlscripttocreatetheloginuser:
sqlcmd -S <serverName> -i create_user_for_login.sql
7Runthecreate_tables.sqlscripttocreatetheadm_olaptables:
sqlcmd -S <serverName> -i create_tables.sql
NOTEYoumusthaveadministratorprivilegestoinstalltheclientsidescriptsonWindows.
NOTEYoucanuseeitherSQLServerManagementStudioorSQLCMDcommandtoruntheinstallation
scripts.ThefollowingstepsdemonstratethecommandsusingSQLCMD.
N
OTETheusercreatedhere,mustbethesameuserthatwasdefinedwhensettinguptheExternal
ReportsSchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationpolicydefinestheFTP
serverwheretheextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.
N
OTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.
  • Page 1 1
  • Page 2 2
  • Page 3 3
  • Page 4 4
  • Page 5 5
  • Page 6 6
  • Page 7 7
  • Page 8 8
  • Page 9 9
  • Page 10 10
  • Page 11 11
  • Page 12 12
  • Page 13 13
  • Page 14 14
  • Page 15 15
  • Page 16 16
  • Page 17 17
  • Page 18 18
  • Page 19 19
  • Page 20 20
  • Page 21 21
  • Page 22 22
  • Page 23 23
  • Page 24 24
  • Page 25 25
  • Page 26 26
  • Page 27 27
  • Page 28 28
  • Page 29 29
  • Page 30 30
  • Page 31 31
  • Page 32 32
  • Page 33 33
  • Page 34 34
  • Page 35 35
  • Page 36 36
  • Page 37 37
  • Page 38 38
  • Page 39 39
  • Page 40 40
  • Page 41 41
  • Page 42 42
  • Page 43 43
  • Page 44 44

VMware vCenter Application Discovery Manager 6.1.1 User guide

Category
Database software
Type
User guide

Ask a question and I''ll find the answer in the document

Finding information in a document is now easier with AI