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 or Use a SQL Statement to Add a View Composer Database to an Oracle Instance.

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.