iZeno offers Jaspersoft for SugarCRM which is a specially packaged set of Jaspersoft solutions that includes reporting, analysis and ETL, all for use exclusively with SugarCRM solutions.

Solution Features

• Pixel Perfect Reporting
  • Highly formatted reports containing interactive charts, images, sub-reports, expressions, and more
  • Reports from any data source including JDBC, XML, CSV, Hibernate, POJO.
  • Reports published in PDF, XML, HTML, CSV, DOC, ODT
• Ad Hoc Reporting
  • Web-based, drag-and-drop report designer
  • Crosstabs, tables, and chart-based reports
  • Semantic layer against relational or non-relational data sources
• Advanced analytic functions
  • Ability to analyze data across multiple attributes and time periods
  • Multidimensional Expression Language (MDX) support lets users run complex analytic queries
  • Addition of calculations at runtime or within the relational OLAP model
• Interactive user interface
  • Intuitive web-based interface lets users drill down, drill across, drill up, filter, pivot, sort, and chart
  • Ability to use MS Excel as a front-end client to your OLAP environment
  • Granular security access down to the cell and column level
• Performance and scalability
  • Sophisticated caching of data and dimensions reduces query latency
  • Relational database storage architecture
  • Aggregate-aware architecture simplifies setup and improves user response times
• Graphical design environment
  • Business-oriented models for early design collaboration
  • Drag-and-drop process designer
  • Activity monitoring console tracks job execution and performance
• Connectors
  • Native connectivity to ERP and CRM applications such as SAP and SugarCRM
  • Support for mainframe, transactional, and analytic databases
  • Connectivity to Hive for Hadoop environments
• ETL support
  • ETL connector support for Oracle, DB2, Postgres, IBM/Netezza, EMC/Greenplum, Teradata, and SAP/Sybase IQ
  • Merge, filter and rollback functions
  • ETL template jobs for re-use