Steps for uploading rpd in Oracle Analytics Cloud

Login to https://localhost/dv

Go to console

Click on Snapshot

Click on replace the data model

Browse the rpd and provide the password and click ok

After getting successful upload message,

Login to the analytics page.

Under Administration tab click on reload files and metadata.

Steps for migration obiee 11117 to Oracle Analytics cloud (bundle migration)

Generate migration-too-.jar file in OAC environment

./migration-tool.sh package bi-migration-tool.jar

Copy the generated jar file to obiee 11.1.1.7.0 environment.

Export the bundle in obiee 11.1.1.7.0 environment as below:

After the migration got to succeed, 

Copy the exported bundle file to OAC environment

Import the bundle file as below:

Restart the OAC suit as below:

Stopping:

Starting:

Steps for connecting oracle cloud environment through winscp

Connecting through WinSCP

Note: We need to download the private key and convert it into ssh private key first

Open WinSCP and enter the ip to connect

Browse the ssh private key

Click on open

Click on login

Click yes

Enter the username and click ok

Steps for connecting oracle cloud environment through putty

Connecting through putty:

Note: We need to download the private key and convert it into ssh private key first

Open putty and enter the IP of the cloud database to connect

Under ssh select Auth and browse the ssh private key

Click on open

Steps for converting oracle cloud environment private key to ssh private key

Note: Get the private key from oracle cloud instance to local

Open puttygen

Click on load and browse the private key

Click ok

Click on save private key

Click on yes

Steps for Connecting Oracle cloud database from sqldeveloper

Note: Get the private key from oracle cloud database instance (privateKey)

Open sqldeveloper

Under View select SSH

Right click on SSH hosts and click on New SSH Host

Provide name, host and browse the private key file and click on ok

Test the newly created ssh host connection

Right click on the newly created ssh host connection and 

click on new local port forward

Give name, host and port and click on ok

Right click and click on connect to connect the ssh host

Now connect the oracle cloud database as below

Test the connection

Click on connect to connect the database