Specifications

Table Of Contents
View Manager Administration Guide
140 VMware, Inc.
7EnsurethattheConnecttoSQLServertoobtaindefaultsettingsforthe
additionalconfigurationoptionscheckboxisselectedandselectoneofthe
followingoptions:
IfyouareusinglocalSQLServer,selectWindowsNTauthentication.Itisalso
knownas“trustedauthentication”andissupportedonlyiftheSQLServeris
runningonthevCenterServerhost.
IfyouareusingremoteSQLServer,selectSQLServerauthentication.
WindowsNTauthenticationisnotsupportedonremoteSQLServer.
ClickNext.
8 SelecttheChangethedefaultdatabasetocheckboxandselectthenameofthe
databaseyouhavecreatedforViewComposerfromtheassociatedlist(inthis
example,ViewComposer).ClickNext.
9ClickFinish>OK.
10 ClickOKtoclosetheMicrosoftODBCDataSourceAdministratorwizard.
Creating an Oracle 9i Database and Data Source for View
Composer
ThefollowinginstructionsdescribehowtoaddanewViewComposerdatabasetoan
existingOracle9iinstanceandmakethisdatasourcevisibletoallothercomponents
runningonthehostsystem.
TheseinstructionsassumethatOracle9iisinstalledonthevCenterServerhost.The
instructionsalsoassumethat
youareconfiguringthedatabaseonWindowsServer2003
SP2orhigher.SomestepsaredifferentifyouconfiguretheODBCdatasourceona
WindowsXPProfessionalSP2host.
To add a View Composer database to Oracle 9i
1OnthevCenterServerhost,selectStart>AllPrograms>OracleOraHome92>
ConfigurationandMigrationTools>Database
ConfigurationAssistanttostart
theOracleDatabaseConfigurationAssistant.
2WhentheWelcomepageappears,clickNext.
3OntheOperationspage,selectCreateadatabaseandclickNext.
4OntheDatabaseTemplatespage,selecttheDataWarehousetemplat eandclickNext.
5OntheDatabaseIdentificationpage,enteraGlobalDatabase
NameandanOracle
SystemIdentifier(SID)prefix.
Forsimplicity,enterthesamevalueforboth.