Using groovy to edit existing mapping in ODI, How do I not duplicate datastore
I'm using groovy to edit an existing mapping in ODI 12.2. In the mapping there is already an source datastore and a target datastore. I want to use it, but I keep duplicating the source and target datastore. Is there way to do this?
I'm new to groovy any help would be extremely helpful.
//mapping
txnDef = new DefaultTransactionDefinition()
tm = odiInstance.getTransactionManager()
tme = odiInstance.getTransactionalEntityManager()
txnStatus = tm.getTransaction(txnDef)
Mapping map = ((IMappingFinder) tme.getFinder(Mapping.class)).findByName(folder, mappingName)
dsf = (IOdiDataStoreFinder)tme.getFinder(OdiDataStore.class)
mapf = (IMappingFinder) tme.getFinder(Mapping.class)
tme.persist(map)
//insert source table
boundTo_emp = dsf.findByName(SRCdatastore, SRCmodel)
comp_emp = new DatastoreComponent(map, boundTo_emp)
//insert target table
boundTo_tgtemp = dsf.findByName(TRGdatastore, TGRmodel)
comp_tgtemp = new DatastoreComponent(map, boundTo_tgtemp)
comp_emp.connectTo(comp_tgtemp)
createExp(comp_tgtemp, boundTo_tgtemp, "LAST_NAME", "SRC_CUSTOMER.LAST_NAME")
deploymentspec = map.getDeploymentSpec(0)
node = deploymentspec.findNode(comp_tgtemp)
println deploymentspec.getExecutionUnits()
aps = deploymentspec.getAllAPNodes()
tgts = deploymentspec.getTargetNodes()
tme.persist(map)
tm.commit(txnStatus)
I want it to edit my existing expression from source to target datastore but instead it creates a duplicate source and target datastore and add the expression there.
You are creating new DatastoreComponents instead of using the existing ones from the mapping. You can find the existing ones by invoking findComponent method on your mapping.
Try replacing
comp_emp = new DatastoreComponent(map, boundTo_emp)
with
comp_emp = map.findComponent(SRCdatastore)
Same goes for the target component.
You can also remove the following line if the source and target are already connected in the mapping :
comp_emp.connectTo(comp_tgtemp)
- Is there the opposite of AttributesToJSON in NiFi?
- Replaceall JSON in Groovy for Jenkins
- Capture console output of multiple processes with Groovy
- Nextflow capture output file by partial pattern
- Groovy read file line by line and store it into list
- Regex for complex delimited string with multiple parse patterns
- Kotlin like scope functions (let, also, apply, run) in Groovy
- Jenkins - How to Create Dynamic Parallel Stages?
- Get the testcase status in soapui TearDown script
- How do I pass variables between stages in a declarative Jenkins pipeline?
- Syntax of compound IF statement in Groovy
- Misunderstanding of the groovy syntax in the jenkinsfile
- Is there a way to list all gradle dependencies programmatically?
- @Grab not working in intellij IDE for groovy
- Dynamically append value to spock test method name based on method annotation
- Tail recursion with Groovy
- How to add a file I create in groovy in Jenkinsfile to the artifacts?
- "$" is being removed when used bash inside groovy
- How to get the built jar file after the build task in the form of java.io.File object?
- Getting `No such property: importPackages for class: org.codehaus.groovy.ast.ModuleNode` when using Groovy 4 from Apache
- What Java versions does Griffon support?
- Spock unclear assertion behavior
- Jenkins pipeline trigger build on code changes from specific branch
- In Groovy, How do I fix this error: groovy.util.slurpersupport.GPathResult
- Jenkins groovy postbuild alternative
- Why does working with XSSFWorkbook modify the original file?
- How do I list all of my Jenkins credentials in the script console?
- Gradle Could not find org.codehaus.groovy:groovy:4.0.12
- Groovy syntax for regular expression matching
- Is there a way to pass a constant to an annotation in Groovy?