Transcript Title of Your Presentation

iWay Web Services and WebFOCUS Consumption
Michael Florkowski
Information Builders
Copyright 2007, Information Builders. Slide 1
Agenda
 Web Services Overview
 Describing a Web Service to WebFOCUS
 Demonstration
 Questions????
Copyright 2007, Information Builders. Slide 2
Web Services Overview
What are Web Services?
A Web Service
 is a procedure that has all the logic, and access
requirements to perform a given task when called to do
so.
 uses the internet as an huge Application Server.
 provides the calling procedure with the necessary
information about the web service through an XML
document known as the WSDL.
Copyright 2007, Information Builders. Slide 3
Web Services Overview
What makes Web Services so desirable?
Web Services are:
 reusable, self-contained, self-describing, application
programs, providing a specific functionality.
 purposely built to be executed, described, and discovered,
over the internet, regardless of enterprise boundaries and
firewalls. (Still very efficient inside an intranet or network!)
 provide a layer of abstraction to user, allowing them not to
worry about “physical” details such as
 Programming languages
 Communication protocols
 support a concept of a “Registry” where users can
“discover” web services that may be of use to them
Copyright 2007, Information Builders. Slide 4
Web Services Overview
What makes Web Services so flexible?
Use of well known standards for:
 SOAP (Simple Object Access Protocol) – Message format
for invoking Web Services.
 WSDL (Web Service Definition Language) – A standard
for
describing Web Services.
 XML (Extensible Mark-up Language) – A platform/operating
system independent document format that SOAP and
WSDL use. (XML is both computer AND people friendly!)
 The Registry (not fully standardized) – a repository of
“categorized” registered Web Services (similar to the
Yellow Pages)
 UDDI – Most common registry
Copyright 2007, Information Builders. Slide 5
Web Services Overview
How are Web Services used?
Web Services are used
 to perform application-to-application integration over the
Web.
 as business process interfaces.
 as a point of interaction to give input and receive output
from a business process.
 to allow previously incompatible applications to interoperate
on the Web regardless of language, platform, and operating
systems.
 as a standalone function that can be called by many
different applications.
Copyright 2007, Information Builders. Slide 6
Web Services Overview
What are the benefits of using web services?
Web Services

reduce complexity by encapsulating business processes into
reusable components.

improve interoperability by acting as a wrapper around legacy or
platform-specific applications.

promote true interoperability through platform and
implementation neutrality.

are self-describing (WSDL,UDDI).

allow developers to develop applications much faster than before

are a simple, reliable way to blend existing systems with new
applications and services
Copyright 2007, Information Builders. Slide 7
Using iWay to create a Web Service
iWay components needed
To create an iWay web Service you will need the following
three iWay products installed and configured:
 iWay Service Manager (iSM)
 iWay Explorer (iE)
Copyright 2007, Information Builders. Slide 8
iWay Service Manager
 iWay Service Manager (iSM)
 Host for Service-Oriented



Architecture
Supports configuring iWay
Adapters of all types
J2SE Environment (Server)
Supports other iWay
Components
 iWay Transformer
 iWay Designer
 iWay Explorer
Copyright 2007, Information Builders. Slide 9
iWay Explorer
 iWay Explorer
 Allows exploration of EIS via



the adapter
Creates XML Schemas for
Request/Response (Service)
Creates XML Schemas for
Result (Event)
Consistent view of all
Enterprise Systems
Copyright 2007, Information Builders. Slide 10
Using iWay to create a Web Service
iWay Business Services Provider
 The SOAP End Point for iWay Business Services
 HTTPS Server that exchanges SOAP messages with Web
Service client applications
 Loads, or calls, necessary iWay Adapter based on SOAP
message
 Maintains an IBS Repository (db) where physical connectivity
and security info needed to run the backend object
 A form of a Registry
 Portable – can be installed on all major computing platforms
 Has Web Console (default port 9999)
Copyright 2007, Information Builders. Slide 11
Describing a Web Service to WebFOCUS
WebFOCUS components needed
To describe a web Service to WebFOCUS you will need the
following two WebFOCUS products installed and configured:
 WebFOCUS Reporting Server
 WebFOCUS Web Services Adapter
