1 / 14

EGL/DB2 Web Query Integration

EGL/DB2 Web Query Integration. Binary Computer Services Limited. Who are Binary. Company formed in 1979 as a Software House Consultancy Development Training Web Integration IBM Business Partner since 1984 S/38, S/36, AS/400, iSeries and i5 DB2 IBM Host Integration Products

osma
Download Presentation

EGL/DB2 Web Query Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. EGL/DB2 Web Query Integration Binary Computer Services Limited

  2. Who are Binary Company formed in 1979 as a Software House Consultancy Development Training Web Integration IBM Business Partner since 1984 S/38, S/36, AS/400, iSeries and i5 DB2 IBM Host Integration Products Over 7 years experience Both Internet and Intranet Implementations DB2 Web Query Enterprise Modernisation Other Markets Constructions (Construction*2000) Business Intelligences (BO Crystal Xcelsius)

  3. IBM has delivered a System i web based query and report writing program product that replaces IBM Query for iSeries (Query/400) Base Program Product Report Assistant Graph Assistant Power Painter Spreadsheet integration Web-enable Query/400 reports Federated queries (DB2 for i5/OS) Requires V5R4 Additional Chargeable IBM Features Active Reports (Disconnected) On Line Analytical Processing Developer’s Workbench Report Broker Software Developers Tool Kit (SDK) Additional Modules planned IBM DB2 Web Query for System iPowered By Information Builders For more details, refer to: http://www.ibm.com/systems/i/software/db2/webquery

  4. Set up reports to be scheduled. Distribute via e-mail, printer or DB2 web Query folder. ‘Burst reports’ to the relevant people. Set dates that reports cannot be run on i.e. holidays. Set up distribution lists Report Broker Overview

  5. The SDK comprises of up to 6 wsdl files. Allows integration into your existing applications like EGL and HATS. Invoke DB2 Web Query from a CL command line. SDK Overview

  6. What can be achieved with the SDK?

  7. DB2 Web Query SDK • Generate the WSDL file. • Consume the web service in EGL. • If populating drop down lists XML files will need to be written out. • Read the XML files and populate the dropdown lists. • The combo boxes are dynamically loaded when a value is selected in the previous dropdown. • When the ‘run’ button is clicked, this calls the web service passing parameters. • The output is returned to the screen.

  8. DB2 Web Query SDK Continued • The web service signs on to DB2 web query and calls the report you have specified. • If the procedure called is a graph then another web service must be called to retrieve the image in a byte array. • Because the original web service will return the location of the image (not the image itself).

  9. Report Broker integration • Report broker can also be called with web services. • A web service must be called to retrieve a security token from the scheduler and stored. • Another web service can then be called using the security token and the schedule name, to retrieve the schedule information. • Finally the schedule can then be run from another web service call.

  10. Demo

  11. Summary • Powerful Reporting tool from IBM on “i” • 12,000 System i customers in 18th months • Easy integration into EGL applications • Graphs • Reports • Output to Excel, PDF etc • Control Report Broker within an EGL application • Distribute Reports automatically via email & share folders.

  12. Q & A e-mail: james.cole@binarycomputer.co.uk www.binarycomputer.co.uk Binary Computer Services Ltd

More Related