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

ADM Repository Reference Guide

20 VMware, Inc.

Installing and Configuring the External Database for MS SQL

UsethefollowingprocedurestoinstallandconfiguretheexternaldatabaseforMSSQL.

Install the Client-Side Scripts

To install the client-side script

1CopytheADMexternaldatabaseinstallationfile(adm_olap_

v.X.X-XXX

.zip)from

http://downloads.vmware.com/ApplicationDiscoveryManager.

2Unziptheadm_olap_

v.X.X-XXX

.ziptoadirectoryofyourchoice.

Adirectorynamedadm_olapiscreatedwithalltheclient‐sidescriptsinit.

Install the External Database for MS SQL Server

To install the external database for MS SQL

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

2 Changedirectoriestounzip_path/adm_olap/schema/sqlserver/:

cd <path>\adm_olap\schema\sqlserver

3Runthecreate_database.sqlscripttocreatetheADMexternaldatabase:

sqlcmd -S <serverName> -i create_database.sql

4Runthecreate_olap_schema.sqlscripttocreatetheadm_olap schema:

sqlcmd -S <serverName> -i create_olap_schema.sql

5Runthecreate_adm_olap_login.sqlscripttocreatethelogin:

sqlcmd -S <serverName> -i create_adm_olap_login.sql

6Runthecreate_user_for_login.sqlscripttocreatetheloginuser:

sqlcmd -S <serverName> -i create_user_for_login.sql

7Runthecreate_tables.sqlscripttocreatetheadm_olaptables:

sqlcmd -S <serverName> -i create_tables.sql

NOTEYoumusthaveadministratorprivilegestoinstalltheclient‐sidescriptsonWindows.

NOTEYoucanuseeitherSQLServerManagementStudioorSQLCMDcommandtoruntheinstallation

scripts.ThefollowingstepsdemonstratethecommandsusingSQLCMD.

OTETheusercreatedhere,mustbethesameuserthatwasdefinedwhensettinguptheExternal

ReportsSchemeConfigurationpolicy.TheExternalReportsSchemeConfigurationpolicydefinestheFTP

serverwheretheextracteddatafilesaretransferredandhowoftenthesynchronizationoccurs.

OTEDonotaddconstraints.Withtheconstraintsturnedon,theloaderfailstoloadthedata.

1 2 ... 15 16 17 18 19 20 21 22 23 24 25 ... 43 44

Pas de commentaire

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