Adding a BODShredder connection - Oracle

To add a BODShredder connection for Oracle:

  1. On the Manage Data Sources page.
  2. Click New and select Oracle as the connection type.
  3. Specify a name for the data source. The name must be unique. To facilitate setting up drill through to journal detail within CPM pages, name the data source PMSourceViews.
  4. Select BODShredder as the category.
  5. To define the Relational Connection:
    1. Specify the user name of the schema owner.
    2. Specify the password for the administrator user.
    3. Specify the name of the host computer on which the Oracle software is installed.
    4. Specify the name of the Oracle service.
    5. Specify the port number. The default is 1521.
    6. Select the database to connect to the data source. If necessary, click Refresh to update the list of available databases.
    7. Specify the TNS name. This name is required and must be set up in the tnsnames.ora file. The TNS name in the tnsnames.ora file includes the host name, service name, and port number for each TNS name.
    8. Select the appropriate driver.
  6. Click Test Connection.
  7. Click Save.