Oracle Fusion HCM Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion HCM Analytics

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Ability to connect from FDI to Private endpoint

Accepted answer
40
Views
3
Comments
MQasim
MQasim Rank 1 - Community Starter
in Oracle Fusion HCM Analytics

We have an oracle database in another tenancy than the one where our FDI is. Could we create a connection to that database from FDI? The target is private DB

Best Answer

  • Sumanth V -Oracle
    Sumanth V -Oracle Rank 8 - Analytics Strategist
    Answer ✓

    @MQasim - Welcome to the Oracle Analytics Community.

    Currently, connecting to a private Autonomous Data Warehouse (ADW) through the Manage Connections feature in Oracle Analytics to load data into Fusion Data Intelligence (FDI)'s ADW is not supported. Specifically, establishing a connection to a private Autonomous Transaction Processing (ATP) database is not available at this time.

    Reference:
    Administering Oracle Fusion Data Intelligence

    Additionally, connecting from FDI's Oracle Analytics Cloud (OAC) to a private database for creating visualizations using PAC is not supported. The Private Access Channel (PAC) feature is not available in the Oracle Analytics Cloud instance managed by the Oracle Analytics Warehouse server.

    Reference:
    FAW :: Unable To Create Private Access Channel (PAC) for OAC Which Is Managed By Oracle Analytics Warehouse Server (Doc ID 2980939.1)

    However, RDG method works.

    https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/connect-premises-data-sources-using-data-gateway.html

    Thank you for participating in the Oracle Analytics Community. Continued use of the community for future queries and discussions is encouraged.

    Hope this helps!

Answers

  • PRATHEEK
    PRATHEEK Rank 5 - Community Champion

    Thank you @Sumanth V -Oracle - useful information

  • MQasim
    MQasim Rank 1 - Community Starter

    Are there any plans to allow the connection from FDI

     FDI's Oracle Analytics Cloud (OAC) to a private database for creating visualizations using PAC? I was told that there is already and idea lab created and it is in works. Do you have the expected date when it would be available?