How to Setup Oracle Analytics Cloud Service

by Dindima Mahesh Jami

This blog post is intended for those who are familiar with OBIEE or have previously worked on it. It contains step by step instructions on how to setup OACS using a trial account.

What is OACS?

Oracle Analytics Cloud Service (OACS) is a new Platform as a Service (PaaS) offering comprehensive analytics capabilities at any scale, in any environment, and on any device. This was first announced on Sep 30, 2014 at Oracle OpenWorld and was officially launched on Apr 4, 2017.

It is available in two editions (Standard and Enterprise)

  • OAC Standard includes Oracle Data Visualization Cloud Service (DVCS), Oracle Smart View and Oracle Essbase Standard
  • OAC Enterprise includes all the services in the Standard edition plus Oracle Business Intelligence Cloud Service (BICS), enterprise capabilities for Oracle Essbase and Oracle Day by Day

Pricing: https://cloud.oracle.com/en_US/oac/pricing

OACS Setup Process

Create an Oracle Cloud account at https://cloud.oracle.com/tryit to access the 30-day free trial for OACS.

Once the account is created, you will be redirected to the following link: https://myaccount.cloud.oracle.com/mycloud/faces/trialsignup.jspx?serviceType=IAASMB

Provide the details and click ‘Request Code’

Enter the code you receive via SMS

Click ‘Sign Up’ to redirect to the following page

How to Setup Oracle Analytics Cloud Service

Check your inbox for an email with a temporary password to access OACS. This password can be changed after you login by clicking the link in the mail. The email will have the details of all the subscriptions a cloud account is given access to.

Prerequisites: Have a storage container and database cloud before setting up OACS

Creating Oracle Cloud Storage Service

Click ‘Menu’ to display the list of services

How to Setup Oracle Analytics Cloud Service

Click ‘Set Policy’ to set a Georeplication Policy before you continue

How to Setup Oracle Analytics Cloud Service

Click ‘Create Container’ to fetch the details required for service creation.

How to Setup Oracle Analytics Cloud Service

Domain name is – inkpipartn05913

Storage service is Storage (by default)

Click ‘Create Container’

Enter storage container name – In this case it is ‘demo’

Select the storage class (Standard or Archive)

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

In order to reference Oracle Cloud Storage, use this format: <storage service>-<identity domain>/<container>

In our example, it is Storage-inkpipartn05913/demo

Creating Oracle Cloud Database Service

Click ‘Menu’ to display the list of services

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Click ‘Go to Console’ and then ‘Create Service’ to create the database service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Confirm your password and click ‘Edit’ in the ‘SSH Public Key’ field

How to Setup Oracle Analytics Cloud Service

Select ‘Create New Key’ and click ‘Enter’

How to Setup Oracle Analytics Cloud Service

Click ‘Download’ to download a file with the filename ‘sshkeybundle’ which contains the public and private key

Cloud storage container is

https://inkpipartn05913.storage.oraclecloud.com/v1/Storage-inkpipartn05913/demo

You will get the above value (cloud storage container) from My Account > Services in the REST Endpoint

Click ‘My Account’ to redirect to the following page and then click ‘Oracle Storage Cloud Service’

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Continue with the Database Cloud Service setup and select ‘None’ as the ‘Backup Destinantion’

How to Setup Oracle Analytics Cloud Service

Click ‘Next’ to display a summary of Database Configuration

How to Setup Oracle Analytics Cloud Service

Click ‘Create’ and you will get a ‘Creating service…’ message while the service is getting created

How to Setup Oracle Analytics Cloud Service

Once the service is created, you will see the following information and receive an email

How to Setup Oracle Analytics Cloud Service

Click ‘demodb’ for details

How to Setup Oracle Analytics Cloud Service

You can see the Public IP of db which can be accessed through PUTTY

You can start and stop db as shown below

How to Setup Oracle Analytics Cloud Service

Or

How to Setup Oracle Analytics Cloud Service

When a database service instance is created, a number of Oracle Compute Cloud Service access rules are created, but set to a disabled status. When you enable one of these predefined access rules, the given port on the compute node is opened to the public internet.

The access rules created for a db are shown below

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

In order to use SQL Developer and the Oracle Cloud on-instance database monitor (DBaaS Monitor) in this tutorial, you will enable two predefined rules:

ora_p2_dblistener, which controls access to port 1521, the port used by SQL*Net, and therefore SQLDeveloper.

ora_p2_httpssl, which controls access to port 443, the port used for HTTPS connections to the instance including DBaaS Monitor.

To enable these two automatically created Oracle Compute Cloud access rules from the Database Cloud Service console, click the hamburger menu beside the service name.

A list of access rules and their enabled status is displayed. You can create, delete, and update access rules from this page. By default, only the ora_p2_ssh and ora_trusted_hosts_dblistener access rules are enabled.

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Click ‘Enable’

Likewise enable ora_p2_httpssl for DBaaS monitor access

How to Setup Oracle Analytics Cloud Service

Connecting SQL Developer to your Cloud Database

If 11g is selected during db setup then SID is needed else service name needs to be given as shown below

How to Setup Oracle Analytics Cloud Service

We get the service name upon hovering the mouse on ‘Connect String’ as shown below

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Different users created in demodb connection can be viewed under ‘Other Users’

This database can be used just like any regular database.

Use DBaaS Monitor to monitor Oracle Database Cloud Service and the database instances in it. You connect to the Monitor via Port 443 of your DBaaS VM. This port was opened earlier by enabling the access rule ora_p2_httpssl.

From the My Services console, return to the Database Cloud Service console.

Click the menu next to the database instance you wish to monitor and note the variety of console choices. Click ‘Open DBaaS Monitor Console’.

