Developing external application to communicate with Oracle BI Publisher — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Developing external application to communicate with Oracle BI Publisher

Received Response
116
Views
4
Comments
User_RUIII
User_RUIII Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Developing external application to communicate with Oracle BI Publisher

Content

For my understanding, we can use a web service
(ScheduleService, ReportService,SecurityService and CatalogService) to
communicate Oracle BI Publisher for manipulating scheduler to generate a
report.

May i know

  1. is it an implementation of Oracle BI Presentation
    Services?
  2. if so is it a single way to communicate with Oracle BI in
    order to trigger the Oracle BI scheduler?
  3. does it have an alternative to communicate with Oracle BI
    Publisher from external application?
  4. Any reference / sample recommended?

Thanks in advance

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    We call BI Publisher Scheduling Service from Control-M ... use it to put in a scheduled run once job daily.

    Here's the Oracle Docs ...

    https://docs.oracle.com/cd/E28280_01/bi.1111/e22259/webservices.htm#BIPDV002

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    if possible can you able to share java code here, Thanks

  • Ravi Chamarty
    Ravi Chamarty Rank 4 - Community Specialist

    Hi,

    As I mentioned, I didn't develop the JAVA code to do it. but, when we raised Oracle SR, they shared the documentation and methodology

    for all the JAVA APIs handbook that could be call BI Publisher reports, define the layouts and email/schedule them to the recipients.

            Also, caching of the data, caching of the report layouts,  we also had a issue where report time out was occurring after 3 min if the data volume was more, performance issues were there if the report export to excel for more than 15,000 rows were there all this we discussed and resolved after talking to Oracle support. I don't have it since it was done in 2013 and for a different customer.

    Raise an Oracle SR they would be able to help for the same

  • Ravi Chamarty
    Ravi Chamarty Rank 4 - Community Specialist

    Hi, though I have not used it myself. I was in a project where a JAVA developer called these using Bi Publisher Wsdls from JAVA.

    Since, they had to be called via Control M for scheduling and Oracle Support said it couldn't from URL method and

    this was on the only options.

    The Bi Publisher wsdls could be called from batch/shell scripts and he was completely able to schedule, call multiple reports, modify the layouts

    from JAVA APIs connecting to Bi Publisher