DB2 Web Query and

basesprocketΔιαχείριση Δεδομένων

31 Οκτ 2013 (πριν από 3 χρόνια και 9 μήνες)

158 εμφανίσεις

Chris Banks

Information Builders

June 17, 2008


Taking Reporting on System i to the next level!

Your business. No barriers.


DB2 Web Query and

MMSA Meeting


June 17, 2008

Agenda



Information Builders Corporate Overview



Introduction to DB2 Web Query



Introduction to WebFOCUS



Demonstration



Questions & Answers



Copyright 2007, Information Builders. Slide
3

Who is Information Builders?



Information Builders

Corporate Background


A major independent global software vendor


33 years of experience


We provide a unique combination


Enterprise Integration


Business Intelligence


Backed by Professional Services


We are known for:


Superior engineering


Top rated customer service


We have 12,000+ customer sites
supporting millions of users


Significant partnerships

Copyright 2007, Information Builders. Slide
4

20,000+

Copyright 2007, Information Builders. Slide
5

Information Builders

Our Customers Are Our Mission



City of Richmond PD

La Barge

Hillman Group

Saint George Bank

Information Builders

2007 Computerworld Smithsonian Honors

Jefferson Medical

Air Canada

Caja General de Ahorros, Spain

Copyright 2007, Information Builders. Slide
7

Information Builders

Our Customers Are Our Mission

2007 Gartner BI Excellence Award

2007 TDWI Best Practices Award

Copyright 2007, Information Builders. Slide
8

What is DB2 Web Query?



Business Intelligence

CIO Priorities

Copyright 2007, Information Builders. Slide
9

Top 10 Business Priorities

Ranking

Top 10 Technology Priorities

Ranking

Business process improvement

1

Business intelligence applications

1

Attracting and retaining new customers

2

Enterprise applications (ERP, CRM and
others)

2

Creating new products and services (innovation)

3

Servers and storage technologies

3

Expanding into new markets or geographies

4

Legacy modernization, upgrade or
enhancement

4

Reducing enterprise costs

5

Technical infrastructure

5

Improving enterprise workforce effectiveness

6

Security technologies

6

Expanding current customer relationships

7

Networking, voice and data

7

Increasing the use of information and analytics

8

Collaboration technologies

8

Targeting customers and markets more effectively

9

Document management

9

Acquiring new companies and capabilities (mergers
and acquisitions)

10

Service
-
oriented architecture (SOA) and
service
-
oriented business applications
(SOBA)

10

Table 1

Top 10 Business and Technology Priorities in 2008


Source: Gartner EXP (January 2008)


IBM announced that Query/400 was no longer going to be enhanced/maintained

DB2 Web Query

What is DB2 Web Query?

IBM wanted to:



Web
-
enable Query/400 reports


Easy for analysts to use


Highly productive report design environment


Take full advantage of DB2 features in V5R4


Attractive price point


DB2 Web Query

What is DB2 Web Query?

DB2/400

System i

Most BI Vendors Today

Don’t take advantage of the System i


DB2/400

System i

Windows

Most BI Vendors Today

Don’t take advantage of the System i


Web Server


DB2/400

System i

WebFOCUS

Optimized access to System i data

Web Server


Java App Server


-

WebFOCUS web application


WebFOCUS reporting server



COBOL

RPG

pgms

JD

Edwards

SAP

Query/400

System i

System x

System

z

System p

IBM wanted to:



Web
-
enable Query/400 reports


Easy for analysts to use


Highly productive report design environment


Take full advantage of DB2 features in V5R4


Attractive price point


Information Builders built:

DB/2 Web Query for System i, a simplified version of


DB2 Web Query

What is DB2 Web Query?

For more details, refer to:
http://www.ibm.com/systems/i/software/db2/webquery


A Web
-
based query and report
writing product that replaces
Query/400


Base Product


Report and Graph Assistants


Power Painter


Spreadsheet integration


Web
-
enable existing
Query/400 reports


Additional IBM Features


Active Reports
(Disconnected Analytics)


On Line Analytical Processing
(OLAP)


Developer Workbench

DB2 Web Query

What is DB2 Web Query?

DB2 Web Query

What is DB2 Web Query?

DB2 Web Query

Report Assistant: Drill Down

DB2 Web Query

Graph Assistant


DB2 Web Query

Preserve Investment in Query/400

Then Modify with

Report

Assistant

DB2 Web Query

Add
-
on: Active Reports

DB2 Web Query

Add
-
on: Active Reports

DB2 Web Query

Add
-
on: Active Reports


Self
-
contained analytical reports


Delivered to users via email* or browser



Users interact with the data on the report
w/o being connected to a network infrastructure



Intuitive built
-
in controls


Sorting, Filtering, Visualization,
Charting, Dynamic Roll
-
ups


Export to HTML, CSV or Excel


Export Charts to Word, Excel, or PowerPoint



Great for mobile users that are not connected
or even defined as a user on the System i

DB2 Web Query

Add
-
on: On
-
Line Analytical Processing (OLAP)


DB2 Web Query is sold by IBM
and their resellers
ONLY



DB2 Web Query is an
internal query and reporting tool


It is NOT (nor sold as) a BI application



As an IBM customer, if you had Query/400,
you get a copy of DB2 Web Query


Ordered by IBM or reseller


# of users depends on size of machine



IBM (and their resellers) make $$$
by selling:


Support (maintenance)


More Users


Add on Features: OLAP, Active Reports








DB2 Web Query

Does Information Builders sell DB2 Web Query?


Easy to acquire, install
and learn


Integrated purely into the
System i environment


Powerful analytical and
reporting capabilities


Information presented in a
variety of formats, via a
browser



