EGL Development User Group

EGL Development User Group

EGL Development User Group

The EGL Development User Group is dedicated to sharing news, knowledge, and insights regarding the EGL language and Business Developer product. Consisting of IBMers, HCL, and users, this community collaborates to advance the EGL ecosystem.

 View Only
  • 1.  Consume EGL SOAP service from BIRT report

    Posted Mon November 18, 2013 08:54 AM

    Hi All,

    Has anyone had success creating a BIRT report (I'm using BIRT 2.6.2 from Rational v8.5) using a Data Source which consumes an EGL generated SAOP service?  The web service I'm using is working fine in an EGL RUI application, but I want to use it in a BIRT report.

    Oddly enough, I have a working report which I did while killing some time one evening.  But I am unable to recall how I did it.  I've tried several time before without success, so when I did create this report last July I thought I would have saved some notes at least as to what I did differently.

    Any attempt to re-create the report fails, although it does call the web service as I seen by my WAS console.  There's just no data returned in the BIRT Data Set.

    Thanks,

    Daron

    canutri


  • 2.  Re: Consume EGL SOAP service from BIRT report

    Posted Wed November 20, 2013 12:58 AM

    Hi Daron,

    I attached a tutorial for creating BIRT report in EGL, please check it. This tutorial is targeted on RBD v7.5.x, for more precise information, please refer to the RBD info center, for example: http://pic.dhe.ibm.com/infocenter/rbdhelp/v8r0m0/index.jsp?topic=%2Fcom.ibm.egl.lr.doc%2Ftopics%2Fregl_ui_brep_birt_handler.html

    I also attached a sample created by RBD v8.5 and Tomcat v6, hope that's helpful for you.

    • TestService: EGL SOAP service project which is running on Tomcat v6.
    • TestBIRT: EGL BIRT project that consumes the SOAP service. Note that the data source is "script-data-source" in "report.rptdesign".

    I'd suggest to open PMR to RBD support team if you still have detailed problem on EGL BIRT.

    Thanks & Regards

    PengFeiYu


  • 3.  Re: Consume EGL SOAP service from BIRT report

    Posted Wed November 20, 2013 08:37 AM

    Thanks for the response.  However, my current need is not to consume the EGL SOAP service using EGL, but rather directly from BIRT as a web service data source.  With the exception of a few initial BIRT reports using EGL scripted data sources, we build all our BIRT reports (open source BIRT and commercial Actuate iServer) using data sources connecting to our databases.

    My current demand is to modify our product "Conformance/Analysis Certificates" with product performance Q/A data across multiple databases and several tables.  The products components determines which database/table the data will be found in.  This was getting quite complex in BIRT using database data sources and much of the data needs to be aggregated prior to rendering the report such that out of conformance specifications can be highlighted and certificate marked as requiring Q/A review (as the problem usually is an incorrectly recorded Lot # and not an product that fails to be in spec.)

    I'm Using an EGL web service to gather the correct data from the many sources and aggregate it and return an array of Product Lot #'s and the associated performance specifications.  I'd prefer to consume the EGL SOAP web service directly in the BIRT report as opposed to converting the report to use a scripted data source from a EGL BIRT Handler.

    To that effect, I was hopeful someone here has had success consuming an EGL SOAP web service directly in the BIRT report designer when defining a web service data source and its associated data set.

    I have sought help on the BIRT community forum for help without much success.  As an Actuate customer with paid support, I've also requested help there, but that is taking some time to get positive results.

    Thank you,

    Daron

    canutri


  • 4.  Re: Consume EGL SOAP service from BIRT report

    Posted Thu January 05, 2017 02:35 PM

    Hi, guys, fine.

    I'm fighting here to make Birt and EGL work. Can anyone help us?

    My settings are: RBD 9.5.0.1, Db2 v 9, BIRT 4.4.2 (OSGI), WAS 8.5. Client windows 7 and Server AIX - Power 740.

    We were able to use BIRT within RBD from the Report Design perspective.

    The problem is when I run EGL applications. Let's go to the details:
    1) I developed a "BasicProgram" (attachment)
    2) I developed a "Birthandler" (attachment)
    3) when executing the "BasicProgram" I get the abend (attachment)
    "Detail: org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
    Can not open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.dbprofile.
        
    Org.eclipse.datatools.connectivity.oda.OdaException;
        
    Java.lang.NoClassDefFoundError: org.eclipse.core.resources.ResourcesPlugin
    At org.eclipse.birt.report.engine.executor.ExecutionContext.addException (ExecutionContext.java:1239)
    ..... "

    I put the "jar" org.eclipse.birt.report.data.oda.jdbc.dbprofile, in various places and nothing ...
    I changed the settings of my desktop variables by placing the "classpath" variable pointing to my birt_runtime.

    Nothing to shoot ...

    Can someone help us .. ??

     

    Tks

    Osvaldo Menezes

    ojomenezes