Jaspersoft

hopeacceptableΛογισμικό & κατασκευή λογ/κού

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

165 εμφανίσεις

Jaspersoft Suite Overview

IRMAC Presentation

©2012 Jaspersoft Corporation. Proprietary and Confidential

1

INTRODUCTION TO JASPERSOFT ARCHITECTURE

Products in the BI Suite

Standards and APIs

Deployment, scalability and upgrades

Security

©2012 Jaspersoft Corporation. Proprietary and Confidential

2

Jaspersoft Business Intelligence Suite

©2012 Jaspersoft Corporation. Proprietary and Confidential

3

Reporting Engine

Visual Report

D
esign Environment

Ad Hoc Reports, Dashboards,

In
-
Memory Analysis
S
erver

Powerful OLAP

Data
A
nalysis

High Performance

Data Integration

Jaspersoft BI Architecture (Marketecture)

©2012 Jaspersoft Corporation. Proprietary and Confidential

4




Report
Scheduling

Scheduler

*** Business Logic: Service
API’s
***

Web Standard Customizable Front End with
Service
API’s

Extensions

Back
-
End Implementations can be Configured and/or Replaced

Reporting
Engine

OLAP

Engine

Ad Hoc
Reporting

Object
Permission

User
Authority

JasperReports
Library

OLAP
Engine

JasperReports
Server

Spring
Security

Repository

Hibernate
ORM

LDAP, JAAS, MS Active Directory, IBM
Tivoli,
SiteMinder
,
CAS

TXT

& CSV

JSR
-
168
portlets


Web Service
Integration
Interfaces:

SOAP and REST

Web Services
/

C/C++, PHP

Java API

HTTP API

XML/A (OLAP)

XML
, XML/
A

RDBMS

c
onnect any data source

Jaspersoft UI Framework

Presentation (.
css
)

Events (.
js
)

Structure (.
jsp
)

SSO

Standards and APIs

JasperReports Server Components


WAR file deployed to Java application server


Examples: Tomcat, Web Logic,
JBoss
,
tcServer
,
WebSphere
, Glassfish


Can be configured behind a load balancer


WAR file includes a Web user interface and APIs



One shared Jaspersoft Repository


Database (Oracle,
PostgreSQL
, MySQL, DB2, MS SQL Server)


Database can be configured master/slave for failover



Diverse clients


Jaspersoft web user interface (JasperReports Server
-

UI)


Web services clients (SOAP and
RESTful
)

©2012 Jaspersoft Corporation. Proprietary and Confidential

6

Scalability and Failover

©2012 Jaspersoft Corporation. Proprietary and Confidential

7

Repository

Database

Data

Sources

Email Services

External

Authentication


e.g.
SiteMinder
, CAS,

JAAS, LDAP etc.

Java application servers


JasperReports Server

deployed as WAR files

load

balancer

Browser user

Web services client

See the
JasperReports Server Ultimate Guide
, Chapter 11

SECURITY

Object, column and row based security


Single Sign On


Secure infrastructure

©2012 Jaspersoft Corporation. Proprietary and Confidential

8

Authorization: Security Permissions


Object, column, row security



“Principal Object”


JasperReports Server creates and maintains for each user session


Identifies the user


Role(s): order of precedence


Custom profile attributes: handles cases where user, tenant and role do
not suffice

©2012 Jaspersoft Corporation. Proprietary and Confidential

9

Object based security

©2012 Jaspersoft Corporation. Proprietary and Confidential

10

Different Profiles, Different Views

Typical Business User

Typical
Superuser

©2012 Jaspersoft Corporation. Proprietary and Confidential

11

Authentication: Spring Security


A variety of authentication providers come with Spring
Security, or are easily integrated:


LDAP/Active Directory


JAAS


CA
SiteMinder


CAS (Central Authentication System)


Tomcat realm


Static/in
-
memory


Custom database lookup


X509


More


Custom


©2012 Jaspersoft Corporation. Proprietary and Confidential

12

