Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Upload Bip Catalog

Received Response
101
Views
9
Comments
Carlos Carvalho
Carlos Carvalho Rank 6 - Analytics Lead
in Oracle Analytics Cloud and Server

Summary

Upload zipped.xdrz to new Bip installation Catalog by script

Content

Hello,

I have some reports (organized by folders) in the shared folder of bip catalog.

I can download it (to a folder.xdrz) and upload it to another Bip instance using the options in yellow on the attached image.

My question is: is there a way of doing that automatically (like with running some script) instead of clicking on the buttons, choose the folder, etc.. ?

The same is valid for the dataSource created in the Administration tab.

I would like to be able to automatize all this, pls.

 

Thanks and Regards,

 

Carlos

sharedFolder.PNG

Tagged:

Answers

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hello Carlos.

    I'm assuming you are using BIP within OBIEE.

    Please have a read a link below and search for the Command Line Utility RUNCAT.

    https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-65D7594D-6F3D-4AD8-9002-F9A2C4503A03.htm#BIESG2905

    Command Line Utility — You can invoke the command line utility on supported platforms for Oracle Business Intelligence such as Windows, Linux, IBM-AIX, Sun Solaris, and HP-UX. Enter a command such as the following one on Linux for assistance in using the command line utility:

    ./runcat.sh -help

    There is also this great article from Rittmanmead about source control that presents the use or archive and unarchive in an automated way.

    https://www.rittmanmead.com/blog/2016/12/source-control-and-automated-code-deployment-options-for-obiee/

    Hope this help.

    Cheers.

    Fernando

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Olá Fernando,

    Thanks for response.

    I am not using BIP within OBIEE, just plain simple standalone BIP installation.

    Even still i´ve tried to run the provided cmd line and there is no such file or directory :(

     

    Regards,

     

    Carlos

     

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Carlos.

    Try this then.

    https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-014104F7-13F2-47B7-BD68-AB948132ABAB.htm#BIPAD390

    Update*.

    Have a read at the Overview first.

    https://docs.oracle.com/middleware/12212/bip/BIPAD/GUID-350FFE8C-B3A4-4C21-BC0E-65C9E733CF58.htm#BIPAD4784

    Let us know the results.

    Regards.

    Fernando

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello Fernando,

     

    Thanks for the tip. You´ve pointed to the rigth direction.

    Just one more thing about the data source (as refered in original post): is it possible to 'copy' it somehow to the new environment trhougth some script/utility (like the catalog content was moved with that catalog utility)?

     

    Thanks and regards,

     

    Carlos

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Carlos.

    I don't have a stand alone version of BIP here to test but your datasource information should be inside a folder Admin in your catalog.

    Question. Your Dev and Prod environment share the same data sources? 

    Cheers.

    Fernando

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello Fernando,

     crying Using that utility i can not get any Admin folder while exporting catalog content. Might be another way?

     

    As you can see attached i have a jndi connection named 'jdbc/conceptNG' in BIP.

    That connection uses the weblogic jndi connection pool with the same name so that i only have the weblogic data source to change accordingly to the installation/environment.

    So, the question to your answer is:'Yes', i have the same data sources names in all environments/installations, but change the ip address accordingly in weblogic to the DB of that location.

     

    Regards,

    Carlos

    BipDS.PNG

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Carlos.

    All good on the connection.

    One last resource to migrate the data source is to find the datasource.xml file in your BI Publisher installation and migrate the file.

    Not the best way but it is a workaround.

    Always perform a backup before doing that.

    Cheers.

    Fernando

  • Carlos Carvalho
    Carlos Carvalho Rank 6 - Analytics Lead

    Hello Fernando,

    Once again thanks. Another strike wink

    I found the datasource.xml file in the domain.

    Now i would like to upload/migrate it to the new environment using some script/api/utility (i do not wish to login to the destination weblogic). Do you know how?

    I´ve thougth about using WLST, but the documentation ( https://docs.oracle.com/middleware/1221/biee/BIESG/em_wls_config.htm#BIESG9333 ) is about obiee, and i do not have obiee installed.

    Any hint?

    Thanks.

    Carlos

  • FPonte
    FPonte Rank 6 - Analytics Lead

    Hi Carlos.

    I did one time this when I first deployed my dev to a new test environment. It was basically a copy of the file via OS command from one environment to another.

    I performed a backup of the original file on my test environment before doing that.

    Cheers.

    Fernando