Oracle OAC & APEX Integration Consulting Cloud Services

Request Demo

Advanced analytics and insights play a vital role in business growth. With statistics-based and informed decision making, you can enhance your business' performance while reducing the time consumption and financial expenditures. With the integration of Oracle Analytics Cloud with Apex, you can access all the power and capabilities of Cloud-native analytics in a single and unified mobile or web app.

Vast Edge is a "global gold partner" of Oracle and has been listed in Forbes as one of the most successful managed service providers (MSP) assisting businesses in smooth cloud migration. Vast Edge has a team of 100+ Oracle certified experts and has deployed 1000+ projects based on cloud technology. In addition to Oracle cloud, Vast Edge also aids in AWS, Azure and GCP migration.

Why Vast Edge for OAC and APEX Integration?

  • Augmented Layer of Access

    OAC integration by Vast Edge are powerful yet invisible i.e. easy to access and boosts your system's functioning exponentially.

  • Application Specific Drivers

    Our cloud experts have developed a set of pluggable app modules and pre-owned customizable SDKs to enhance the app's performance and deploy them in no time.

  • Smart Analytics

    Our analytics solutions generate narratives and actions automatically to help you in decision making process with insightful data.

  • Integrated Experience

    Vast Edge ensures that your architecture is designed as per your requirement so that your system, data, and human resources can work in sync.

  • Unified Environment

    Our custom deployed solutions are aimed at creating a single access point for data prep, visualization, and dashboards while delivering intelligent, timeliness, and context-based insights.

  • ML & AI

    Leveraging the Oracle Analytics, our system integrators helps you in uncovering what drives the results, adding transparency in findings, and analysing key segments of customer behaviour.

  • Mobile Analytics

    Our OAC and Apex integration offers contextual and proactive analytics on your mobile devices as well. We ensure that you remain updated with all the metrics like usage patterns, location, preferences, and connections with your colleagues.

Here is a detailed and step-by-step guide to embed Apex with OAC. Once the setup is completed, you will be able to show OAC reports and dashboard in Apex with IDCS credentials.

Create reports with OAC

OAC Reports

Step 1: Go to developer option in right hand side bar and click on embed.

OAC Apex Integration Developer

Step 2: Copy the codes provided in Embedding Script to Include and Default as you will need these later.

Step 3: Access the OAC console by selecting the menu button in the top-left of your page and then Console.

OAC-S3

Step 4: Select safe domains.

OAC-S4

Step 5: Add Apex application URL in safe domain list.

OAC-S5.png

Step 6: Now create an Apex application and a blank page in application.

Step 7: Create a region on this page to render the Oracle Analytics Cloud.

Step 8: In the source tab of new region, copy the following content:

<div style="height: 1000px; width: 100%;">
<oracle-dv project-path="{Project_path}" >
</oracle-dv>
</div>

Step 9: Select the top level of the page. In the properties on the right-hand side of the page, scroll to JavaScript. Into file URLS: This is based on the link Embedding Script to Include that you saved from OAC. The URL is specific to your environment. Copy and Paste only the URL part of the OAC link, and change to this.

Step 10: Save changes and run the application. If you are logged in with OAC in the same browser , you will see the dashboard on Apex page itself.

Step 11: Now enable SSO between Apex and IDCS so that IDCS users can login to Apex apps with their credentials and can authenticate.

Register a confidential application in IDCS

  • Sign-In to Identity Cloud Service: https://idcs- <guid>. identity.oraclecloud.com/ui/v1/adminconsole as an Administrator.
  • From the Applications section click on the Applications cloud icon or in the hamburger menu click on Applications.
  • Click the Add button.
  • Select Confidential Application.
  • In the App Details section complete the following:
    Name: "Name of Apex Application"
    Description: "Description"
    Application URL: <Apex Application URL>
  • Click Next.
  • Select Configure this application as a client now.
  • In the Authorization section complete the following:
    Allowed Grant Types: check "Authorization Code".
    Redirect URL: https://apex.oracle.com/pls/apex/apex_authentication.callback
    (Url of apex /apex_authentication.callback)
    Logout URL: https://idcs-.identity.oraclecloud.com/oauth2/v1/userlogout
    Post Logout Redirect URL: e.g. https://apex.oracle.com/pls/apex/f?p= <your_apex_number_here>
    (URL of apex application)
  • Click Next.
  • Click Next to Skip for later --- Expose APIs to Other Applications.
  • Click Next to Skip for later --- Web Tier Policy.
  • Click Finish on Authorization (Do not check Enforce Grans as Authorization).
  • Copy the Client ID and Client Secret to a text editor and save for later.
    Client ID: <your_client_id_here>
    Client Secret: <your_client_secret_here>
  • Click the Close button.
  • Click the Activate button on the top right.
confidential-application

Creating Web Credentials in Apex

  • If not already, Login to your APEX workspace:
    https://apex.oracle.com/
  • Click on the App Builder icon.
  • Click on the Workspace Utilities icon.
  • Click on the Web Credentials link.
  • Click the Create button.
  • In the Web Credentials Attributes section complete the following:
    Name: "Analytics"
    Authentication Type: "Basic Authentication" Client ID or Username: <Paste in Client ID from earlier>
    Client Secret or Password: <Paste in Client Secret from earlier>
    Verify Client Secret or Password: <Paste in Client Secret from earlier>
  • Click the Create button to complete.
confidential-application

Create a new Authentication scheme in Apex

  • Click on the apex application.
  • Click on the Shared Components button.
  • Under the Security section click on the Authentication Schemes link.
  • Click the Create button.
  • Use the Based on a pre-configured scheme from the gallery and click the Next button.
  • In the Authentication Scheme section select Social Sign-In from the Scheme Type and complete the following:
    Name - "Analytics_Apex"
    Scheme Type: "Social Sign-in"
    Credential Store: "IDCS Web Credentials" <-- It should default to the Web Credential created earlier.
    Authentication Provider: "OpenID Connect Provider"
    Discovery URI: "https://idcs- <guid>.identity.oraclecloud.com/.well-known/openid-configuration"
    Scope: "profile"
    Username Attribute: "sub"
    Convert Username To Upper Case: "No"
  • Select Configure this application as a client now.
  • Authentication-scheme
  • Click the Create Authentication Scheme to complete; this will also make the new scheme current.
  • Now click on the Authentication Scheme - Current link.
  • Click on the Post-Logout URL tab.
  • Select the URL from Go to and in the URL field <paste in the APEX calendar application URL from earlier; must match the IDCS Post Logout Redirect URL>.
  • Click the Apply Changes button to save.
Authentication-scheme2

That's it. Now when you will login into Apex application. It redirects you to IDCS login page. Put in your IDCS credentials and you will be able to see the OAC dashboard in Apex.

Contact

Get in touch with us

chat
Hello! 👋 How can we help you today?