Invoking BI Publisher Reports through Command-Line for Schedule as Run Now.

AbinashBehera

Greetings All,

I have been trying this out since few days, need some expert advise on this.

The requirement is to create a dependency of BIP Reports with ETL data load. As soon as ETL job Finishes up, the Autosys needs to trigger another Job to invoke the BI Publisher Reports and Send out Mails with report Attached.

I found, through web-services we can trigger the reports but how the XMLs can be invoked from Autosys Command line?

Is this only approach or is there other way to Trigger the BIP reports from Command Line.

Regards,
Abinash

2641755

I have been looking for a similar solution

Gabriel Grigorie-Oracle

Hello  Abinash,

You can try to use rest api with curl, as described below:

https://docs.oracle.com/middleware/12213/bip/BIPAP/QuickStart.html

Also you can try using REST API or try using as web service

https://docs.oracle.com/cd/E21764_01/bi.1111/e18863/webservices.htm#BIPDV002

Hope this helps.

Regards
Gabriel

AbinashBehera

Hey Gabriel,

Thanks for your reply.

That's pretty much I have so far. Though I am taking the Web Service way, I stuck at executing the web service xml from command Line. Not sure how to go ahead.

Regards,

Abinash

AbinashBehera

Any luck so far?

Gabriel Grigorie-Oracle

Hello Abinah

Can you please update  how you use the command line so we can have a look on formatiing ?

Regards
Gabriel

AbinashBehera

Hi Gabriel,

Not sure what needs to be done at formatting, but I am currently going JAVA way to create a package invoking the webservices and executing the Java class from command line.

Regards,

Abinash

Christian Berg-0racle

Have you looked at event triggers? It's an out-of-the-box functionality:

https://www.rittmanmead.com/blog/2011/12/event-triggers-in-bi-publisher-11g/

AbinashBehera

Hi Christian,

Thanks for jumping into it, was expecting something from you.

If I understand correctly, Event Triggers will execute the package only when we execute the Report. So first of all, how it would help me to automate the execution (scheduling).

Regards,

Abinash

User_BC3XK

Hi Abinash,

I hope you have figured it out. if not then i would like to say that we had implemented the same. We had created a Java package to call the XDO reports (and save it in a desired location in our case) so it is very possible to do what you are trying to do.

If you plan to run multiple reports considering storing the report details in a table and you could write a class to retrieve the information and send it as an argument when required.

This is all I remember at the moment and it was implemented for 11g. So, it is very much possible to do it and you could even call the java file from a scheduling tool autosys or something.

Regards,

Nikhil

AbinashBehera

Hi Nikhil,

How do you call your Java package, through Unix command line? or can it be integrated with Invoking Java Method from Action menu of OBIEE.

Regards,

Abinash