VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User guide

Brand: VMware

Model: VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY

Category: Database software

Type: User guide

This manual is also suitable for

vCenter Application Discovery Manager 6.1

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

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 24

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

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

5 ADM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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.

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

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

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

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

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/:

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

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.

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

<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/:

<path>

\adm_olap\schema\sqlserver

3Runthecreate_database.sqlscripttocreatetheADMexternaldatabase:

sqlcmd -S

-i create_database.sql

4Runthecreate_olap_schema.sqlscripttocreatetheadm_olapschema:

sqlcmd -S

-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

-i create_user_for_login.sql

7Runthecreate_tables.sqlscripttocreatetheadm_olaptables:

sqlcmd -S

-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.1 - REPOSITORY User guide

Brand: VMware

Model: VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY

Category: Database software

Type: User guide

This manual is also suitable for

vCenter Application Discovery Manager 6.1

Download PDF

report

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User guide

This manual is also suitable for

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY User guide

Related papers

Other documents