DataModel Command tool to deploy RPD File

Namaste!! Welcome to My "OFMW Experiments" blog! In this COVID-19 Pandemic, (the Year 2020)critical time keeping myself busy in the new learnings and that too helpful in my workplace as well, here I've chosen topics as  'Oracle Analytics Server' (OAS) administering - RPD deployment. 

The  following diagram developed to understand the process of the Oracle Data Modeler,  how it works on the BI platforms (OAS/OBIEE ) or on the OAC Cloud service as well.

How RPD works on Oracle BI Platforms

In this post would like to share the learning experiments which you can do as lab exercise as given examples.

1. Uploading RPD files to BI platform
2. Listing Connection pool of an RPD
3. Update Connection pool of an existing RPD
4. Download RPD File from existing BI server

let's start working on these 

Upload RPD Files

This task is common for Oracle BI servers and Oracle Analytics services

./datamodel.sh uploadrpd \
  -I /tmp/rpds/myOFMWSample.rpd -W oracle123 \
  -U weblogic -SI ssi
  

Earlier in the OBIEE, you need to provide the hostname where it need to target the Bi server.

List of ConnectionPools 

The datamodel.sh or .cmd  is used for retrieving the list of Connection pools and the output transform to a JSON file.

Command execution line 1:

./datamodel.sh listConnectionpool -SI ssi \
-U weblogic -P MyOFMW123 -S localhost.localdomain \
-V true -O /u01/rpd_cp.json

For more readability, I've broken this command into 3 lines. better you run in a single line.

3. Update the Connection pool from JSON File

On the OAS_domain or bi_domain, we can update the database details updated in a JSON file and the 'updateConnectionpool' command will be connected to the service instance and do the update of the connection pool(s). where it takes the following parameters:

• Connection pool list inside a JSON file
• Service Instance
• WebLogic admin console username
• WebLogic admin password
• Server host which is running AdminServer

Command execution line 2:

./datamodel.sh updateConnectionpool -C /u02/rpd_cp_up.json \
-SI ssi -U weblogic -P MyOFMW123 -S localhost.loacldomain

Service Instance is: ssi

Operation successful.

Connection pool update completed successfully.

System exit code: 0

    

After updating of the  Connection Pools

To verify the changes

./datamodel.sh listConnectionpool -SI ssi -U weblogic \
-P MyOFMW123 -S localhost.localdomain -V true -O /u01/rpd_cp01.json

How to download Repository from BI environment?

There are different options as online and offline download RPD file. The following will be the offline option

./datamodel.sh downloadrpd \
  -O /u01/home/downloads/AnalyticsVisualization.rpd \
  -W admin123 -U weblogic -P MyOFMW123 -SI ssi