Skip to main content

Oracle

OBIEE 12c with Cache Database

Oracle Business Intelligence Suite provides comprehensive capabilities for business intelligence, including enterprise reporting, dashboards, ad-hoc analysis, multi-dimensional OLAP, scorecards, and predictive analytics on an integrated platform. It is also a core component of Oracle Exalytics, the industry’s first engineered in-memory analytics machine designed to deliver extreme performance.

A majority of healthcare providers to some extent or another use a cache database. Developing and generating a robust, fast, ad-hoc, visually pleasing analytical reports from cache database using other products might be a little challenging task. But, with OBIEE 12c it’s pretty quick to develop and present to the end-user in a short period of time.

Perficient implemented an OBIEE 12c solution that consumed healthcare data from the InterSystems Cloud. This data is stored in the cache database. The database is not in the Third Normal Form and comprised of over hundreds of tables. The Perficient BI team successfully built an on-premises star schema models which consumed data from the Cache database in the cloud and built complex analytical reports and dashboard in mere couple of weeks rather than months/years.

To know more about this healthcare implementation, please contact our Perficient BI team.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Raghu Syama

Raghu is the Senior Technical Architect of Perficient's National Oracle Business Intelligence Practice. He has extensive experience in architecting, designing, developing, and delivering enterprise software solutions, and commercial software products from concept to market. His area of expertise includes application programming, SOA, microservices, integrations, cloud and BI implementation. He has worked for several fortune 500 companies in his career and successfully led several projects from inception to completion by maintaining high quality standards. He has experience working with cross-cultural teams ensuring optimal utilization of resources. He has several certifications across multiple technologies from Oracle, AWS, Microsoft, and Redhat.

More from this Author

Follow Us