we are trying to access to an obiee report from an external portal (coded with php).
The idea is that the user clicks on a link an gets the report in pdf format. For that purpose we are using this url:
But this url is expossing OBIEE's user and password.
The question is, is there any way that we could let our portal ussers access to an obbie report without expossing the user and password?
I have been looking into oracle forums and have found this: OBIEE Go URL with password protected
but we couldn't use this aproach due to security issues.
As I mentioned in other post you can call values from session variables of your portal so any point of time the actual values are not exposed.
Since you want to see the obiee report in pdf format,how you want to see? pdf within browser or to get save wizard?
I think this is all depends on the user's browser setting for pdf files.
You can go for url encode using php or else try to use html frames,1st frame uses php code and rest is obi report.
If helps pls mark let me know if you have any questions
Altought I store user and pass values into session variables I will need to redirect de user to OBIEE, this redirection exposses the user and pass.
Is there any way of getting the raw pdf from obiee? Any url that I could do a "wget url" and get the report in pdf format. If I had an url like that I could do an wget into my php portal in order to obtain the pdf report and then deliver it to the final user.
Try to use target=_new in your link so that onclick on the link open new window and that may prompt to open or save the file.
If you are using session variable then you might call them in form object as hidden.