JReport Enables Cloud Reporting through Amazon EC 2

JReport Enables Cloud Reporting through Amazon EC 2, Database. com Tyler Wilchek Marketing Manager Greg Harris Sr. Product Engineer Jinfonet Software Rockville, MD

Agenda 1. 2. 3. 4. 5. 6. 7. 8. Introduction Flexible Architecture Options Compatibility with Cloud Environments Amazon EC 2 Preview High Performance Testing (Amazon EC 2) Powerful Visualization Software Demo of JReport 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 Enterprise capabilities Higher cost & complexity Vendor lock-in BI platform vendor solutions Positioned in the sweet spot between high complexity BI platforms and high risk open source Open source BI solutions Focused features & lower cost Agile development Higher risk

Customers who Have Implemented Operational BI with JReport Financial Services Consumer / Manufacturing Telecom Healthcare / Healthcare Insurance Software / Consulting Government 5

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. 7 B in 2011 to $241 B in 2020 – Public clouds like Amazon will be $159. 3 B of the $241 B • 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 • Iaa. S (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 • Paa. S (Platform-as-a-Service) – Middleware for the cloud, provides hardware, software and network services – Paa. S is used to host apps in a virtual private cloud – Forester expects steady growth through 2020 – Vendors: Windows Azure, Tibco, Cordys, Force. com, etc. • Saa. S (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

Option 1 - Run Reporting as a Standalone Reporting Application without any integration with a customers application TIER 1 TIER 2 TIER 3 RDBMS Browser Run Reports & Access Results JReport Server JDBC ODBC UDS Fetch Data Legacy Java Objects XML

Option 2 - Run Reporting as a Standalone Reporting Application but integrate with a remote web application using RMI TIER 1 TIER 2 TIER 3 Application RMI Browser Run Reports & Access Results JReport Server Application Server RDBMS JDBC ODBC UDS Fetch Data Legacy Java Objects XML

Option 3 - Run Reporting as a web application integrated in the same VM as the customers application TIER 1 TIER 2 TIER 3 Application Server RDBMS Browser Run Reports & Access Results Custom Application JDBC/UDS Legacy JReport Application Server Java Objects XML

Option 4 - Run Reporting as part of a Portal TIER 1 TIER 2 TIER 3 Portal Portlet RMI Browser Portlet RMI Run Reports & Access Results RDBMS JDBC ODBC UDS Fetch Data Legacy JReport Server Application Server Java Objects XML

JReport and Private Clouds • IT provides instant provisioning for new applications • Flexible use of all internal IT infrastructure to maximize ROI for resources Private Cloud DBMS Your Application Web Service Client Browser JReport Server Email Fax Printer Repository PDF Excel RTF CSV 13

JReport and Public Clouds • Amazon EC 2, Windows Azure, etc. • Instantly provision, scale, fund • No capitol investment required Public Cloud Your Application DBMS Client Browser JReport Server Database. com Amazon S 3 Email Fax Printer Repository PDF Excel RTF CSV 14

JReport and Hybrid Clouds • Instantly provision for spikes in resource demand • No capitol funding Public and Private Clouds Your Application DBMS Client Browser JReport Server Database. com Amazon S 3 Email Fax Printer Repository PDF Excel RTF CSV 15

JReport and Virtual Machines • VMWare, Microsoft Virtual PC, Oracle VM, etc • Single install and start of entire application Virtual Machine DBMS Your Application Web Service Client Browser JReport Server Email Fax Printer Repository PDF Excel RTF CSV 16

JReport Can Access Cloud Data • Integrate local and cloud data • Lower cloud costs for data transfer Cloud Data Public or Private Cloud Amazon S 3 Your Application Database. com Client Browser JReport Server DBMS Email Fax Printer Repository PDF Excel RTF CSV 17

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 Studio actions • EC 2 Compute Unit has equivalent CPU capacity of a 1. 0 GHz 2007 Opteron 18

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

Interactive Studio Reports • Keep response time constant by adding nodes 21

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 Paper sized On screen filter and control Chart navigation Pixel perfect Table navigation Page navigation

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 autorefresh 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 collapse grouped data, and convert chart and table types 26

Visualization with Charts Bar Bench Combo: Line + Area Full Gauge Bubble Line Quarter Gauge Bullet Doughnut Area Combo: Line + Bar Half Gauge Scatter Pie Linear Gauge Spark Line Stock Bubble Gauge Radar 27

Interaction using Web Controls Icon/Image Control Radio Button Control Drop Down List Control Form Control Slider Control Filter Control 28

Interact with your Data Link Report Go to Detail Drill on Chart Drill on Crosstab Conditional Formatting 29

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: Greg. Harris@Jinfonet. com Sales: Sales@Jinfonet. com Phone: 240 -477 -1000