How do we download the "active" repository in OAC? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How do we download the "active" repository in OAC?

Received Response
43
Views
6
Comments
Mark.Thompson
Mark.Thompson Rank 6 - Analytics Lead

Please let me know if there is a more appropriate forum for this question.  A search is not revealing one.

Let's say we have uploaded a data model (aka repository file, aka RPD) to OAC.  Let's then say that the laptop on which that data model was created, using the Admin Tool, is unavailable, and we do not have a local or backup copy of the RPD anywhere.  The only place it exists in the entire galaxy is up in the OAC servers.

Is there a way to download JUST the RPD from OAC?  I know that If we had created a snapshot, we could select its "Download" option, but that would download the entire .bar file, including the web catalog.  I don't want that.  I just want to download a copy of the active repository like I could in 12c on-prem.  How do I do that in OAC?

Answers

  • Hi,

    You do it like on a normal OBIEE 12c : datamodel.sh / datamodel.cmd

    The script is deployed on OAC (if you connect by SSH to the server) or also on any laptop/PC where you installed the Admin tool.

    If you use it remotely (from a laptop/PC) you need to make sure the required ports are open.

    With that script you can download or upload the RPD (and a bunch of other things).

    (Or, as you said yourself, get the whole BAR, open it and extract the RPD and delete the BAR )

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Gianni, I understand where this is going, and I like it.

    So, the usual download script in my on-prem OBIEE looks like this:

    call datamodel.cmd downloadrpd -O c:\obiee_12.2.1.2.0_client\bi\bifoundation\server\mystuff.rpd -W Admin123 -U myuid -P mypwd -SI ssi -y

    I want to run the download from my PC, where I have the Admin Tool installed.

    Where do I find the appropriate parameters to replace -SI ssi?   I am an admin on our OAC environment, so I can go to the console and see anything I need.  Where do I go to find those parameters, so that I can download the OAC repository onto my laptop without having to download the entire bar file?

  • Honestly? I don't remember if I had to change that or not (I did it long time ago once as a test ...).

    Can't you just look in the filesystem the name of the instance in case it isn't "ssi" ? That's how I generally do things (maybe not the most user friendly way but I know the filesystem never lie).

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    If you're unsure about the service instance name just WLST that sucker with listBIServiceInstances and then getBIServiceInstance

  • The key point is: forget the "cloud" cover of OAC, underneath it's at 95% the good (maybe not for everybody) old OBIEE (95% only because there are some new deployment scripts for the cloud side of things, but the core part is still "just" OBIEE).

    So connect by SSH to your instance and do things by command line there to check via WLST or in the filesystem.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    95%? Cute.