Oracle Communities

Oracle Analytics and AI

Child Item

Exporting report outputs(PDF, CSV) to Network Shared File system(Linux Server) from Agents in OBIEE

AbinashBehera

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

Find more posts tagged with

Accepted answers

All comments

Chris|ger

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

[Deleted User]

Nice write-up Chris

AbinashBehera

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

Saresh-Oracle

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

[Deleted User]

@Saresh-Oracle I think you wanted to post this:

https://docs.oracle.com/middleware/bi12214/bip/BIPDM/GUID-A926D588-426F-47C7-8A9A-B0A7959C5814.htm#BIPDM344

AbinashBehera

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

SarojPradhan

I am getting the same error , what did you do to fix it ?

Saresh-Oracle

Can BI Publisher Shared Storage use NFS volumes managed by the NFS Automounter? (Doc ID 2010519.1)

Thanks,

Sareesh

[Deleted User]

@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).

Saresh-Oracle

@ Christian Berg, thats upto 3624414