Friday, December 6, 2013

BI Integration with Webcenter Portal - Privileges on BI Side

In this short post we will be seeing how to integrate BI Reports with WC. Though there is a very good guide for integrating these two, this post will describe a step which got missed and even after following all the steps BI connection was not working correctly.

Following is the link to the PDF which is very useful and practical solution for BI and WC integration.

http://www.oracle.com/technetwork/middleware/webcenter/portal/learnmore/wc-biappsconfig-396418.pdf

So after creating a successful connection to BI server from Enterprise Manager, Still I was unable to see BI reports when trying to add through composer.


So after detail analysis, we found out the the connection was established successfully and there was no problem with it. The problem was that permissions were not given to the user BIImpersonator . Since this user is being used to create connection between WC and BI, it should have all the privileges to the catalogue on the BI Side as well.

For doing this, login into the BI analytics with Admin user.

Go to Admin option at the top right.

Go to Manage Privileges.



Scroll and find Catalog.Click on Personal Storage and provide BIAdministrator role to it. Also add BIImpersonator user to BIAdministrator group in WLS.



Save and check the connection in Webcenter portal.

It works now and you can import all the BI reports from BI server to WC app.


Happy Learning !!


3 comments:

  1. BlueHost is ultimately the best website hosting company for any hosting services you might need.

    ReplyDelete
  2. Hadoop Training Institute in Noida, The Hadoop certification has considerable advantages in addition to the great demand for trained professionals. A certified Hadoop professional gets the advantage in terms of payment package compared to other professionals working in the field without certification. When it comes to IJP, Hadoop certification is compatible to advance the ladder and accelerate your career. big data hadoop training in Noida, big data hadoop Training institutes in Noida, sector 2, oracle big data training,Oracle Training in Noida, big data boot camp, nosql database training, big data appliance training, exalytics training, exadata course, big data introduction, oracle course, oracle training, big data training in Noida, ibm big data hadoop training institutes noida
    Hadoop Training Institute in Noida

    CONTAC CIITN:

    B-12, Sector - 2, Noida, U.P
    State - Uttar Pradesh U.P
    Country - India
    Pin Code - 201301

    Phone - +917290926565
    Mon - Sun: 10am - 6pm

    ReplyDelete