How to Access Oracle Fusion Cloud Apps Data from Snowflake

If you’re trying to integrate your Oracle Fusion Cloud Apps data into Snowflake, you may have realized it’s going to be a different approach than with traditional type ERP systems. One challenge is that Oracle Fusion Cloud Applications and Snowflake are hosted on different clouds. Oracle Fusion apps (ERP, SCM, HCM, CX) run on Oracle Cloud, whereas Snowflake operates on AWS, Azure, or Google Cloud. There are, however, several approaches to making this integration happen for bulk data. (If interested in a similar analysis for Databricks, reference the Databricks blog.)

Although there are various ways to perform this integration, this post will concentrate on two main criteria:

1. Native Capabilities: These rely solely on Oracle and Snowflake Cloud-based technologies without the need for third-party tools.
2. Scalable Methods for High Data Volume: The emphasis is on techniques capable of handling a large number of objects and massive data volumes. While alternatives like REST APIs, OTBI, or BI Publisher exist for Fusion data extraction, they are not recommended for substantial bulk extractions from Oracle Fusion. However, these methods can still be used alongside the primary approaches if necessary.

Revolutionize Your Business With Generative AI

From product design and software development to virtual agents, content creation, and reporting, GenAI is transforming business. Our AI experts help you unlock GenAI’s full potential and drive growth.

Let’s Get Started

The following diagrams summarize four different approaches on how to replicate Oracle Fusion Apps data in Snowflake. Each diagram highlights the data flow, and the technologies applied.

• Approach A: Leverages Oracle Autonomous Data Warehouse and an Oracle GoldenGate Replication Deployment
• Approach B: Leverages Oracle Autonomous Data Warehouse and Oracle Data Transforms to load data into Snowflake via a JDBC connection
• Approach C: Leverages Oracle Data Integrator to load Fusion data into Snowflake via a JDBC connection
• Approach D: Leverages AWS S3 compatibility API to load Fusion data into Snowflake

Choosing the right approach for your use case is dependent on the objective of performing this integration and the ecosystem of cloud platforms that are applicable to your organization. For guidance on this, you may reach me at mazen.manasseh@perficient.com. Perficient’s Oracle and Snowflake specialists will connect with you and provide recommendations.