How to Setup Oracle Analytics Cloud Service

You should see a popup as shown below. If it isn’t secure then click on ADVANCED option and open the page.

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Click the following link for details:

http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/dbcs_quick_start/oracle_database_cloud_service_dbaas_quick_start.html#section4

Creating Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Click ‘Create Service’

How to Setup Oracle Analytics Cloud Service 

SSH public key can be the same as the database SSH public key. Click ‘Next’.

How to Setup Oracle Analytics Cloud Service

Admin password – Enter the password to access Analytics. This password wasn’t set earlier.

Database password – Created earlier while creating the database service

Select the first two ‘Options’

Cloud storage base URL: https://inkpipartn05913.storage.oraclecloud.com/v1

Click ‘Next’

How to Setup Oracle Analytics Cloud Service

ClickCreate Service’

How to Setup Oracle Analytics Cloud Service

‘Creating Service’ message is displayed

It takes approximately 40 minutes to create the service and you will be notified via email once the service is created

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Under Compute, there are two instances that are created with different IPs

We can stop or restart any service that has been created

How to Setup Oracle Analytics Cloud Service

The ‘Compute’ section shows which services were created and in what instances

Click ‘Visualization’ to see the graph of all the services and their IPs created in the cloud

How to Setup Oracle Analytics Cloud Service

Now that OACS has been created, click the following link to access the analytics page

http://publicip/analytics

The Public IP is 129.157.186.213

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Enter the username and password given while creating OACS

How to Setup Oracle Analytics Cloud Service

The version of OBIEE is 12.2.2.0.0 (Build BIPS-20170417212246 64-bit)

How to Setup Oracle Analytics Cloud Service

You can access analytics by following the screenshots shown below

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

Click http://129.157.186.213/va to access visualization

How to Setup Oracle Analytics Cloud Service

How to Setup Oracle Analytics Cloud Service

You won’t be able to access the Essbase page as we didn’t select the option while creating OACS

http://129.157.186.213/essbase

Port for OBIEE and Visual Analyzer is 80 (443 for secure)

Enterprise Manager and Console are blocked by default. The port for these is 7001.

For production sever, deploy the security certificate using the following link:

https://docs.oracle.com/cloud/latest/analytics-cloud/ACSAM/GUID-5B8C95B0-D2D1-4A8F-9213-442E97711677.htm#ACSAM-GUID-10CFEC8F-4388-46EA-B4A0-074BB5928A28

Click ‘Users’ to add more users from this admin account

How to Setup Oracle Analytics Cloud Service

Specify the username, role and email address while creating a new user and click ‘Add’. A mail will be sent to the added user.

How to Setup Oracle Analytics Cloud Service

The added user will receive an email with the account information

How to Setup Oracle Analytics Cloud Service

After clicking the ‘Click here to access account’, enter the username and temporary password as mentioned in email. After clicking Submit, the user can change the password and security questions.

You can access only the service for which a role is assigned. This can be seen in the cloud dashboard. If the added user is an administrator he can create the service to which he’s assigned but cannot create other services. The added user is only an account in the cloud which means that in the above screenshot, Praveen is assigned the role of ‘Analytics Service Administrator’ but he will not be able to access OBIEE. He will just see the OACS that has already been created and he can create a new OACS.

Changing the cloud account password

The password and security questions can be changed here

How to Setup Oracle Analytics Cloud Service

Uploading RPD to cloud

Note: OBIEE 11.1.1.6 and later editions

Login to the Oracle Cloud account and setup Virus Scanner to make your Analytics Cloud virus free

  1. Open the visualization link http://129.157.186.213/vaHow to Setup Oracle Analytics Cloud Service
  2. Click ‘Console’How to Setup Oracle Analytics Cloud Service
  3. Select ‘Snapshots’ from the left paneHow to Setup Oracle Analytics Cloud Service
  4. Click ‘Replace Data Model’How to Setup Oracle Analytics Cloud ServiceHow to Setup Oracle Analytics Cloud Service
  5. Chose the .rpd file and enter the repository passwordHow to Setup Oracle Analytics Cloud Service
  6. Login to the analytics page http://129.157.186.213/analytics/ to see the subject areas based on the uploaded .rpd fileHow to Setup Oracle Analytics Cloud ServiceHow to Setup Oracle Analytics Cloud Service

Supported browsers for OACS

Web Browser

Version

Microsoft Internet Explorer

11 and later

Microsoft Edge

38 and later

Google Chrome

54 and later

Mozilla Firefox

45 and later

Apple Safari

10 and later

 

Accessing Oracle WebLogic Console and Enterprise Manager

Access rules need to be applied for Oracle Analytics Cloud Service as shown below

How to Setup Oracle Analytics Cloud Service

Once this is done, WebLogic Console and Enterprise Manager are accessible. The URLs are in the following format.

Console URL – http://publicip:7001/console

Enterprise Manager URL – http://publicip:7001/em

Summary

The setup process wasn’t easy but this blog post will definitely be helpful for anyone who would like to setup an OBIEE instance in the cloud.

Note: Some of the screenshots or content shown in this blog post may not look the same as Oracle may update the UI in future releases.


dindima-mahesh-jami.jpg

Dindima Mahesh Jami is a Senior Manager with expertise in Informatica, Informatica Cloud, Oracle BI Applications, OBIEE and 13 years of experience in Data Warehousing.

 

原创文章,作者:ItWorker,如若转载,请注明出处:https://blog.ytso.com/271915.html

(0)
上一篇 2022年7月8日
下一篇 2022年7月8日

相关推荐

发表回复

登录后才能评论