close

Вход

Забыли?

вход по аккаунту

код для вставкиСкачать
Rational Software
EGL/DB2 Web Query
Integration
Binary Computer Services Limited
1
© 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)
2
© 2009 Binary Computer Services Ltd
Rational Software
IBM DB2 Web Query for System i
Powered By Information Builders
• 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
–
–
–
–
–
–
3
Active Reports (Disconnected)
On Line Analytical Processing
Developer’s Workbench
Report Broker
Software Developers Tool Kit (SDK)
Additional Modules planned
For more details, refer to:
http://www.ibm.com/systems/i/software/db2/webquery
© 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
4
© 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.
5
© 2009 Binary Computer Services Ltd
Rational Software
What can be achieved with the SDK?
6
© 2009 Binary Computer Services Ltd
Rational Software
7
© 2009 Binary Computer Services Ltd
Rational Software
8
© 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.
9
© 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).
10
© 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.
11
© 2009 Binary Computer Services Ltd
Rational Software
Demo
12
© 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.
13
© 2009 Binary Computer Services Ltd
Rational Software
Q&A
e-mail: [email protected]
www.binarycomputer.co.uk
Binary Computer Services Ltd
14
© 2009 Binary Computer Services Ltd
1/--страниц
Пожаловаться на содержимое документа