JReport Enables Cloud Reporting through Amazon EC2, Database.com

JReport Enables Cloud
Reporting through Amazon
EC2, Database.com

Tyler Wilchek

Marketing Manager


Jinfonet Software

Rockville, MD

Greg Harris

Sr. Product Engineer


Jinfonet Software

Rockville, MD

Agenda

1.
Introduction

2.
Flexible Architecture Options

3.
Compatibility with Cloud Environments

4.
Amazon EC2 Preview

5.
High Performance Testing (Amazon EC2)

6.
Powerful Visualization

7.
Software Demo of JReport

8.
Q&A


Jinfonet Software

•
Our Mission:



To simplify information delivery and data presentation for enterprise applications.


•
About Jinfonet Software:

–
Privately Held, Self
-
funded, Debt
-
free

–
Profitable with Significant Re
-
investment in R&D

–
Over 160 Java Developers Continue to Enhance JReport

–
First to Offer Embedded Reporting for Java Apps in 1998



Introduction to JReport

BI platform

vendor

solutions

Enterprise capabilities

Higher cost & complexity

Vendor lock
-
in

Open source

BI solutions

Focused features

& lower cost

Agile development

Higher risk

Positioned in the
sweet spot between
high complexity BI
platforms and high
risk open source

Government

Software /
Consulting

Healthcare /
Healthcare
Insurance

Telecom

Consumer /
Manufacturing

Financial
Services

5

Customers who Have Implemented
Operational BI with JReport

BI and Cloud Computing

“Either we get on the cloud train or we get run over by it”

–
Linda Briggs, TDWI


•
Forrester on Cloud market

–
Global market will grow from $40.7B in 2011 to $241B in 2020

–
Public clouds like Amazon will be $159.3B of the $241B

•
Impact on BI is unavoidable

•
Empowers small companies and business units to create
their own BI initiatives

•
Barriers

–
Security and data privacy

–
How to access local and cloud data

Types of Cloud Environments

•
IaaS (Infrastructure
-
as
-
a
-
Service)

–
Provides raw computing power and storage

–
Forrester says it will reach peak in 2014 and taper off

–
Vendors: Rackspace, Microsoft, Google, Amazon

•
PaaS (Platform
-
as
-
a
-
Service)

–
Middleware for the cloud, provides hardware, software and
network services

–
PaaS is used to host apps in a virtual private cloud

–
Forester expects steady growth through 2020

–
Vendors: Windows Azure, Tibco, Cordys, Force.com, etc.

•
SaaS (Software
-
as
-
a
-
Service)

–
Entire application is provided as a service, CRM, ERP, etc.

–
Forester says it will be over 25% of total packaged software
market by 2016

A Perfect Fit for the Cloud

•
Seamlessly Integrated

•
Deployed in 4+ Architecture Options

•
Compatible with all cloud environments:

–
Private

–
Public

–
Hybrid


TIER 1

TIER 3

TIER 2

Option 1
-

Run Reporting as a Standalone Reporting Application without any
integration with a customers application

JReport


Server

Browser

JDBC

ODBC

UDS

Fetch
Data

Legacy

Java Objects

XML

RDBMS

Run Reports &
Access Results

TIER 1

TIER 3

TIER 2

Option 2
-

Run Reporting as a Standalone Reporting Application but integrate
with a remote web application using RMI

Browser

Fetch
Data

Legacy

Java Objects

XML

RDBMS

Run Reports &
Access Results

JReport

Server

Application

RMI

Application Server

JDBC

ODBC

UDS

TIER 1

TIER 3

TIER 2

Option 3
-

Run Reporting as a web application integrated in the same VM as the
customers application

Browser

Legacy

Java Objects

XML

RDBMS

Run Reports &
Access Results

Application Server

JReport

Server

Custom

Application

Application Server

JDBC/UDS

TIER 1

TIER 3

TIER 2

Option 4
-

Run Reporting as part of a Portal

Browser

Fetch
Data

Legacy

Java Objects

XML

RDBMS

Run Reports &
Access Results

Application Server

JReport Server






Portal

Portlet

Portlet

Portlet

Portlet

RMI

RMI

RMI

RMI

JDBC

ODBC

UDS

JReport and Private Clouds

13

•
IT provides instant provisioning for new applications

•
Flexible use of all internal IT infrastructure to maximize ROI for
resources

PDF

Excel

RTF

CSV

Email

Fax

Printer

Repository

Client
Browser

Web
Service

Private Cloud

Your

Application

JReport

Server

DBMS

JReport and Public Clouds

14

PDF

Excel

RTF

CSV

Email

Fax

Printer

Repository

Client
Browser

Public Cloud

Your

Application

JReport

Server

DBMS

•
Amazon EC2, Windows Azure, etc.

•
Instantly provision, scale, fund

•
No capitol investment required

Database.
com

Amazon
S3

JReport and Hybrid Clouds

15

•
Instantly provision for spikes in resource demand

