nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Upload Bip Catalog

Carlos Carvalho

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

Find more posts tagged with

Reporting

Accepted answers

All comments

FPonte

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

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

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

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

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

Hello Fernando,

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

FPonte

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

Hello Fernando,

Once again thanks. Another strike

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

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