VMware vCenter Application Discovery Manager 6.2.2 User guide

Brand: VMware

Model: vCenter Application Discovery Manager 6.2.2

Category: Database software

Type: User guide

Application Discovery Manager

Repository Reference Guide

vCenter Application Discovery Manager 6.2.2

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-000548-02

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

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

1 Introduction 7

Overview 7

HowDataIsCollected 7

SynchronizingtheExternalDatabase 8

2 Set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

3 External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

4 ADM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

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 ADM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RepositoryReferenceGuideprovidesinformationabout

settingupandconfiguringtheApplicationDiscoveryManager(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docfeedback@vmware.com.

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

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

6 VMware, 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

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

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

8 VMware, Inc.

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

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

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

customreportsarecreated.

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

atregularintervalsas

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

Synchronizing the External Database

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

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

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

Figure 1-2. External Database Synchronization Process

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

1Thesynchronization

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

policy.

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

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

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

aTheReportSchema

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

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

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

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

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

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.

OTE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.

MPORTANT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.

OTE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

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

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

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.

OTE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.

OTE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.

OTE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:

OTE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=<>

<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

OTE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.

OTE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.

OTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.

Page is loading ...

VMware vCenter Application Discovery Manager 6.2.2 User guide

Brand: VMware

Model: vCenter Application Discovery Manager 6.2.2

Category: Database software

Type: User guide

Download PDF

report

VMware vCenter Application Discovery Manager 6.2.2 User guide

VMware vCenter Application Discovery Manager 6.2.2 User guide

Related papers

Other documents