Essatto Software Speeds Data Aggregation Tenfold; Integrates BI, Performance Management, and Data Warehousing for Midsize Businesses
 
 

Essatto Software Speeds Data Aggregation Tenfold; Integrates BI, Performance Management, and Data Warehousing for Midsize Businesses

Printer View Printer View

Essatto Software delivers an integrated enterprise performance management, business intelligence, and data warehousing solution, called Essatto, across a broad spectrum of industries. Essatto allows organizations to perform budgeting, rolling forecasts, variance analysis, cost allocations, and historical reporting.

Essatto Software’s customers are mainly midsize organizations that rely heavily on large volumes of operational and financial data from multiple sources to make informed business decisions. Built on Oracle technology, the Essatto system’s unique architecture pulls data from different sources, analyzes it, and delivers Web-based intelligence reports, analytic dashboards, and live-linked spreadsheets.

One customer that uses Essatto is Compass Group Australia, a subsidiary of the U.K.-based multinational catering services company Compass Group PLC. Compass Group Australia uses Oracle E-Business Suite as its enterprise resource planning (ERP) system, leveraging the Essatto system’s embedded Oracle technologies to develop budgets, produce Web-based management reports, and undertake variance analysis through inbuilt dashboards and an integrated spreadsheet interface.

 
 

 
 

Challenges

A word from Essatto Software Pty Ltd

  • “By embedding Oracle technologies in our Essatto system, we have developed a cost-effective, integrated business intelligence, enterprise performance management, and data warehousing solution that is accessible to midsize enterprises, and that aggregates data 10-times faster.” – Guy Ioppolo, Managing Partner, Essatto Software Pty Ltd

  • Develop an integrated enterprise performance management system with business intelligence and data warehousing capabilities for midsize businesses
  • Provide customers with advanced reporting, analytic, budgeting, and reforecasting capabilities to improve their decision-making
  • Enable customers with Oracle and nonOracle backend systems to take advantage of Oracle OLAP and Oracle Business Intelligence Enterprise Edition in a cost-effective, out-of-the-box solution
  • Substantially reduce the consulting effort and total cost of investment required to deliver an integrated business intelligence, enterprise performance management, and data warehousing solution

Solutions

Oracle Product and Services

  • Embedded Oracle Business Intelligence Enterprise Edition, Oracle WebLogic Suite, and Oracle Database, Enterprise Edition 11g with Oracle OLAP 11g into the Essatto system to ensure database security, manageability, scalability, and high availability
  • Reduced the time taken to implement the business intelligence, enterprise performance management, and data warehousing solution for its customers from eight weeks to two weeks, by providing significant out-of-the-box functionality
  • Increased the Essatto system’s data aggregation speed up to tenfold by upgrading to Oracle Database, Enterprise Edition 11g
  • Enabled some users to complete queries up to 50-times faster in financial or operational information previously stored in relational and nonrelational data sources, by using Oracle OLAP 11g’s multidimensional analytic capabilities
  • Improved customers’ tactical decision-making abilities by enabling users to almost immediately see business-critical financial or operational data—presented as interactive dashboards, ad hoc analysis, or formatted reports—rather than waiting weeks for it to be provided manually
  • Enhanced customers’ business intelligence and enterprisewide performance planning capabilities by using connectors and modules to pull information from third-party systems and applications
  • Provided customers with easy access to data held in the Essatto system’s Oracle Database, by using Oracle WebLogic Suite and Oracle Business Intelligence Enterprise Edition to support a powerful interface with a sophisticated dashboard and ad hoc analysis capabilities

Why Oracle

Essatto Software chose Oracle technology to build the architecture for its Essatto system because of Oracle OLAP’s comprehensive performance and calculation capabilities, the powerful analytic capabilities of Oracle Business Intelligence Enterprise Edition, and the scalability of Oracle Database.

“Essatto’s parent company, Ioppolo & Associates, has been an Oracle Partner since its inception in 1996, and we are consistently impressed by the strength, stability, and performance of Oracle products,” said Guy Ioppolo, managing partner, Essatto Software. “By working with Oracle, we are able to offer best-in-class technology and enterprise performance management solutions to our clients in a cost-effective manner.

“Essatto is used by many customers in the Asia-Pacific region,” said Ioppolo. “The upgrade to Oracle Database 11g and Oracle Business Enterprise Edition allowed us to leverage a proven, Web, service-oriented architecture to deliver next-generation business intelligence capabilities.
“Our customers want to analyze bigger data sets, and Essatto delivers this requirement. Essatto with Oracle Database 11g aggregates data up to 10 times faster, and combines scalability, performance, and security with prebuilt functionality. This provides customers with a cost-effective solution that can be delivered in a timely fashion.”

Implementation Process

Essatto initially developed its business intelligence, enterprise performance management, and data warehousing software in 2006 using Oracle Express Server. The company upgraded its Oracle Database in December 2009, then in November 2011, upgraded again to Oracle Database, Enterprise Edition 11g with Oracle OLAP 11g and embedded Oracle Business Intelligence Enterprise Edition and Oracle WebLogic Suite into the software.

As an independent software vendor and part of the Oracle Validated Integration PartnerNetwork program, Essatto Software worked closely with Oracle while developing and upgrading its Essatto system to ensure it leveraged the Oracle products’ key features.