
VMware, Inc. 23
Chapter 3 External Database Setup
hEntertheusercredentialsofthehostadministratortoensurethatenvironmentsettingsare
configuredcorrectly.
iIftheusernameandpasswordisrecognized,amessageisdisplayedconfirmingthetaskhasbeen
scheduled.
j SelectOpenadvancedpropertiesforthistaskwhenIclickFinishoption.
kClickFinish.
lFromtheWindowsStart
menu,navigatetoSetting>ControlPanel>Scheduledtasks.
mRight‐clickthetaskandclickProperties.ThetaskPropertiesdialogappears.
nThescriptisaPerlscriptandhastoberunbyPerl.ChangetheRunfieldtoobtainthefullpathofthe
perlexecutable.Forexample:
C:\Perl\bin\perl.exe <install_dir>\adm_olap\sync_adm_olap.pl
where:C:\Perl\bin\isthePerlinstallationdirectory.
IfPerlisinstalledinanotherlocation,besuretousethecorrectpath.
oViewtheloaderlogsunderunzip_path\adm_olap\load\sqlserver\log
Manually Loading Data to the External Database
Thedatafilesaremanuallyloadedtotheexternaldatabase.
To load the zip files manually for Oracle
1Unzipthecontentsofthezipfiletotheunzip_path/adm_olap/datadirectory:
unzip adm_olap_
v.X.X-XXX
.zip -d adm_olap/data/
2 Changedirectoriestotheloaderbasedirectoryandruntheloaderscript:
cd <unzip_path>/adm_olap/load/
./load_oracle.pl
To load the zip files manually for MS SQL Server
1FromWindowsExplorer,copytheadm_olap_
v.X.X-XXX
.zipfiletounzip_path\adm_olap\data\
folder.
2Right‐clicktheadm_olap_
v.X.X-XXX
.zipfileandunzipittothesamelocation.
3FromtheWindowsStartmenu,selectRunandtypecmd.Thecommandpromptappears.
4 Changedirectoriestotheloaderbasedirectoryandruntheloaderscript:
cd <unzip_path>\adm_olap\load\
load_sqlserver.pl
Checking the Status of the External Database Load Process
Usethefollowinglogfilestocheckthestatusoftheloadprocesstotheexternaldatabase:
ForOracle,check: /unzip_path/adm_olap/load/oracle/log
ForMS.SQL,check:unzip_path\adm_olap\load\sqlserver\log
N
OTETheusercanlogintotheexternaldatabasebytypingadm_olapintheUsernameandPasswordfields.
Komentáře k této Příručce