7.0

Table Of Contents
n
Add an ODBC Data Source to Oracle 12c or 11g on page 46
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.
Add a View Composer Database to Oracle 12c or 11g
You can use the Oracle Database Configuration Assistant to add a new View Composer database to an
existing Oracle 12c or 11g instance.
Prerequisites
Verify that a supported version of Oracle 12c or 11g is installed on the local or remote computer. See
“Database Requirements for View Composer and the Events Database,” on page 11.
Procedure
1 Start the Database Configuration Assistant on the computer on which you are adding the View
Composer database.
Database Version Action
Oracle 12c
Select Start > All Programs > Oracle-OraDb12c_home > Configuration
and Migration Tools > Database Configuration Assistant.
Oracle 11g
Select Start > All Programs > Oracle-OraDb11g_home > Configuration
and Migration Tools > Database Configuration Assistant.
2 On the Operations page, select Create a database.
3 On the Database Templates page, select the General Purpose or Transaction Processing template.
4 On the Database Identification page, type a Global Database Name and an Oracle System Identifier
(SID) prefix.
For simplicity, use the same value for both items.
5 On the Management Options page, click Next to accept the default settings.
6 On the Database Credentials page, select Use the Same Administrative Passwords for All Accounts
and type a password.
7 On the remaining configuration pages, click Next to accept the default settings.
8 On the Creation Options page, verify that Create Database is selected and click Finish.
9 On the Confirmation page, review the options and click OK.
The configuration tool creates the database.
10 On the Database Creation Complete page, click OK.
What to do next
Follow the instructions in “Add an ODBC Data Source to Oracle 12c or 11g,” on page 46.
Use a SQL Statement to Add a View Composer Database to an Oracle Instance
When you create the database, you can customize the location of the data and log files.
Prerequisites
The View Composer database must have certain table spaces and privileges. You can use a SQL statement to
create the View Composer database in an Oracle 12c or 11g database instance.
View Installation
44 VMware, Inc.