To add or update a Production Reporting database server:
In EPM Workspace, select Navigate, then Administer, then Reporting and Analysis, and then Production Reporting Database Servers.
In the Production Reporting Databases tab, perform an action:
Right-click and select Create New PR Database Server
Select an existing database server, right-click, and select Update Production Reporting Database Server.
Supply or update the following information:
Job Service Host—Host where the job service resides
Host Type—Job service host platform
Database Host—Host where the database server resides
DB Type—Type of database server you are using
User—Default user name used by the Job Service for running Production Reporting programs on the database server. Used if the job owner does not supply a database user name and password when importing a job.
Password—Valid password for user name
Datasource—Data source name or connection string that a report will use to connect to the database server
Connection Parameters—Database connection parameters (also known as database connectivity environment variables). Used to define database information that may be required by Production Reporting; for example, name= ORACLE_SID, value=PAYROLL