Categories
Exporting report outputs(PDF, CSV) to Network Shared File system(Linux Server) from Agents in OBIEE
Hello Experts,
How would we achieve this,
Exporting report outputs(PDF, CSV) to Network Shared File system(Linux Server) from Agents in OBIEE 12C. Please help.
Regards,
Abinash
Answers
-
Hello,
a good starting point would be to study https://support.oracle.com/rs?type=doc&id=1610118.1
While this document was especially provided for Oracle BI 11g, general tasks are still the same for OBIEE 12c.
In general you...
- ...create an Java EJB (or use that precompiled Application given by Oracle in Doc 1610118.1 )
- ...deploy your Application to your managed server (bi_server1)
- ...configure OBIEE ActionFramework (using OBIEE 12c it's ActionFrameworkConfig.xml in <domain_home>/config/fmwconfig/biconfig/actions !!) to register your EJB and make it available within BI
- ...create your agent calling your Java EJBs
- ...provide values for your parameters (filename and content, e.g. pdf/csv/excel file)
In contrast to prebuild applications/EJBs provided online, oracle released its sourcecode as well. Nevertheless it might be a good idea to always check precompiled java-applications by using a java decompiler first
Hope this little description will help you.
Regards
Chris
0 -
Nice write-up Chris
0 -
Hi chris,
I tried everything as per steps mentioned in the Doc 1610118.1 . No luck.
I am getting below errors while invoking the EJB. Any suggestions?
Regards,
Abinash
0 -
Hi,
Why dont you try using BIP for this?
Can BI Publisher Shared Storage use NFS volumes managed by the NFS Automounter? (Doc ID 2010519.1)
Thanks,
Sareesh
0 -
@Saresh-Oracle I think you wanted to post this:
0 -
Phew!!
Eevrything is good with https://support.oracle.com/rs?type=doc&id=1610118.1 except while creating and mapping credential key in EM.
Document mentioned to have WLSJNDI as username, but I used weblogic as username and it worked.
Thanks Chris and Christian for the help!!
Regards,
Abinash
0 -
I am getting the same error , what did you do to fix it ?
0 -
Can BI Publisher Shared Storage use NFS volumes managed by the NFS Automounter? (Doc ID 2010519.1)
Thanks,
Sareesh
0 -
@Saresh-Oracle not sure why that Dic ID keeps being mentioned. Abinash never talked about that and explicitly re-stated that another Doc is the one.Yes, BIP can do this via bursting (the documentation link I posted).
0 -
@ Christian Berg, thats upto 3624414
0