DATA INTEGRATION

Case study: Jaspersoft’s internal data
warehouse

©2012 Jaspersoft Corporation. Proprietary and Confidential

13

Internal use case:

Data Integration Requirements


Many Source Types (SFDC, XML, Web Services, CSV,
etc)


Data Cleansing/Scrubbing


Full Refresh


Incremental Refresh


Fault Tolerant (Error Handling, Auto
-
Restart and Alerting)


Scheduling with Intelligent Workflows


Performance


Rapid Time
-
to
-
Metrics






14

Internal use case:

Business Systems We Use

©2012 Jaspersoft Corporation. Proprietary and Confidential

15

salesforce.com
(53
)

-

Campaigns/Hits

(2,000,000)

-

Inquiries/Leads


(400,000)

-

Opportunities


(25,000)

-

Accounts


(32,000)

-

Contacts




(79.000)

-

Custom Objects


Intacct (50)

-

Orders

-

Invoices

-

AP/AR

-

Rev
Rec

Schedules

Others
(26)

-


Eloqua


(4,900,000)

-

Bugzilla

-

Openair

-

Jasperforge.org

-


Jaspersoft.com

-


eStore


Every 15 min

Hourly

Nightly

SOAP

App

Exchange

XML

Gateway

JDBC

Hardware


Dual Processor


Quad Core


24 GBs RAM


4 TB Raid 5


Software


ESXi


CentOS


JasperReports Server


MySQL

Internal use case:

Jaspersoft ETL Workflows

16

Internal use case:

ETL Administration

©2012 Jaspersoft Corporation. Proprietary and Confidential

17

Internal use case:

Lessons Learned


Define metrics and dimensions
before

implementing


In writing, signed off by key stake holders


Definition, Owner, Data Refresh Rate


Define the roles of users accessing the data


How to access the data? Dashboards? Ad
-
Hoc


Data security


Make it a Closed Loop


Regular meeting to discuss the metrics


Define changes to be made


Implement changes



18

Summary: Why use ETL?


Transform the data at the ETL layer


Persist results sets, including calculated metrics


Faster, more responsive reporting


Consistently accurate data


Schedule near
-
real time data refreshes


©2012 Jaspersoft Corporation. Proprietary and Confidential

19

REPORTING AND ANALYSIS, PART 1

Report designers: web
-
based Ad Hoc and iReport

Unified Analysis experience

©2012 Jaspersoft Corporation. Proprietary and Confidential

20

Preview: JasperReports Lifecycle
-

Server

©2012 Jaspersoft Corporation. Proprietary and Confidential

21

.
jrprint

JasperReports Server :


associates inputs into logical JasperReports Units


automates report execution


exposes APIS for other applications to do the same

Compiled

.jrxml

file

Two Report (.jrxml) Designer Tools

iReport


For professional report designers


Client
-
side installation required


Pixel
-
perfect and programmatic control


Extensive capabilities

JasperReports Server: Ad Hoc


Appropriate for all users


Web
-
based, only require a browser


Pre
-
defined report templates


Limited formatting

©2012 Jaspersoft Corporation. Proprietary and Confidential

22

JasperReports
Server

Report Units

©2012 Jaspersoft Corporation. Proprietary and Confidential

23

Sub
-
report

Chart customizer

Images

Translation files

Input controls

Technical Training

©2012 Jaspersoft Corporation. Proprietary and Confidential

24

Online Learning Portal

©2012 Jaspersoft Corporation. Proprietary and Confidential

25

Best Practices for Building
Complex Reports


Don’t boil the ocean


break it down


Learn to leverage components


Use sub
-
datasets, sub
-
reports, Tables etc.


You can use multiple Detail bands


Use conditional logic to get more from one report


Use parameterized queries


but don’t start with them


Appreciate the power of report design


it’s not Excel


Take training and read the Ultimate Guide


it’s great


Join
JasperForge

and user groups

©2012 Jaspersoft Corporation. Proprietary and Confidential

26

Thank You