Skip to main content

Upcoming Live Virtual Event – SplashBI User Conference April 11-13, 2023

Resources

Very Heavy OTBI Reporting Activity Affecting Production

Very Heavy OTBI Reporting Activity Affecting Production

An Energy Generation organization had a 400+ user base that needed operational reports from Oracle Fusion Applications (1000 users planned in the long term). IT experts were concerned that their big user base might create a very large reporting burden on Fusion SaaS Production environment causing disruption in business-critical transactions. Further, they wanted to produce transactional reports from an on-premises timekeeping system and yet another SaaS recruitment system. OTBI/ BI Publisher were unable to connect to the on-premises system nor the recruitment system. This created a disconnected reporting experience much like the previous use case above.

SplashOC’s data pipeline addressed this issue by extracting Fusion SaaS data into on-premises data warehouse. After more than 3 billion rows downloaded, most of the corporate reporting now occurs from the warehouse alleviating concerns of excessive reporting burden on Fusion Production pod. SplashBI also simultaneously connects to their on-premises system as well as the recruitment system thus delivering a consistent experience to business users.

✅ SplashOC Eliminated Excessive Load From Fusion Production

✅ Processed 2 Billion+ Records

✅ Reporting With On-Premise Systems

✅ Pixel-Perfect Reporting

Very Heavy OTBI Reporting Activity Affecting Production 4

Project Highlights

35
Thousand (approx.) Employees
3
Years Of Data Extracted
2
Terabyte Database Size
3
Billion Rows Extracted
60
Minutes For Extraction

Additional Resources

SplashBI & UKG: Joining Forces for DEI&B Reporting Effectiveness 1
People Analytics

SplashBI & UKG: Joining Forces for DEI&B Reporting Effectiveness

In the post-pandemic world, organizations look to the future of work with optimism, propelled by human resourcefulness....
Making Sense of Your Data to Boost Recruitment & Retention! 2
On-Demand Webinars

Making Sense of Your Data to Boost Recruitment & Retention!

In the post-pandemic world, organizations look to the future of work with optimism, propelled by human resourcefulness....
Deciphering the future of work 3
People Analytics

Deciphering the future of work

In the post-pandemic world, organizations look to the future of work with optimism, propelled by human resourcefulness....