STEPS FOR INSTALLING AND CONFIGURING PSM (PAAS SERVICE MANAGER COMMAND LINE UTILITY)

Installing Python:

Download and install the python as below

Click on Install Now

Wait until the setup progress got finished

Click on disable path length limit

Checking for the python:

For some reason downloading the PSM is hidden away and not easy to find 

we need to login to your Oracle Cloud service, 

go to the service console screen, 

then click on the drop down arrow against your user name in the top right of the screen , 

select ‘Help’  and then ‘Download Center’

Click on download

Installing psm:

Open the command prompt and install psm as below

Configuring psm:

Provide username, password, identity domain, region, 

output format and use oauth details and 

click enter

It displays the list of available services as above.

Psm commands for Oracle analytics cloud

services:

List all Oracle Analytics Cloud instances

Syntax:

psm analytics services

Service:

Psm command to see the details of service

Syntax:

psm analytics service -s OACDEV

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:

Apache superset installation and configuration

Installing prerequisites:

Python:

Cryptography:

Virtualenv:

Setting virtualenv environment:

Activating virtualenv:

Upgrading setup tools:

Installing superset:

Creating admin user for superset:

Getting error “no module named pandas.core”

Upgrading pandas to resolve the issue:

Again try to create the admin user:

Upgrading the superset database:

Getting error “ImportError: cannot import name ‘ExtDeprecationWarning”

To resolve this install the prerequisites in the Requirements.txt file as below:

Note: If the file is not there create the file and add the below requisites in it.

Requirements.txt

bleach==2.1.2

boto3==1.4.7

botocore==1.7.48

celery==4.2.0

colorama==0.3.9

cryptography==1.9

flask==0.12.2

flask-appbuilder==1.10.0

flask-caching==1.4.0

flask-compress==1.4.0

flask-migrate==2.1.1

flask-testing==0.7.1

flask-wtf==0.14.2

flower==0.9.2

future==0.16.0

geopy==1.11.0

gunicorn==19.8.0

humanize==0.5.1

idna==2.6

isodate==0.6.0

markdown==2.6.11

pandas==0.23.1

parsedatetime==2.0.0

pathlib2==2.3.0

polyline==1.3.2

pydruid==0.4.4

pyhive==0.5.1

python-dateutil==2.6.1

python-geohash==0.8.5

pyyaml==3.12

requests==2.18.4

simplejson==3.15.0

six==1.11.0

sqlalchemy==1.2.2

sqlalchemy-utils==0.32.21

sqlparse==0.2.4

tableschema==1.1.0

thrift==0.11.0

thrift-sasl==0.3.0

unicodecsv==0.14.1

unidecode==1.0.22

contextlib2==0.5.5

After the requirements installed successfully upgrade superset database again

Loading the default examples:

Initializing the superset:

Starting the superset server:

Accessing superset console: