Transcript Jaspersoft
IRMAC Presentation Jaspersoft Suite Overview ©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 Reporting Engine Visual Report Design Environment Ad Hoc Reports, Dashboards, In-Memory Analysis Server Powerful OLAP Data Analysis High Performance Data Integration 3 ©2012 Jaspersoft Corporation. Proprietary and Confidential Jaspersoft BI Architecture (Marketecture) ©2012 Jaspersoft Corporation. Proprietary and Confidential 4 Standards and APIs Web Standard Customizable Front End with Service API’s Jaspersoft UI Framework Extensions Web Service Integration Interfaces: SOAP and REST Presentation (.css) Events (.js) JSR-168 portlets Structure (.jsp) Web Services / C/C++, PHP Java API HTTP API XML/A (OLAP) *** Business Logic: Service API’s *** Reporting Engine JasperReports Library Ad Hoc Reporting JasperReports Server Report Scheduling Scheduler OLAP Engine OLAP Engine Repository Hibernate ORM Object Permission User Authority Spring Security Back-End Implementations can be Configured and/or Replaced connect any data source XML, XML/A TXT & CSV RDBMS SSO LDAP, JAAS, MS Active Directory, IBM Tivoli, SiteMinder, CAS 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 See the JasperReports Server Ultimate Guide, Chapter 11 Repository Database Data Sources Browser user load balancer Web services client Email Services Java application servers JasperReports Server deployed as WAR files ©2012 Jaspersoft Corporation. Proprietary and Confidential External Authentication e.g. SiteMinder, CAS, JAAS, LDAP etc. 7 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 ©2012 Jaspersoft Corporation. Proprietary and Confidential Typical Superuser 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 salesforce.com (53) - Campaigns/Hits - Inquiries/Leads - Opportunities - Accounts - Contacts - Custom Objects (2,000,000) (400,000) (25,000) (32,000) (79.000) SOAP App Exchange Every 15 min Intacct (50) - Orders - Invoices - AP/AR - Rev Rec Schedules XML Gateway Hourly Others (26) - Eloqua - Bugzilla - (4,900,000) Openair Jasperforge.org Jaspersoft.com eStore 15 ©2012 Jaspersoft Corporation. Proprietary and Confidential JDBC Nightly 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 17 ©2012 Jaspersoft Corporation. Proprietary and Confidential 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 Compiled .jrxml file .jrprint JasperReports Server : • associates inputs into logical JasperReports Units • automates report execution • exposes APIS for other applications to do the same ©2012 Jaspersoft Corporation. Proprietary and Confidential 21 Two Report (.jrxml) Designer Tools iReport JasperReports Server: Ad Hoc For professional report designers Client-side installation required Pixel-perfect and programmatic control Extensive capabilities ©2012 Jaspersoft Corporation. Proprietary and Confidential Appropriate for all users Web-based, only require a browser Pre-defined report templates Limited formatting 22 JasperReports Server Report Units Images Translation files Sub-report Chart customizer Input controls ©2012 Jaspersoft Corporation. Proprietary and Confidential 23 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