SPOUG Cloud Masters – 2024
Wed, May 08, 2024
Efficient Data Extraction from Oracle Fusion Cloud Applications
Extracting data from SaaS applications has consistently been a challenge, and Oracle Fusion is no exception. Existing extraction mechanisms produce CSV/text files, making it difficult to analyze and integrate into business workflows.
The cutting-edge SplashOC Data Pipeline addresses this issue by offering an automated, table-to-table replication solution. It efficiently extracts data from Oracle Fusion and makes it accessible in familiar databases like Oracle, Snowflake, and Microsoft SQL Server.
The Advantages of Data Pipeline
- Fusion data required for enterprise reporting
- BICC unable to connect to Snowflake Database
- CSV extraction proves cumbersome
Solution
- Utilize SplashOC Data Pipeline to extract and replicate data directly into Snowflake
- Eliminate the need for CSV manipulation
- Schedule data extraction for increased efficiency
Example Use Case – Cloud Security Company
A leading Cloud Security Company needed to extract data from Oracle Fusion Applications to facilitate enterprise reporting using their Snowflake data warehouse. Existing solutions like OTBI, BI Publisher, and BICC couldn’t establish a connection with the Snowflake database, forcing the IT team to rely on manual CSV file uploads. As data volumes increased over time, handling CSV files became increasingly challenging and error-prone. To ensure future scalability, the company decided to implement the SplashOC Data Pipeline.
The new strategy involves scheduling the Data Pipeline to extract data regularly, automatically populating the Snowflake data warehouse. For specific fast-moving tables, data will be extracted from Oracle Fusion on-demand, as required by business leaders. The combination of their enterprise reporting tool’s Snowflake connectivity and SplashOC Data Pipeline’s data extraction capabilities will empower comprehensive business analytics for their users.
Example Use Case – Public School System
A large public school system migrated to Oracle Fusion Applications from a legacy Microsoft ERP. They sought a scalable solution for PowerBI Enterprise Data Warehouse reporting and cross-application reporting with on-premises systems. Initially, business users ran OTBI and BI Publisher reports, manually exported data to Excel spreadsheets, and combined these spreadsheets with other sources in PowerBI. This labor-intensive process consumed a significant amount of time and effort.
Although they explored BICC, they found manual/CSV processing to be inefficient. BICC produced text-based output, leaving the IT team to determine how to load CSVs into the database. After implementing the SplashOC Data Pipeline, data is now automatically downloaded into their on-premises MS SQL Server data warehouse. The automated background process runs at predefined intervals, making data available in the warehouse without handling CSVs or parsing text. The extracted data is effortlessly consumed by their Enterprise reporting and analytics solution, PowerBI.
Challenges
- Utilize Oracle Fusion data for PowerBI analytics.
- PowerBI connects with Microsoft SQL Server Database.
- OTBI, BI Publisher, and BICC can’t connect with on-premises Microsoft Database.
Solution
- Extract Fusion data into MS SQL Server database using SplashOC Data Pipeline.
- Automate extraction, saving countless man-hours.
- Leverage in-house talent pool skilled in Microsoft technologies.