Copyright 2007, Information Builders. Slide 12
Describing a Web Service to WebFOCUS
WebFOCUS Reporting Server
WebFOCUS Reporting Server
 Holds metadata for the data sources WebFOCUS can access,
and controls access to those data sources.
 It is responsible for executing the queries against these data
sources and retrieving and formatting the query results, which
it then passes to the WebFOCUS client.
 It provides multiple data adapters that give users access to
data in many different types of data sources.
Copyright 2007, Information Builders. Slide 13
Describing a Web Service to WebFOCUS
WebFOCUS Web Services Adapter Overview
WebFOCUS Web Services Adapter:
 allows WebFOCUS to directly interact with a Web Service.
 is able to create a report to read data returned from a Web Service.
 can pass parameters to a Web Service for reporting.
 can pass parameters to a Web Service for updating data within an
application.
 is able to consume a WSDL file.
 can join Web Services to Other Web Services.
 can join Web Services to other Table types (e.g.. SQL Server,
ORACLE, DB/2).
Copyright 2007, Information Builders. Slide 14
Describing a Web Service to WebFOCUS
How does the Web Services Adapter work?
WebFOCUS Web Services Adapter:
 reads a WSDL file and creates the Connection information in
EDASPROF.
 reads a WSDL file and creates the Master and Access file for a
particular Web Service function.
 has a new suffix: Suffix=SOAP.
 1st Segment of the Master contain the input parameters.
 Reads Data Types and maps them to default Formats (USAGE and
ACTUAL).
 Arrays of output get mapped to multiple segments.
Copyright 2007, Information Builders. Slide 15
Let’s build it!
Copyright © 2001 iWay Software
Copyright 2007, Information Builders. Slide 16
2
Start iWay Explorer
iWay Configurations
Copyright 2007, Information Builders. Slide 17
Create a Configuration
Copyright 2007, Information Builders. Slide 18
Connect to new Configuration
Copyright 2007, Information Builders. Slide 19
Select iWay Adapters
Copyright 2007, Information Builders. Slide 20
Choose RDBMS Adapter
Copyright 2007, Information Builders. Slide 21
Configure RDBMS Adapter for
MS SQL Server
Copyright 2007, Information Builders. Slide 22
Test Connection to SQL Server
Copyright 2007, Information Builders. Slide 23
Select a Stored Procedure
Copyright 2007, Information Builders. Slide 24
Generate an iWay Business Service
Copyright 2007, Information Builders. Slide 25
Name the Web Service
Copyright 2007, Information Builders. Slide 26
Test the Business Service
Copyright 2007, Information Builders. Slide 27
Enter Customer ID and Invoke
Copyright 2007, Information Builders. Slide 28
Web Service Response Document
Copyright 2007, Information Builders. Slide 29
View WSDL for the iWay Business Service
Copyright 2007, Information Builders. Slide 30
Open the WebFOCUS Reporting Server Console and
Click Data Adapters
Copyright 2007, Information Builders. Slide 31
Select New Adapter Tab
Copyright 2007, Information Builders. Slide 32
Select Procedures Adapter
Copyright 2007, Information Builders. Slide 33
Select Web Services
Copyright 2007, Information Builders. Slide 34
Enter Name and WSDL location
http://localhost:9000/test/CustOrdersOrders_WS.ibs?wsdl
Copyright 2007, Information Builders. Slide 35
Select Web Service End Point
Copyright 2007, Information Builders. Slide 36
Connection Configuration complete!
Copyright 2007, Information Builders. Slide 37
Create WebFOCUS Synonym for the Web Service
Copyright 2007, Information Builders. Slide 38
Synonym created Successfully!
Copyright 2007, Information Builders. Slide 39
Test Synonym
Copyright 2007, Information Builders. Slide 40
Provide Value for the input parameter
Copyright 2007, Information Builders. Slide 41
See Results!
Copyright 2007, Information Builders. Slide 42
Create a FOCUS Query
Copyright 2007, Information Builders. Slide 43
See Report!
Copyright 2007, Information Builders. Slide 44
Questions????
Anyone ?
Anyone ?
Anyone ?
Anyone ?
Copyright 2007, Information Builders. Slide 45
Thank You
Copyright 2007, Information Builders. Slide 46