Cisco Cisco Process Orchestrator 3.1 User Guide
10-9
Cisco Process Orchestrator 3.1 User Guide
Chapter 10 Performing Administrative Actions
Managing Database Settings
Step 3
Click the Connection tab and choose the Oracle (Oracle Authentication) database type.
Creating a Reporting Database Connection
The Process Orchestrator Reporting database is initially created during the installation process. There
are occasions when the report database connection may need to be removed and then re-connected.
are occasions when the report database connection may need to be removed and then re-connected.
Before You Begin
•
You must be logged in with an account that has Administrator rights on the machine where the report
database is being created, whether it is the local machine or a remote machine.
database is being created, whether it is the local machine or a remote machine.
•
You must also have Reporting Services permission to create or modify the reports as create or
modify permission over the Report Database object within Cisco Process Orchestrator.
modify permission over the Report Database object within Cisco Process Orchestrator.
To create the report database connection:
Step 1
Choose Administration > Database Settings, right-click Report Database and choose Create Process
Orchestrator Reporting Database.
Orchestrator Reporting Database.
The Welcome to the Report Database Configuration Wizard panel displays. Click Next.
Step 2
The fields on the New Process Orchestrator Reporting Database panel (excluding the Password field) are
automatically populated with the name of the local server and the credentials of the currently logged in
user. Use one of the following methods:
automatically populated with the name of the local server and the credentials of the currently logged in
user. Use one of the following methods:
•
To use the credentials that are auto-populated for the default user, enter the password in the
Password field.
Password field.
•
Specify the credentials for a different user, then click Next.
Step 3
The fields on the Database Settings panel are automatically populated with the default locations and data
grooming settings for the database. Use one of the following methods:
grooming settings for the database. Use one of the following methods:
•
To use the information that is auto-populated, click Next.
•
To modify the data and transaction log file settings for the new database, specify the appropriate
information, then click Next.
information, then click Next.
Step 4
When the dialog box indicates that the database has been successfully created, click Next.
Step 5
Verify the information and click Finish to complete the procedure and close the wizard.
Field
Description
Service name
Display-only. Service name alias used for the Oracle Single Client Access
Name (SCAN)
Name (SCAN)
Host
Display-only. Name of the Oracle server where the database resides.
Port
Display-only. Port number used to access Oracle database.
User/Schema
Display-only. Name of the reporting database.
Password
Password assigned to the user account for logging on to the Oracle
database server.
database server.