BIEE to OAC migration scripting

User_78HDA

Summary

Is it possible to script or automate the migration of BIEE rpd files to OAC on a periodic basis?

Content

If changes are made relatively infrequently to a set of BIEE report definitions on premise.

Would it be possible to automate or provide some form of script that could migrate the report definitions from BIEE to OAC on a predefined periodic basis?

Version

12.2.1 BIEE

Gianni Ceresa

Hi,
Technically speaking everything can be scripted (even if sometimes it just isn't worth it as the script take longer than doing things by hand).

The ways to migrate things from OBIEE to OAC are documented and defined, the important part is more the process. OAC is "alive", things happen there, content can be created, edited or deleted. This is where periodic migrations generate issues: you migrate the RPD from your OBIEE to OAC, but between last migration and now somebody created a new model in OAC and your push of your OBIEE rpd not just deleted that.

Based on the process you have in place in OAC for content creation you could have some possible ways of doing the job, it just heavily depends on what happen on your 2 systems.

To go back to the script side, OAC is heavily REST service driven. Some documented, some not really, but if you want you can definitely reproduce your manual process of pushing your RPD to OAC by code.