BI Presentation Service
Hello,
I came across some links (Sathya's Tech Blog: Oracle ADF BI Integration , https://raviteja8.wordpress.com/2015/02/07/obiee-integration-with-oracle-adf/ ) to integrate reports/dashboards/analyses into ADF applications.
I was following the tutorials but trying to do that for Oracle BICS, but seems to me that only works for Oracle BIEE, because i cannot establish a successful connection:
It´s that i have a BICS account, and not BIEE, and want to put those objects in my pages of the ADF application.
So, question: Is the presentation Services only to establish a connection with OBIEE server and it does not connect to BICS server ?
Thanks
Carlos
Answers
-
I don't think you will be able to achieve your requirement with BICS environment as you have the Proxy URL to connect to BICS and actual Hostname and Manager Server ports on which analytic is running is unknown hence your connection failure within ADF application and may be Oracle wouldn't shared port details you can check on same with Oracle Support team who could confirm on same through Oracle Cloud Operations team.
You are able to connect with On-Premise OBIEE environment because you have all relevant details to connect to the environment.
0 -
Thanks for reply.
I am trying to connect to OBICS because i have Database in Oracle Database Cloud Service and Application also in same DataCenter, there is no on-premise.
Does OBIEE connects to Oracle Cloud DB to retrieve the Data from?
I will make a SR to Oracle Support.
Regards,
Carlos
0 -
As long as you open the right ports of course it does ... It's a database in the end ...
But you maybe want to first look at OAC? OBIEE on the cloud in the end ...
0 -
That´s what i thought about connection to OBICS (instead of OBIEE) with presentation services - as long i provided the right ports and credentials... its reports at the end...
OAC? or ORAC?
OBIEE in the cloud isn´t OBICS?
Regards,
Carlos
0 -
Oracle Analytics Cloud.
Full blown OBIEE with all bells and whistles in the cloud. Not the puny "15%" functionality BICS ;-)
0 -
Ok, so BICS is included:
OAC services are sold packaged in two editions, Standard and Enterprise:
- OAC Standard includes DVCS, Oracle Smartview, and Oracle Essbase Standard
- OAC Enterprise includes the services in the Standard edition and adds BICS, enterprise capabilities for Oracle Essbase, and Oracle Day by Day
Pricing should be 'full blown' pockets too .
What is the community for OAC?
Thanks.
As long i can show the reports/graphs/dashboards/tables... in my ADF applications somehow (will it work with presentation services?).
Regards,
Carlos
0 -
Difference is can ssh to the instance and admin it. (apart from being able to use the real admin tool etc).
0 -
Did you look at this documentation, may be it helps.
0 -
Yes, i did. also the safe domains part too.
0 -
sorry, did not understand your reply very well.
could you be more clear, please.
Thanks.
0 -
I think what you are trying to do is integration using web services, instead of that, since you said "As long i can show the reports/graphs/dashboards/tables...", can't you embed the content in an iframe? I don't know ADF, but just a suggestion.
0 -
Valid suggestion but the here is the result:
below, it has a link to open a new tab and redirects to OBICS login page.
I just want to show the reports with no more need to sign on.
BTW , @Christian Berg , doesn´t Oracle Data Visualization Cloud Service do the same for reports/tables/dashboards like OAC?
P.S. - i will still have to find a way to display those reports in ADF app somehow.
Regards,
Carlos
0 -
I tried to embed a BICS dashboard in an app ( an OBIEE on premise app) and it worked. I got a similar error, but that was because the domain information I provided in Safe Domain was incorrect.
0 -
I need to check later. Travelling now.
0 -
If I'm not wrong we can say "Standard" is like Essbase + Data visualization (similar to Data Visualization Desktop in term of functionalities), while "Enterprise" is a full OBIEE. You will have full access to the "server" via SSH to configure or change what ever you want.
So OAC is a real cloud hosted OBIEE with all the features of OBIEE + BICS on top (so the light tool for modelling things).
So it will definitely work.
I guess it's worth to check what @Sherry George said: he managed to embed a BICS view somewhere. So you maybe want to ask him more details first as you can keep using your current BICS.
For the future I would of course suggest to explore OAC Enteprise as it's a full OBIEE and in this forum we love OBIEE (or why would we be here? ).
0 -
Thanks Gianni so I dont need to write anymore
0 -
Thanks for suggestion.
I am waiting for approval of @Sherry George to check the details of how he embedded OBICS.
In the meantime i watched this video:
https://www.youtube.com/watch?v=B6M9axXiLx0
and following it was able to do as they refer (somewhere after the 4 min) and show a graph in w3schools (as long i have already log in in OBICS with same browser cookie).
Doing that in adf page ( and log in OBICS with same browser cookie) the iframe is empty - it does not shows error like the image i showed before.
Guess i´ll have to wait for @Sherry George
Thanks everyone for the efforts.
BR
Carlos
0 -
Hi Carlos,
I did some further testing on this and it seems that there is indeed an issue with authentication. When I first tested I was already logged in to BICS in a different tab in the same browser and was able to see the embeded BICS dashboard in my on-premise OBIEE dashboard ( I used the "embeded object"). But if I signed out of BICS and start a new browser session then the embedded content was no longer appearing. Currently I do not see a way to pass credentials in the BICS url. You would perhaps need to setup single signon to accomplish this.
0 -
Hello @Sherry George
Thanks for answering.
Yes, i was aware that most likely i would have the credentials issue, but that is another question (one problem at a time - will take care of that later only after put this to work).
What i want now is to use the "embedded object" like you did, but i´m not able to establish a connection as you refer you did when provided the correct safe Domain.
What domain is the safe? In the video i follow it and understand the correct domain for the examples.
So i put the weblogic server domain name in whitelist but the graphs still do not show.
Why?
0 -
At last i got it.
In my ADF iframe page i was finally able to see a OBICS dashboard/VA/analysis.
Indeed i have to be authenticated in OBICS with same cookie of ADF web page (but this is an expected behaviour), but the problem is that the safe domain must be a public url (where i can access from anywhere on web) where my ADF app is deployed, also check for firewall configuration to allow establish connection and that´s it (Now that i know it´s easy, but a lot of time was spent with this).
Thanks everyone.
Carlos
0
