VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual do Utilizador descarregar pdf (Página 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performthefollowingstepsonthesystemonwhichthedatabaseis

installed:

iLog

inasauserwithadministratorpermissions.

ii FromtheWindowsStartmenu,selectRunandtypecmd.Thecommandpromptappears.

iii Changedirectoriesto

unzip_path

\adm_olap\andrunthesynchronizationprocess:

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

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

sync_adm_olap.pl

Avoididkeyverificationforthefirsttimebycreatingtheidkeyasfollows:

Runpsftpmanuallyagainsttheftpserverusingcommandlinepsftp -pw

password

user@host



andthen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 ... 41 42

Comentários a estes Manuais

Sem comentários

VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual do Utilizador Página 22

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY