6.2

Table Of Contents
Add an ODBC Data Source to Oracle 12c or 11g
After you add a View Composer database to an Oracle 12c or 11g instance, you must configure an ODBC
connection to the new database to make this data source visible to the View Composer service.
When you configure an ODBC DSN for View Composer, secure the underlying database connection to an
appropriate level for your environment. For information about securing database connections, see the
Oracle database documentation.
If the underlying database connection uses SSL encryption, we recommend that you configure your
database servers with SSL certificates signed by a trusted CA. If you use self-signed certificates, your
database connections might be susceptible to man-in-the-middle attacks.
Prerequisites
Verify that you completed the steps described in “Add a View Composer Database to Oracle 12c or 11g,” on
page 42 or “Use a SQL Statement to Add a View Composer Database to an Oracle Instance,” on page 42.
Procedure
1 On the View Composer database computer, select Start > Administrative Tools > Data Source (ODBC).
2 From the Microsoft ODBC Data Source Administrator wizard, select the System DSN tab.
3 Click Add and select the appropriate Oracle driver from the list.
For example: OraDb11g_home
4 Click Finish.
5 In the Oracle ODBC Driver Configuration dialog box, type a DSN to use with View Composer, a
description of the data source, and a user ID to connect to the database.
If you configured an Oracle database user ID with specific security permissions, specify this user ID.
NOTE You use the DSN when you install the View Composer service.
6 Specify a TNS Service Name by selecting the Global Database Name from the drop-down menu.
The Oracle Database Configuration Assistant specifies the Global Database Name.
7 To verify the data source, click Test Connection and click OK.
What to do next
Install the new View Composer service. See “Install the View Composer Service,” on page 45.
Configuring an SSL Certificate for View Composer
By default, a self-signed certificate is installed with View Composer. You can use the default certificate for
testing purposes, but for production use you should replace it with a certificate that is signed by a Certificate
Authority (CA).
You can configure a certificate before or after you install View Composer. In View 5.1 and later releases, you
configure a certificate by importing it into the Windows local computer certificate store on the Windows
Server computer where View Composer is, or will be, installed.
n
If you import a CA-signed certificate before you install View Composer, you can select the signed
certificate during the View Composer installation. This approach eliminates the manual task of
replacing the default certificate after the installation.
n
If you intend to replace an existing certificate or the default, self-signed certificate with a new certificate
after you install View Composer, you must import the new certificate and run the SviConfig
ReplaceCertificate utility to bind your new certificate to the port used by View Composer.
View Installation
44 VMware, Inc.