
VMware, Inc. 21
Chapter 3 External Database Setup
Configure the Synchronization Process
To configure the synchronization process
1Configurethesync.propertiesfilelocatedintheunzip_path/adm_olapdirectory.
aMakeacopyofthesync.properties.examplefileandnameitsync.properties:
copy sync.properties.example sync.properties
bInthesync.properties file,modifytheFTPinformation.Enterthepropercredentials,host
remotedirectory,andwhetherornottodeletethefilesfromtheFTPserverafterthesynchronization
processcompletes:
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
cInthesync.propertiesfile,ensurethattheloaderinformationpointstotheMSSQLServer:
loader.exec=load_sqlserver.pl
loader.dir=load
loader.data.dir=data
where:
loader.dirandloader.execprovidethelocationandscripttorunforloadingthedata.
loader.data.diristhedatadirectorywherethedecompressedfilesarestored(relativetothe
unzip_path/adm_olapdirectory).
unzip_path/adm_olap/dataisthedefaultdirectoryandisleftunchanged.
dInthesync.propertiesfile,modifythearchivingifnecessary:
# archive option will save a local copy of the compressed data at the specified directory
archive=true
archive.dir=archive
archiveandarchive.dirdefineswhetherornottostorethezippedfileslocallyforhistory
tracking.
Youcanaddthehooksifnecessary.hook.before.load=andhook.after.load=allowcustom
behaviorjustbeforethedataloadingandaftertheloadingiscomplete.Suchhooksareusedtoadd
ordropindices,toadd
clientspecificdataforloadingtogetherwithADMdata,oranyotherdesired
actions.Thepropertycontainsthepathtoanexecutablescript:
# 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=
NOTEAnexamplefile,sync.properties.example,isprovidedinunzip_pathadm_olaptouseasa
templateforconfiguring.
NOTEUsethesameusercredentialswhensettinguptheExternalReportsSchemeConfiguration
policyasdescribedin“CreatingtheExternalReportsSchemeConfigurationPolicy”onpage 11
Comentários a estes Manuais