We would like to get a better understanding of the FDI product functionality and how it integrates with our current setup. Below are our requirements:

Key Requirements:

1. ADW Database Configuration: The customer requires the Autonomous Data Warehouse (ADW) database to be hosted on a private subnet. This is crucial for maintaining data security and compliance with their internal policies.
2. Publicly Resolving FDI and OAC: The FDI (Fusion Data Integration) and OAC (Oracle Analytics Cloud) must be publicly resolvable. This means that business users should be able to access these services directly from the public internet without needing to configure local DNS settings on their machines or networks.
3. Site-to-Site Connection: Additionally, since there is an established Site-to-Site connection between the customer’s environment and Oracle Cloud Infrastructure (OCI), we need to ensure that these resources (FDI, OAC, and ADW) to be privately resolvable over this secure channel. This dual access (public and private) is required for the user's flexibility while maintaining security.

Documentation Reference:

We have reviewed the documentation on accessing Oracle Fusion Analytics Service Endpoints publicly, which provides some guidance on making the FDI and OAC publicly accessible. However, we would like to discuss the following:

• Best Practices: What are the best practices for configuring the FDI and OAC to be both publicly accessible and securely integrated with a privately hosted ADW?
• Networking Configuration: What specific networking configurations will be necessary for both the public resolution and private accessibility via the Site-to-Site connection?

Referred documents: Access Oracle Fusion Analytics Service Endpoints Publicly

https://blogs.oracle.com/analytics/post/prepare-network-components-for-private-internet-access-to-oracle-analytics-services