Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

How To: Configure Reporting and Dashboard Service on an Existing Database User
Solution

To configure RDS when Database User for RAD Service is already created, do the following:

  1. Make sure that %INFA_HOME%\java\bin is added in PATH environment variable.
  2. Prepare the default_master.properties file for installation (present under %INFA_HOME%\jasperreports-server\buildomatic).
  3. a.  Edit the default_master.properties and uncomment the following sections and update the information:
     
    -        Provide Oracle database user for dbUsername and sysUsername.
    -        Database password for dbPassword and sysPassword.
    -        Provide database credentials in dbHost, dbPort, sid.
    -        Provide “ReportingandDashboardsService” for webAppNamePro.

    Example

     
    appServerDir = E:\\Informatica\\9.1.0\\tomcat
    dbType=oracle
    dbUsername=reportingrepo
    dbPassword=password_reportingrepo
    sysUsername= reportingrepo
    sysPassword= password_reportingrepo
    dbHost=testserver
    dbPort=1521
    sid=orcl
    webAppNamePro = ReportingandDashboardsService
     
    b.   Make sure that there are no other lines uncommented.
    c.   Save the file.
     
  4. Edit the install.bat and remove the following lines under :oracleInstall (it creates the DB User):
  5. call js-ant create-js-db
    if %errorlevel% NEQ 0 goto end
  6. Stop the Informatica server.
  7. Using command prompt, go to %INFA_HOME%\jasperreports-server\buildomatic and run the following command:
  8. a.      Clean the existing configuration:
    js-ant clean-config
    b.      Run the install script:
    Install.bat Oracle
  9. After successfully installing, ReportingandDashboardsService folder will be created under %INFA_HOME%\services\ ReportingandDashboardsService\
  10. Start the Informatica Server.
  11. Create a Reporting and Dashboard Service and enable it.
  12. To add Reporting Source, select the Reporting and Dashboard Service and go to Actions > Add Reporting Source. Select the MM/PC Repository Service and provide the MM/PC Repository database details.​
More Information

​For UNIX installation, edit the install.sh and remove the following lines (Present Under: elif [ "$1" = "Oracle" ]; then):

 ./js-ant create-js-db
 if [ $? -ne 0 ]; then
  exit 1
 fi

Reference
Applies To
Product: PowerCenter
Problem Type:
User Type:
Project Phase:
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:3/7/2013 3:47 AMID:146036
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)