How to Set up Oracle Analytics Cloud Service

By: Vikas Raina

Introduction

This document helps you in Setting up Oracle Analytics Cloud Service.

Pre-Requisite: A DBCS or BDCS instance should be running to create a OAC instance and you should have login/password details for the instance.
Login to Oracle Cloud

Login to Oracle Cloud Env using the link: https://cloud.oracle.com/en_US/sign-in

Go to Dashboard and create a new container using storage Classic

 Create Container

Click on ‘Storage Classic’ and open Service Console.

•  Navigate to Create option.

 Get the REST API Details to be used in creating Analytic Service. Click on Burger Menu and then View Details

Copy the REST Endpoint (Permanent) URL

 

Rest Endpoint (permanent) may look like:

Rest Endpoint (Permanent):

https://Storage-55b9b93d3e9641afb2e4ff2c86d65f01.eu.storage.oraclecloud.com/v1/Storage-55b9b93d3e9641afb2e4ff2c86d65f01

Container name: inicucloudoracle

Create OAC Service

Now that Container is created, let’s go and create a OAC service.

Click on Analytics option and go to Service console to create a new Service:

 

 Click on ‘CREATE INSTANCE’

 

Ø  Key in the relevant information to create new Instance.

Please Note: Select Software edition as per your business need and click next (Region is not mandatory unless your DBCS service is created in a specific Region)

 Options to fill in the information on this page  

Ø  Keep the ‘Enable IDCS’ box unchecked. This will work in next release of OAC

Ø  In ‘Options’, Check the box whose services you would want to use in Analytics cloud

Ø  In ‘Cloud Storage Configuration’

Provide Storage base URL as https://Storage-dc6d617ba6624e41b9591723cb6f9d89.us.storage.oraclecloud.com/v1

Provide Cloud storage Container Value as : https://Storage-dc6d617ba6624e41b9591723cb6f9d89.us.storage.oraclecloud.com/v1/Storage-dc6d617ba6624e41b9591723cb6f9d89/inicucloudoracle

Both these values have been derived from Storage Container Rest Endpoint as selected after creating the container. In above, Highlighted part is the container name.

 ‘Cloud Storage username’ / ‘Password’: Enter account username and password with which you logged into cloud service in first step

 Service Administrator

 Username and password passed here would provide access to Analytics Cloud Console.

Database:

                 Key in details of the Database by selecting the DBCS from the drop down.
                 The DB username and Password values are same as used while creating the DBCS instance.

 

Once done, Click on NEXT

If there are no issues, The next screen will show you the details of the OAC and you can CREATE the OAC service.

How to Access the OAC Console

Ø  Once the Analytics Service is created, Go to the Analytics Service console.

Ø  Click on the Burger menu and select ‘Oracle Analytics Cloud URL’

 

Cannot see OAC console login page?

Due to HTTP issue, you might see the following page with error message instead.

Click on ‘Go on to the Webpage’ and This would open up a new page prompting for User name and password.

 The credentials here would be same as used while creating the service.

 Once valid values are provided, you will be logged into Analytics Cloud Console.

Go ahead and use Analytics Cloud service as per your business need

Support

You can create support ticket at https://support.oracle.com/ with Customer Support Identification number which the account owner (buyer) would have received.