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

Question

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 · Accepted Answer

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 · Accepted Answer

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.