Art of BI: Turn your OBIEE Sample App VM into a Development Environment

How do you turn your OBIEE Sample App VM into a Development Environment?

During client engagements you are sometimes faced with Clients having an In-house development team, who also have access to the Test environment you are developing your deliverables and solution for. In this situation, and also as best practice, you should always have your own development environment where you can test your implementation and Proof of Concepts on before the client development team has access to it.

Our development team has initially installed the Sample App v511 for OBIEE 12C on their windows machines in order to implement all Proof of Concepts, including OBIEE 12C new features, to fulfill our client requirements.

After the VM is setup one of the first things to do is to create a shared folder between your local machine and VM.

Steps to create a Shared Folder:

  1. From the main menu bar select Devices > Shared Folders > Shared Folder Settings
  2. In the SampleApp511p – Settings dialog box, Click the folder with a green plus on the right to add a new shared folder
  3. Enter the folder Path on your local machine and the folder name
  4. Check the boxes Auto-mount and Make Permanent as shown below

DEVENV1

Auto-mount is checked to ensure the folder is mounted immediately onto the VM, and Make Permanent ensures that the folder is constantly mounted even after reboot.

  1. Verify that you can access the folder from your VM by navigating to the following path: Places > Computer > Filesystem > Media 

DEVENV2

 

Steps to setup ODBC connections:

  1. On your VM, log into Enterprise manager to Identify the port used by the application [Note: Make sure the BI Database and BI Services have been started]
  2. Note the port used by AdminServer and bi_server1

DEVENV3

  1. Navigate to biinstance and select the Availability tab
  2. Expand the BI Servers process and note the port number for obis1

DEVENV4

  1. Now navigate to Machine > Settings > Network
  2. Click on the Port Forwarding button
  3. Click the Add new Port Forwarding Rule for 7792
  4. Click the Add new Port Forwarding Rule for 7001
  5. Click the Add new Port Forwarding Rule for 7780 and enter the Guest IP 10.0.2.15 OR no IP address at so that it is empty/blank

DEVENV_PORTS

Note: You can bring out the value for Guest IP using the command /sbin/ifconfig in the VM terminal from the inet address.

DEVENV6

  1. Click OK twice to exit the Port forwarding and Machine settings
  2. Now on your local machine, open up the ODBC Data Source Administrator
  3. Go to the System DSN tab and click Add to add a new data source connection
  4. Select the OBIEE 12C driver and click Finish
  5. Enter the name for the ODBC connection and set Server to local and click next
  6. Enter the login ID and Password and the Port number 7792 [obis1 port], and check the Save login ID and Connect checkboxes, and click Next

DEVENV7

  1. If the next page is returned with no errors and you can see the databases, that means you are now connected successfully.
  2. Click Finish and OK to close the data source administrator

Steps to upload the development RPD:

  1. Place the saved RPD onto the VMShare shared folder on your local C drive
  2. In your VM Open up a terminal and navigate to the following path:

cd app/oracle/biee/user_projects/domains/bi/bitools/bin

  1. Then enter the following command to upload the RPD you placed in the shared folder

./data-model-cmd.sh uploadrpd -I /media/sf_VMShare/OBIEE_12c_tst_20160614.rpd -SI ssi -U weblogic -P Admin123

DEVENV8

  1. In the same folder path, stop the OBI services using the command: ./stop.sh
  2. Start OBI Services using the command: ./start.sh
  3. From your local machine log into BI Administration tool online, selecting the VM ODBC connection we created earlier, and enter the Username and Password.
  4. Verify that the RPD shown is your development RPD and not the Original SampleApp RPD.

Steps to loading the development Web Catalog:

  1. Place the saved (archived) Catalog onto the VMShare shared folder on your local C drive
  2. Log into the Analytics portal
  3. Click on Catalog in the global header
  4. Select the Shared Folders under Folders
  5. Click the Unarchive link under Tasks
  6. Browse and select the catalog you wish to unarchive from the VMShare folder
  7. Click OK

Steps to log into Catalog Manager:

  1. From your local machine select the Catalog Manager application
  2. Select File > Open Catalog
  3. Enter the URL as: http://localhost:7780/analytics/saw.dll
  4. And fill in the user name and password and click OK
  5. You should be able to log in successfully and view the Catalog objects you just unarchived.

DEVENV_opencatalog

And Finally, you are ready!

Sherry brings 8 years of technology experience developing and implementing Business Intelligence solutions with Oracle technology, delivering analytical reports, dashboards, custom metadata models, and KPI metrics for international organizations. She has excellent communication and organization skills and coordinates the BI teams she leads to success in even the most complex of client engagements. Having worked for years internationally with data and analytics for multinational corporations, she brings deep industry domain experience and account management skills to the Datavail BI & Analytics team. Sherry is a key contributor as a course creator and course instructor.

Leave a Reply

Your email address will not be published.
Required fields are marked (*).

6 thoughts on “Art of BI: Turn your OBIEE Sample App VM into a Development Environment”
  1. how do you download the RPD that is already there? In other words how do you download the RPD that came with the sample application?

    1. My apologies for the delayed response, but you can download the RPD just the same way we used the upload command. However since we do not know the password for the existing RPD we will need to make a copy by running the following command in that same bin folder:
      ./data-model-cmd.sh downloadrpd -O myobiee.rpd -SI ssi -U weblogic -P Password1
      Once downloaded you can then FTP the RPD onto your local PC and use it.
      Make sure you remember the password you entered for it as you will be prompted for it again.

  2. Hi!
    Hope you will fine.and enjoying good days.
    Can u please give me one favor to solve this problem?When i run my BI and DB its gives me error i.e.
    eading domain…
    /Servers/AdminServer/ListenPort=7001
    Accessing admin server using URL t3://demo.us.oracle.com:7001
    Starting AdminServer …
    Admin Server Start Exception: Error occurred while performing nmStart : Error Starting server AdminServer : Received error message from Node Manager Server: [Server start command for WebLogic server ‘AdminServer’ failed due to: [Server failed to start up but Node Manager was not aware of the reason]. Please check Node Manager log and/or server ‘AdminServer’ log for detailed information.]. Please check Node Manager log for details.
    Use dumpStack() to view the full stacktrace :
    Reading domain…
    /Servers/AdminServer/ListenPort=7001
    Accessing admin server using URL t3://demo.us.oracle.com:7001
    Requesting credentials …
    Enter Weblogic login details at prompt
    Weblogic Username: ^Call demo services have been started- leave this window open.

    and server is not starting…
    Please Help Us

  3. Hi Sherry,

    We need to build a report in Oracle BI Publisher. Please let me know that how we can achieve it as i am a beginner in this technology.

    The Requirement is :

    List all BI Publisher Reports and Dashbaords by Report Name, Created By, Document Updated Date, Document Shared With, User Type (Role/Responsibility) and Date Document Shared.