VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Manuel d'utilisateur télécharger pdf (Page 22)

ADM Repository Reference Guide

22 VMware, Inc.

2ConfigurethedatabaseloaderforMSSQLServers.

TheSQLServerloaderscriptisconfiguredusingthesqlserver.propertiesfile,thatislocatedinthe

unzip_path/adm_olap/load/directory.Anexamplefile,sqlserver.properties.example,is

providedinunzip_path/adm_olap/load/:

aMakeacopyofthesqlserver.properties.examplefileandnamethefileas

sqlserver.properties.

b 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is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.Tohavetheloaderloadthetimedatauponinitiation:

Unzipthestatic_data/time.csv.zipfileintotheunzip_path/adm_olap/datadirectory.

Thetime.csvdataisloadedthenexttime

thesynchronizationprocessruns.

4Testyourconfiguration:

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administratorpermissions,onthesystemonwhich

thedatabaseisinstalled.

cFromtheWindowsStartmenu,selectRun

andtypecmd.Thecommandpromptappears.

d Changedirectoriestounzip_path\adm_olap\andrunthesynchronizationprocess:

cd <unzip_path>\adm_olap\

<perl_dir>\bin\perl.exe <install_dir>\adm_olap\sync_adm_olap.pl

5SchedulethesynchronizationprocesstorunautomaticallyfortheMSSQLdatabase:

aFromtheWindowsStartmenu,navigatetoSetting>ControlPanel>Scheduledtasks.

bDouble‐clickAddScheduledTasktoopentheScheduleTaskWizard.

cClickNexttoselectthetaskyouarescheduling.

dBrowsetotheunzip_path/adm_olapdirectoryand

selectsync_adm_olap.pl.

eEnteranameforthesyn_adm_olap.pltaskschedule.

f SelecthowoftenyouwanttorunthetaskfromtheoptionsandclickNext.

gDependingontheintervalselected,definethetime,days,andthedatetostartthetask.

OTEForsecureFTP,usethesync_adm_olap_sftp_sqlserver.plscriptinsteadof

sync_adm_olap.pl

Toavoididkeyverificationforthefirsttimebycreatingtheidkey,runpsftpmanuallyagainstthe

FTPserverusingcommandlinepsftp -pw password user@host.Typeyeswhenprompted.

OTEFortheWindowsscheduledtaskfunctionality,theflexibilitytoscheduletasksislimited.The

schedulesavailablearedaily,weekly,monthly,andonetimeonly,whenthecomputerstarts,orwhenthe

userlogsin.

OTEForsecureFTP,usethesync_adm_olap_sftp_sqlserver.plscriptinsteadof

sync_adm_olap.pl

1 2 ... 17 18 19 20 21 22 23 24 25 26 27 ... 43 44

Commentaires sur ces manuels

Pas de commentaire

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY Manuel d'utilisateur Page 22

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel de base de données VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1.1 - RESPOSITORY