How to run ODI Mapping in groovy script?

Question

I have thousands of mappings created in ODI. I need to execute those, but executing them one by one doesn't seem to be a feasible option.

I'm trying to write a groovy script that could fetch a list of all the mappings, iterate through each of the mappings. I'm able to achieve this, but I'm unable to figure out how to run the given mapping.

Here is my script:

def fm = ((IMappingFinder) tme.getFinder(Mapping.class))         

def mappingList = fm.findAll().findAll{w -> w.getProject().getCode() == 'STOO'}
if (mappingList == null){
  println "Map is null"
}

ms=mappingList.iterator()
while(ms.hasNext()){
    ms_i = ms.next()
    println ms_i.getName() // INSERT CODE TO EXECUTE MAPPING HERE
}

This script prints the mapping name, I just need a way to execute it. Pls help!

JeromeFr · Accepted Answer · 2017-09-16 17:42:42Z

3

The class RemoteRuntimeAgentInvoker from oracle.odi.runtime.agent.invocation will let you start a scenario or a load plan.

For an execution on the local agent, it can be done with the class RuntimeAgent from oracle.odi.runtime.agent. But you won't be able to run Load Plans on the local agent, it can only run on a remote agent.

answered Sep 16, 2017 at 17:42

JeromeFr

1,9282 gold badges17 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to run ODI Mapping in groovy script?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related