egl/db2 web query integration
TRANSCRIPT
1 © 2009 Binary Computer Services Ltd
Rational Software
EGL/DB2 Web Query Integration
Binary Computer Services Limited
2 © 2009 Binary Computer Services Ltd
Rational Software
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 © 2009 Binary Computer Services Ltd
Rational Software
• 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 i Powered By Information Builders
For more details, refer to: http://www.ibm.com/systems/i/software/db2/webquery
4 © 2009 Binary Computer Services Ltd
Rational Software
Report Broker Overview• 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
5 © 2009 Binary Computer Services Ltd
Rational Software
SDK Overview• 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.
6 © 2009 Binary Computer Services Ltd
Rational Software
What can be achieved with the SDK?
7 © 2009 Binary Computer Services Ltd
Rational Software
8 © 2009 Binary Computer Services Ltd
Rational Software
9 © 2009 Binary Computer Services Ltd
Rational Software
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.
10 © 2009 Binary Computer Services Ltd
Rational Software
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).
11 © 2009 Binary Computer Services Ltd
Rational Software
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.
12 © 2009 Binary Computer Services Ltd
Rational Software
Demo
13 © 2009 Binary Computer Services Ltd
Rational Software
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.
14 © 2009 Binary Computer Services Ltd
Rational Software
Q & A
e-mail: [email protected] www.binarycomputer.co.uk
Binary Computer Services Ltd