X

An Oracle blog about BI Publisher

Standalone vs EBS Embedded

I had grand plans to spend last night getting the first of the web services posts together - I have all the code samples just need the eloquent prose around them ... my plans were dashed when my wife got me to help out on a school fund raiser 'flyer' - what ought to have taken an hour, stretched into the night - what joy it is to mess about with MSWord trying to combine 4 documents and get the look and feel the same ... NOT!
So you're getting something as useful, if not more so, that I had ready yesterday.



We have been pinging mails around over the last day or two - a customer asked 'what are the differences between the standalone release and the embedded EBS version.' We all thought someone had documented those, alas none of us had, but Pradeep one of our PMs that you'll find regularly lurking on the forum, took it upon himself to bash out a quick table of comparison.



I have embellished a little here and there ... 























































































































BIP Enterprise Server (stand-alone)BIP with EBS
1.Data Extraction Connects to any databases that supports the use of JDBC driversMeant for only Oracle DB ie the db that EBS is using. Can connect to others but requires licensing
2.Various types of Data Sources ? SQL, Data Template, OBIEE, Olap MDX, Discoverer, Web Services, HTTP / RSS feeds, FileOracle Reports or PLSQL base concurrent programs can extract data from DB. Can use BIP Data Templates to extract from other sources e.g. XML file, Excel, etc
3.SchedulingScheduler available, scheduler can be configured with different types of databases - oracle, db2, sql server, sybase, etc.Scheduling is managed by concurrent manager. Tight integration with CM to generate output based on user driven template and output format selection.
4.SecurityMultiple security models supported ? BIP security, Olap, EBS security, database security, OBIEE security.Adheres to EBS security ie users, responsibilities, reporting groups,etc
5.Web Services Web service APIs available for BIP integration with any applicationNo web services API
6.ToolsTemplate formats supported RTF, PDF, XSLFO, Flex, Excel Same but Flex is not supported. Excel templates under controlled release.
7Online Analyzer and Excel Analyzer utilities available for data analysisNot available in EBS
8.BI Desktop is able to connect to Enterprise Server to design and upload reports to the server.Feature not supported in EBS
9.BurstingBursting configuration can be set on the Report Editor screen , UI based.Bursting is set by configuring a control file (xml file).
10.DeliveryDelivery to email, fax, ftp, webdav, http and printer are supportedDelivery channels not available out of the box, requires custom code to deliver documents using BIP APIs
11UIComplete UI to manage users, roles, admin, reports, scheduling, etc Leverages OAF UI to manages templates. Reports managed and scheduled via CM UI. USers and roles(responsibilities) managed by AOL UI


By no means a highly detailed and exhaustive list, the big ticket items in my mind are the delivery and web services - please dont even ask right now. If we extend the question, then we get to JDE and PS differences from the standalone. I need some time to get that those together.

Join the discussion

Comments ( 9 )
  • Gareth Tuesday, February 19, 2008
    Hi Tim,
    Another difference I've noticed is the "data definitions" or "dataTemplate" in EBS BIP seem to differ from "report" in BIP Standalone - or am I missing something there?
    Gareth
  • Kevin Wednesday, February 20, 2008
    Are there any e-business customers using the standalone version of BIP for their ERP reporting rather than the embedded version?
    Cheers,
    Kevin
  • Ashok Thursday, February 21, 2008
    It will be nice to give some meaning full names to BIP report attachments which are scheduled via email.Also csv reports are attached with extension .out instead of csv.
  • Tim Dexter Thursday, February 21, 2008

    @Gareth - the data templates in the standalone are part of the xdo report file. Whereas in Apps they are self contained but attached to a conc prog definition.


    @Kevin - yes, some are. Typically where they are hitting custom or legacy systems and EBS - you can pull data from multiple sources and merge into single reports and get all the standalone goodness around analysis and delivery.


    @Ashok - a good point Ashok I think its going to be covered in the next release. Need to check on that thou.

  • Mani Monday, March 9, 2009
    Tim,
    Is the standalone is free with EBS license or how does it cost if it is not.
    Thnx
    Mani
  • Ayyappan Wednesday, July 29, 2009
    Still csv reports are attached with extension .out instead of csv.
    Any update on this or work around
    Thanks,
    Ayyappan
  • guest Tuesday, January 29, 2013

    I realize that this is an old post... I was wondering if there were any improvements with the version of EBS R12.

    I have a requirement to place links to my OBIEE dashboards to point to EBS BI Publisher reports. Would that be possible with the EBS BI Publisher version? Can I get hyperlinks?

    Many thanks in advance for any feedback!


  • guest Tuesday, January 29, 2013

    I realize that this is an old post... I was wondering if there were any improvements with the version of EBS R12.

    I have a requirement to place links to my OBIEE dashboards to point to EBS BI Publisher reports. Would that be possible with the EBS BI Publisher version? Can I get hyperlinks?

    Many thanks in advance for any feedback!


  • guest Tuesday, January 29, 2013

    I realize that this is an old post... I was wondering if there were any improvements with the version of EBS R12.

    I have a requirement to place links to my OBIEE dashboards to point to EBS BI Publisher reports. Would that be possible with the EBS BI Publisher version?

    Many thanks in advance for any feedback!


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.