and WebFOCUS Web Services

hurtpotatocreekSecurity

Nov 5, 2013 (3 years and 11 months ago)

193 views

Copyright 2008, Information Builders. Slide
1

Build Real
-
Time BI Dashboards With Flex
and WebFOCUS Web Services

Paulo Tavares

Sr. Systems Engineer

June, 2008

Copyright 2007, Information Builders. Slide
2


To provide a road map to create new generation of
interactive dashboards using WebFOCUS Flex Enable and
WebFOCUS Web Services


OBJECTIVE

Copyright 2007, Information Builders. Slide
3


INSPIRE YOU


MAIN OBJECTIVE

Copyright 2007, Information Builders. Slide
4

AGENDA


Intro to WebFOCUS Web Services


Intro to WebFOCUS Flex Components


Case Study: Credit Card Statement Dashboard


Before Scenario (Problem)


After Scenario (Solution)


Live Demo


Implementation Architecture (Ingredients)


Implementation Steps (Recipe)


Q&A



Copyright 2007, Information Builders. Slide
5

Intro to WebFOCUS Web Services

Copyright 2007, Information Builders. Slide
6


It is an integration technology


It allows two applications written with same or different
technologies (such as JAVA, .NET, FLEX or WebFOCUS) to
communicate to each other using a Web API

Intro to WebFOCUS Web Services


What is a Web Service?

Copyright 2007, Information Builders. Slide
7

ACCOUNTING

DEPARTMENTS

SALES

DATA (.XML)

<customer>


<id>123</id>


<rev>1200</rev>

</customer>

Intro to WebFOCUS Web Services


Web Service Scenarios: Department to Department

JAVA

APPLICATION

.NET

APPLICATION

WS

WSDL (.XML)

operation:

getRevenue

parameter(s):
customerId

output

revenue

What info can I get?

getRevenue(“123”)

Copyright 2007, Information Builders. Slide
8

COMPANY B

COMPANY A

COMPANIES

Intro to WebFOCUS Web Services


Web Service Scenarios: Company to Company

JAVA

APPLICATION

.NET

APPLICATION

WS

What info can I get?

getRevenue(“123”)

WSDL (.XML)

operation:

getRevenue

parameter(s):
customerId

output

revenue

DATA (.XML)

<customer>


<id>123</id>


<rev>1200</rev>

</customer>

Copyright 2007, Information Builders. Slide
9

Intro to WebFOCUS Web Services


Web Service Scenarios: Company to Companies

COMPANIES

COMPANY A

CRM
APPLICATION

WS

COMPANY C

.NET

APPLICATION

COMPANY D

.NET

APPLICATION

COMPANY E

FLEX

APPLICATION

COMPANY G

JAVA

APPLICATION

COMPANY F

.NET

APPLICATION

COMPANY B

JAVA

APPLICATION

Copyright 2007, Information Builders. Slide
10


It is the ability to expose (publish) WebFOCUS procedures
as Web Services and to call (consume) any available Web
Services


WebFOCUS can
PUBLISH

and
CONSUME

a Web Service


Plus, WebFOCUS has the ability to publish
Managed
Reporting

and
Report Caster

functions as Web Services


Intro to WebFOCUS Web Services

What is WebFOCUS Web Service?

Copyright 2007, Information Builders. Slide
11

Intro to WebFOCUS Web Services


WebFOCUS Web Services Scenario

COMPANIES

COMPANY B

JAVA

APPLICATION

COMPANY D

.NET

APPLICATION

COMPANY G

JAVA

APPLICATION

COMPANY F

JAVA

APPLICATION

COMPANY C

.NET

APPLICATION

COMPANY E

JAVA

APPLICATION

COMPANY C

WEBFOCUS

APP

COMPANY A

CRM
APPLICATION

WS

COMPANY E

WEBFOCUS

APP

COMPANY A

.NET

APPLICATION

WS

COMPANY A

WEBFOCUS

APP

WS

Copyright 2007, Information Builders. Slide
12

Intro to WebFOCUS Flex

Copyright 2007, Information Builders. Slide
13

Copyright 2007, Information Builders. Slide
13


FLEX is a web technology created by Adobe that allows web
developers to build Rich Internet Applications (RIAs) using the
popular Flash browser plug
-
in


Adobe claims 98% of all internet users have the Flash plug
-
in
already installed


FLEX applications are built with a mix of MXML (XML based
language) and ActionScript (similar to Javascript)


Intro to WebFOCUS Flex

What is Flex?

Copyright 2007, Information Builders. Slide
14

