CODEWITHSUNDEEP
oracle-data-integrator
Srini
Srini

Reputation: 29

Export all scenarios from execution repository(prod) in ODI12c

I have to take backup of all scenarios from execution repository(prod) in my local machine, do we have any best way to do this(i think exportallscen tool will not work for execution repository)? basically am looking to automate the process to export all the scenarios,avoid manual work.

Thanks!

Upvotes: 2

Views: 1567

Answers (1)

JeromeFr
JeromeFr

Reputation: 1928

Here are 3 options to achieve an automatic export of all scenarios :

  1. Using the OdiExportAllScen tool directly from the command line on the agent.
  2. Creating a package or a procedure with an OdiExportAllScen tool, generate a scenario and import that scenario on the execution repository. It can then be executed from there. A variable will be needed for the INSTANCE parameter so it can be used in every environment.
  3. Using the ODI SDK in Groovy or Java. The method to use is exportAllScenarios() from class ExportServiceImpl. You will need to pass a Project or Folder name to that method though. So if you need to export all the scenarios from a repository, you first need to loop through all the projects.

Upvotes: 2

Related Questions