It isn’t
green




DB2 Web Query

Why you want it!

Copyright 2007, Information Builders. Slide
27

An Introduction to WebFOCUS



Copyright 2007, Information Builders. Slide
28

Pervasive Business Intelligence

Opportunity for Improvement


Most organizations access and analyze less
than
20%

of their data assets, minimizing the
return on their overall IT investment.

Most organizations have deployed BI capabilities
to fewer than
10%

of their internal users.


Applications

Transactions

Databases

Messages

Documents

Services

Pervasive Business Intelligence

Are We There Yet ?


Most vendors create tools for
power users


Try to simplify these tools and
deploy to non
-
technical users


Forces customers to do
extensive data modeling


Results in unused licenses,
failed projects and low ROI


Users are limited to static
information at a premium
investment

Copyright 2007, Information Builders. Slide
29

Intuitive

BI applications

Ad
-
hoc

tools

Business users need information, not tools!

Copyright 2007, Information Builders. Slide
30

Internet Intelligence in Everyday Life

What makes a great web application?


Internet application characteristics for the consumer:


They are easy to use and can be used with no training


They save a tremendous amount of time


They provide something useful


They are accessible by everyone



Internet application characteristics for the producer:


They provide greater value at a lower cost (TCO)


They grow business on a 24x7x365 calendar


They provide better management of customer interaction


Copyright 2007, Information Builders. Slide
31

eBay


Knocking Down Barriers to Success


eBay Online Marketplace


181 million registered users


78 million listings worldwide at any given time


6 million added per day


Global presence in 33 markets


eBay average user 1hr 54m


eBay average user views 280 pages per month

Age not a
factor: over
20% of users
are 50+

Copyright 2007, Information Builders. Slide
32

How Do They Do It?
















Ease of use

No training required

Information Builders’ WebFOCUS

A True Business Intelligence Platform

Copyright 2007, Information Builders. Slide
33

IBM

System z

IBM

System i

All Linux

All Unix

Windows

CICS

Information Builders’ WebFOCUS

Business Intelligence for Executive Management

Dashboards

Performance Metrics,

KPI’s & Scorecards

Financial Reports/

Production Documents

Information Builders’ WebFOCUS

Business Intelligence for Back Office Analysts

Query, Analysis

& Excel Integration

Data Visualization

& Analytical Dashboards

Geographical

Analysis

Enterprise Search

Information Builders’ WebFOCUS

Business Intelligence for Operational Employees

BI Applications

& Self
-
Service Reporting

Operational Dashboards

& Performance Metrics

MS
-
Office Integration

PDF Publishing

WebFOCUS Self
-
service Application

WebFOCUS Self
-
service Application

WebFOCUS Self
-
service Application

WebFOCUS Self
-
service Application

WebFOCUS Self
-
service Application

Information Builders’ WebFOCUS

Business Intelligence for Field Staff, Partners & Customers

Easy To Use

BI Applications

Statements

& Invoices

Active Reports


& Dashboards

(Portable Analytics)

Dimensions

Measures

Ranking Options

Drill downs

Filters

Output Formats

10 x 7 x 4 x 2 x 4 x 3 x 15 x 15 x 3 = 4,536,000


1 report from IT


4,536,000 reports for end
-
users


No training involved!

Information Builders’ WebFOCUS

Business Intelligence for Field Staff, Partners & Customers

Easy To Use

BI Applications

Statements

& Invoices

Active Reports


& Dashboards

(Portable Analytics)

Information Builders’ WebFOCUS

Production Distribution

Published Documents,

Statements & Invoices

Active Reports


& Analytics

All Mobile Devices

Archive

Excel, Powerpoint,

Adobe PDF & e
-
mail

High
-
scale
distribution.

-

Scheduled &

Real time alerts

Information Builders’ WebFOCUS

Delivers Information Users Can Use


NASA



600 Contractors



30 Million Parts



1 Simple Management
System


Verizon



Over 200 Applications



Running on All platforms


For Example…



Process and Operational
Efficiency Management
System (POEMS)



Used by Execs to Field
Technicians


Target



40,000 Users



6,700 Stores



4.4 Million Report
requests/month


Hillman Group



Medium
-
sized business



1,000 daily users



Real
-
time production data
from 4 different systems



2 Developers

Information Builders’ WebFOCUS

Big Impact At The Lowest TCO

Copyright 2007, Information Builders. Slide
49

2,000,000 users

3 support personnel

85,000 users

3 support personnel

60,000 users

1.5 support personnel

1,500 users

5 support personnel

7,000 users

5 support personnel

University of North Carolina

16 campuses

200,000 users

2 support personnel

85,000 investment professionals

5 support personnel

20,000 users

4 support personnel

The best user to support staff ratio in the industry!

Information Builders’ WebFOCUS

Our strategy is a
little

different


WebFOCUS makes Pervasive BI a reality


Ease of Use & Customization


Minimal/No Training required


Industry leading Enterprise Integration


Platform/data agnostic


Scalability to millions of users


Flexible Pricing and Low TCO


Support, Expertise & Best Practices



Copyright 2007, Information Builders. Slide
50

Everyone is a Decision Maker!

Copyright 2007, Information Builders. Slide
51

So exactly what functionality does WebFOCUS
provide that DB2 Web Query doesn’t have?



WebFOCUS has all the functionality that

DB2 Web Query provides, plus:



Ability to create Self
-
service applications


Ability to create Dashboards (five types)


Satisfies
ANY

reporting requirement


Data Visualization


Report Distribution


Connectivity to anything in your enterprise


ERP, SCM, CRM, legacy data, RDBMS


Tie Action to Information



WebFOCUS vs DB2 Web Query

Differences