Copyright 2007, Information Builders. Slide
14


It is a set of FLEX Business Intelligence Components that
allows developers to create with
very few lines of code or
NONE
,

Rich Internet Applications (RIA's) using Flex technology
leveraging all WebFOCUS capabilities and existing reports


WebFOCUS report data can be brought into the FLEX
application via URL calls or,


Via WebFOCUS Web Services enhancing
security

and
integration into
Managed Reporting

and
Report Caster

Intro to WebFOCUS Flex

What is WebFOCUS Flex?

Copyright 2007, Information Builders. Slide
15

Case Study: Credit Card Statement Dashboard

Copyright 2007, Information Builders. Slide
16

CHARGES

CREDIT CARD STATEMENT

CREDIT CARD USERS

Authorized User

SON

WIFE

Authorized User

HUSBAND

Account Holder

DATE PAYEE AMOUNT

01/01/2008 TARGET 12.34

01/01/2008 BEST BUY 1234

01/01/2008 PUBLIX 2.34

01/01/2008 TARGE 12.34

01/01/2008 TARGET 12.34

01/01/2008 TARGET 12.34

01/01/2008 TARGET 12.34


/01/2008 TARGET 12.34


NOT GOOD ENOUGH FOR ANALYSIS

Case Study: Credit Card Statement Dashboard


Before Scenario

Copyright 2007, Information Builders. Slide
17

CHARGES

CREDIT CARD

DASHBOARD

CREDIT CARD USERS

Authorized User

SON

WIFE

Authorized User

HUSBAND

Account Holder

Case Study: Credit Card Statement Dashboard

After Scenario

Copyright 2007, Information Builders. Slide
18

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

MAIL

SERVER

ArGoSoft

Case Study: Credit Card


Implementation Architecture:
INGREDIENTS

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

WEBFOCUS

FLEX COMPONENTS

DASHBOARD

SON

LAPTOP

WIFE

LAPTOP

HUSBAND

LAPTOP

Copyright 2007, Information Builders. Slide
19

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

SON

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

LAPTOP

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

WEBFOCUS

FLEX COMPONENTS

MAIL

SERVER

ArGoSoft

WIFE

LAPTOP

HUSBAND

LAPTOP

Case Study: Credit Card


Implementation Steps (Recipe):
REGISTERING TRANSACTIONS

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

DASHBOARD

Copyright 2007, Information Builders. Slide
20

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

SON

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

LAPTOP

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

WEBFOCUS

FLEX COMPONENTS

MAIL

SERVER

ArGoSoft

WIFE

LAPTOP

HUSBAND

LAPTOP

Case Study: Credit Card


Implementation Steps (Recipe):
LOAD DASHBOARD

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

DASHBOARD

Copyright 2007, Information Builders. Slide
21

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

SON

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

LAPTOP

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

WEBFOCUS

FLEX COMPONENTS

MAIL

SERVER

ArGoSoft

WIFE

LAPTOP

HUSBAND

LAPTOP

Case Study: Credit Card


Implementation Steps (Recipe):
LOAD DATA INTO DASHBOARD

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

DASHBOARD

Copyright 2007, Information Builders. Slide
22

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

SON

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

LAPTOP

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

WEBFOCUS

FLEX COMPONENTS

MAIL

SERVER

ArGoSoft

WIFE

LAPTOP

HUSBAND

LAPTOP

Case Study: Credit Card


Implementation Steps (Recipe):
ALERT

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

DASHBOARD

Copyright 2007, Information Builders. Slide
23

CREDITCARD COMPANY

INTEGRATION

BILLING COMPANY

SON

WEBFOCUS

REPORTING

SERVER

WEBFOCUS

REPORT CASTER

WEBFOCUS

MANAGED

REPORTING

WEB

SERVER

LAPTOP

REPORT CASTER WEB SERVICE

addDestinationElement

WS

DATABSE

SERVER

SQL Server Express

WEBFOCUS

FLEX COMPONENTS

MAIL

SERVER

ArGoSoft

WIFE

LAPTOP

HUSBAND

LAPTOP

Case Study: Credit Card


Implementation steps (Recipe):
SECURITY

REPORTING/ MRE WEB SERVICE

webFocusRunFex

WS

DASHBOARD

Copyright 2007, Information Builders. Slide
24

SUMMARY

Copyright 2007, Information Builders. Slide
25

SUMMARY


Today we took a look at how to use WebFOCUS Flex
components combined with WebFOCUS Web Services
capabilities to build real
-
time interactive dashboards

Copyright 2007, Information Builders. Slide
26

THE END


Thank you!