Transcript Title of Your Presentation

Build Real-Time BI Dashboards With Flex
and WebFOCUS Web Services
Paulo Tavares
Sr. Systems Engineer
June, 2008
Copyright 2008, Information Builders. Slide 1
OBJECTIVE
 To provide a road map to create new generation of
interactive dashboards using WebFOCUS Flex Enable and
WebFOCUS Web Services
Copyright 2007, Information Builders. Slide 2
MAIN OBJECTIVE
INSPIRE YOU
Copyright 2007, Information Builders. Slide 3
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 4
Intro to WebFOCUS Web Services
Copyright 2007, Information Builders. Slide 5
Intro to WebFOCUS Web Services
What is a Web Service?
 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
Copyright 2007, Information Builders. Slide 6
DEPARTMENTS
Intro to WebFOCUS Web Services
Web Service Scenarios: Department to Department
ACCOUNTING
.NET APPLICATION
SALES
What info can I get?
JAVA APPLICATION
WSDL (.XML)
WS
operation:
getRevenue
parameter(s):
customerId
output
revenue
getRevenue(“123”)
DATA (.XML)
<customer>
<id>123</id>
<rev>1200</rev>
</customer>
Copyright 2007, Information Builders. Slide 7
COMPANIES
Intro to WebFOCUS Web Services
Web Service Scenarios: Company to Company
COMPANY A
COMPANY B
.NET APPLICATION
What info can I get?
JAVA APPLICATION
WSDL (.XML)
WS
operation:
getRevenue
parameter(s):
customerId
output
revenue
getRevenue(“123”)
DATA (.XML)
<customer>
<id>123</id>
<rev>1200</rev>
</customer>
Copyright 2007, Information Builders. Slide 8
COMPANIES
Intro to WebFOCUS Web Services
Web Service Scenarios: Company to Companies
COMPANY B
COMPANY C
COMPANY D
JAVA APPLICATION
.NET APPLICATION
.NET APPLICATION
COMPANY E
COMPANY F
COMPANY G
FLEX APPLICATION
.NET APPLICATION
JAVA APPLICATION
COMPANY A
CRM APPLICATION
WS
Copyright 2007, Information Builders. Slide 9
Intro to WebFOCUS Web Services
What is WebFOCUS Web Service?
 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
Copyright 2007, Information Builders. Slide 10
COMPANIES
Intro to WebFOCUS Web Services
WebFOCUS Web Services Scenario
COMPANY B
COMPANY C
COMPANY D
JAVA APPLICATION
WEBFOCUS
APP
.NET
APPLICATION
.NET APPLICATION
COMPANY E
COMPANY F
COMPANY G
JAVA
WEBFOCUS
APPLICATION
APP
JAVA APPLICATION
JAVA APPLICATION
COMPANY A
CRM
.NET
WEBFOCUS
APPLICATION
APP
WS
Copyright 2007, Information Builders. Slide 11
Intro to WebFOCUS Flex
Copyright 2007, Information Builders. Slide 12
Intro to WebFOCUS Flex
What is Flex?
 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)
Copyright 2007, Information Builders. Slide 13
Intro to WebFOCUS Flex
What is WebFOCUS Flex?
 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
Copyright 2007, Information Builders. Slide 14
Case Study: Credit Card Statement Dashboard
Copyright 2007, Information Builders. Slide 15
Case Study: Credit Card Statement Dashboard
Before Scenario
CHARGES
CREDIT CARD USERS
CREDIT CARD STATEMENT
HUSBAND
Account Holder
DATE
PAYEE
01/01/2008 TARGET
AMOUNT
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
WIFE
Authorized User
NOT GOOD ENOUGH FOR ANALYSIS
SON
Authorized User
Copyright 2007, Information Builders. Slide 16
Case Study: Credit Card Statement Dashboard
After Scenario
CHARGES
CREDIT CARD USERS
CREDIT CARD
DASHBOARD
HUSBAND
Account Holder
WIFE
Authorized User
SON
Authorized User
Copyright 2007, Information Builders. Slide 17
Case Study: Credit Card
Implementation Architecture: INGREDIENTS
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 18
Case Study: Credit Card
Implementation Steps (Recipe): REGISTERING TRANSACTIONS
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 19
Case Study: Credit Card
Implementation Steps (Recipe): LOAD DASHBOARD
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 20
Case Study: Credit Card
Implementation Steps (Recipe): LOAD DATA INTO DASHBOARD
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 21
Case Study: Credit Card
Implementation Steps (Recipe): ALERT
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 22
Case Study: Credit Card
Implementation steps (Recipe): SECURITY
CREDITCARD COMPANY
SON
BILLING COMPANY
LAPTOP
DATABSE SERVER
SQL Server Express
WEBFOCUS
REPORTING SERVER
DASHBOARD
WEB SERVER
WEBFOCUS
FLEX COMPONENTS
WEBFOCUS
MANAGED
REPORTING
INTEGRATION
WIFE
LAPTOP
WS
REPORTING/ MRE WEB SERVICE
WEBFOCUS
REPORT CASTER
webFocusRunFex
HUSBAND
WS
MAIL SERVER
ArGoSoft
LAPTOP
REPORT CASTER WEB SERVICE
addDestinationElement
Copyright 2007, Information Builders. Slide 23
SUMMARY
Copyright 2007, Information Builders. Slide 24
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 25
THE END
Thank you!
Copyright 2007, Information Builders. Slide 26