How To Backup the Semantic Model | Metadata Repository (RPD)?

Vitalii_Alliance_dgtl

Good day, community.
The question arose, whether it is possible to configure an automatic backup of the repository in which I work ?

At the moment I just make a copy of the repository and that's all, but it all happens manually, is it possible to automate this process?

Gianni Ceresa

Ok, moved the question in the OAC & OAS (and OBIEE) category as it's about the RPD and Admin tool.

The admin tool doesn't have any embedded feature for backups. But it's just a file, therefore you can setup any backup process you want on that file.

If it's an offline RPD, then you could look at some Windows utilities to make backups (or any other 3rd party program in Windows that can take backups of a file).

If you are working online and would like to take backups, you can script the download of the RPD using datamodel.cmd inside bi\bitools\bin of your admin tool installation. The same script exists on the server if you want to schedule backups on the server directly.

In the end, it's all done outside the admin tool, because the tool itself doesn't have anything for that.

If you want backups of your development, like versioning, then you could convert your RPD into the MDS XML format and that can be versioned in any versioning tool (git or anything else).

TSoracco-Oracle

Hi - You can write a cron job in Linux to run $DH/bitools/bin:

./datamodel.sh downloadrpd.sh

Have the cron job run daily and it will download a daily copy of the RPD so you always have a current copy of the RPD.

Gianni Ceresa

Hi,

You mean the RPD (semantic model)?

I'm asking because your title would point there, but the category is "Publisher", therefore you maybe mean something else… (if you mean RPD, I will move your question to the right category)

What product and version is that about? (there have been various ways to do the job over the various versions)

Vitalii_Alliance_dgtl

I use Oracle BI Administration Tool, Version 12.3

it's all a repository. in the properties, you can make a copy of this repository, is it possible to set it to automatic creation?