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 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 aids in AWS, Azure and GCP migration.

Why Vast Edge for OAC and APEX Integration?

Augmented Layer Of Access

OAC integration by Vast Edge is 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 the decision-making process with insightful data.

Integrated Experience

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

ML & AI

Leveraging Oracle Analytics, our system integrators help you in uncovering what drives the results, add transparency to findings, and analyze key segments of customer behavior.

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.

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

Step 1: Go to the developer option in the right-hand sidebar and click on embed.

Your Vision, Our Expertise

Elevating Your Software Product Engineering Journey with Vast Edge

Step 1: Go to the developer option in the right-hand sidebar and click on embed.

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

Step 4: Select safe domains.

Step 5: Add the Apex application URL to the safe domain list.

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

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

Step 8: In the source tab of the 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 the Apex page itself.

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

Register a confidential application in IDCS

1
Sign-In to Identity Cloud Service: https://idcs- . identity.oraclecloud.com/ui/v1/adminconsole as an Administrator.
2
From the Applications section click on the Applications cloud icon or in the hamburger menu click on Applications.
3
Click the Add button.
4
Select Confidential Application.
5
In the App Details section complete the following:

Name: "Name of Apex Application"
Description: "Description"
Application URL:
6
Click Next.
7
Select Configure this application as a client now.
8
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=
(URL of apex application)
9
Click Next.
10
Click Next to Skip for later --- Expose APIs to Other Applications.
11
Click Next to Skip for later --- Web Tier Policy.
12
Click Finish on Authorization (Do not check Enforce Grans as Authorization).
13
Copy the Client ID and Client Secret to a text editor and save them for later.

Client ID:
Client Secret:
14
Click the Close button.
15
Click the Activate button on the top right.

Creating Web Credentials in Apex

1
If not already, log in to your APEX workspace:

https://apex.oracle.com/
2
Click on the App Builder icon.
3
Click on the Workspace Utilities icon.
4
Click on the Web Credentials link.
5
Click the Create button.
6
In the Web Credentials Attributes section complete the following:

Name: "Analytics"
Authentication Type: "Basic Authentication" Client ID or Username:
Client Secret or Password:
Verify Client Secret or Password:
7
Click the Create button to complete.

Create a new Authentication scheme in Apex

1
Click on the apex application.
2
Click on the Shared Components button.
3
Under the Security section click on the Authentication Schemes link.
4
Click the Create button.
5
Use the Based on a pre-configured scheme from the gallery and click the Next button.
6
In the Authentication Scheme section select Social Sign-In from the Scheme Type and complete the following:

In the Authentication Scheme section select Social Sign-In from the Scheme Type and complete the following:
7
Select Configure this application as a client now.

1
Click the Create Authentication Scheme to complete; this will also make the new scheme current.
2
Now click on the Authentication Scheme - Current link.
3
Click on the Post-Logout URL tab.
4
Select the URL from Go to and in the URL field .
5
Click the Apply Changes button to save.

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

Oracle OAC & APEX Integration Managed Cloud Services