VMware VCENTER APPLICATION DISCOVERY MANAGER 6.1 - REPOSITORY Manual do Utilizador descarregar pdf (Página 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/:

<path>

\adm_olap\schema\sqlserver

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

sqlcmd -S

-i create_database.sql

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

sqlcmd -S

-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

-i create_user_for_login.sql

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

sqlcmd -S

-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 ... 41 42

Comentários a estes Manuais

Sem comentários

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

Comentários a estes Manuais

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