•
No capitol funding

PDF

Excel

RTF

CSV

Email

Fax

Printer

Repository

Client
Browser

Database.
com

Public and Private Clouds

Your

Application

JReport

Server

DBMS

Amazon
S3

JReport and Virtual Machines

16

PDF

Excel

RTF

CSV

Email

Fax

Printer

Repository

Client
Browser

Web
Service

Virtual Machine

Your

Application

JReport

Server

DBMS

•
VMWare, Microsoft Virtual PC, Oracle VM, etc

•
Single install and start of entire application

JReport Can Access Cloud Data

17

PDF

Excel

RTF

CSV

Email

Fax

Printer

Repository

Client
Browser

Database.
com

Cloud Data

Public or Private Cloud

Your

Application

JReport

Server

Amazon
S3

DBMS

•
Integrate local and cloud data

•
Lower cloud costs for data transfer

18

Benchmark Description

•
TCP
-
H test data
–

10 million total records

•
SQL Server 2008 Database

•
Average query returns 5000 records

•
Reports vary from 1 page to 500 pages

•
Combination of DBMS fields, formulas, images
and labels

•
JReport scheduler for batch reports

•
Browser load simulator for on
-
demand and Studio
actions

•
EC2 Compute Unit has equivalent CPU capacity of
a 1.0 GHz 2007 Opteron

Batch Generation

•
Horizontal scaling averages 87% per added node

•
Add low cost servers

Batch Generation

•
Vertical and horizontal scaling

•
Horizontal scaling may be more cost effective

21

Interactive Studio Reports

•
Keep response time constant by adding nodes

JReport: Key Differentiators

•
100% Java

•
Designed for Embedded Reporting

–
Small Installation Footprint

–
Also Supports “Standalone” Reporting

•
End
-
user Thin Client

–
100% Server
-
based, No Controls Downloaded to User

•
Greater richness & options in GUI w/o programming

•
Dedicated to Customer Success

•
Lower TCO

JReport: Standards and Compliance

•
JAVA Standards Based

–
JDK 1.6 or above,

–
Java Authentication and Authorization Services (JAAS)

–
JNDI application server naming and connection pool support

–
Java EE Web Application (Tomcat, JBoss, etc.)

–
Thin client browser based report creation and viewing

•
Federal regulatory

–
Section 508
-

electronic and information technology is
accessible to people with disabilities

–
Standard HTML, XML, Excel and PDF output formats

•
Portal servers

–
JSR 168 portlets



JReport: Security & Control

•
Integration with single sign on

•
Complete security functionality in JReport

–
Roles, Groups, users and inheritance

–
Signature certificates

–
Encryption

–
Role base security
–

based on LDAP or custom sources

–
Watermarks

–
Row level security

•
Tie to sign
-
ons

•
Groups of users
–

access
–

view
–

maintain
–

update

•
Control of Access to Reports

JReport 10 Supports Two Web Report Types:



Web Layout Report
vs.
Page Layout Report

On screen filter
and control

Chart navigation

Table navigation

Page navigation

Pixel perfect

Paper sized

JReport Visualization

Rich Internet Application (RIA)

•
Easy
-
to
-
use tools for developing rich,
interactive applications

•
End
-
users access and interact with
dashboards and reports and create ad hoc
reports from the browser

Dashboards, Charting and Tables

•
Tabular layout with synchronized auto
-
refresh components

•
New bullet, gauge, bubble charts

Quick Interactions

•
Users can easily modify their data view and
perform “what
-
if” analysis with on screen
filters and cascading parameters

•
Expand and collapse grouped data, and
convert chart and table types

26

Visualization with Charts

27

Bar

Bench

Line

Area

Pie

Doughnut

Combo: Line + Area

Combo: Line + Bar

Full Gauge

Linear Gauge

Bubble Gauge

Bubble

Bullet

Stock

Radar

Half Gauge

Quarter Gauge

Scatter

Spark Line

Interaction using Web Controls

28

Icon/Image Control

Drop Down List Control

Form Control

Radio Button Control

Slider Control

Filter Control

Interact with your Data

29

Drill on Chart

Link Report

Drill on Crosstab

Conditional Formatting

Go to Detail

Why JReport and Cloud Data

•
Business Intelligence for your Cloud applications

•
Easily design the reports you need to make sense of
overwhelming amounts of Data

•
Data Visualization: see relationships and trends

•
“Ask Questions” of your Data

•
Actionable information at your fingertips

•
Self
-
service gives users the power to understand their data

Join us for our next webinar

Go to our home page to register today!

http://www.Jinfonet.com



Version 10.1: Easily Create & Modify JDashboards

to Improve Data Visualization

Wednesday, June 8 at 2 PM

Q & A

Type your question in the chat box now!




Contact us:

Web:
http://www.Jinfonet.com

E
-
Mail:
GregHarris@Jinfonet.com

Sales:
Sales@Jinfonet.com

Phone: 240
-
477
-
1000