CODEWITHSUNDEEP
repositoryinformaticainformatica-powercenter
Novice_Techie
Novice_Techie

Reputation: 444

Automated process to export PowerCenter Workflows as XML

Currently we export workflows from PowerCenter Repository manually one by one. I was wondering is there any process / or can we have a script that can read workflow names from a .txt file and export those workflows as XML and save it to some location.

Our Infa Server is on Unix.

Any help /suggestions if we can achieve this highly appreciated.

Upvotes: 1

Views: 3570

Answers (2)

Maciejg
Maciejg

Reputation: 3353

Use pmrep to list all workflows, then loop over the list and invoke pmrep objectexport, e.g.:

#Specify folder name:
FOLDER=`<FolderName>`

#Get list of all workflows:
 WORKFLOWS=`./pmrep listobjects -o workflow -f ${FOLDER} | grep workflow | sed 's/workflow//g'`  

 for WORKFLOW in $WORKFLOWS; do  
      echo "[INFO]: Processing Workflow ${WORKFLOW}"  

      # export single workflow  
      ./pmrep objectexport -o workflow -f $FOLDER -n $WORKFLOW -m -s -b -r -u ${EXPORTDIR}/${FOLDER}_${WORKFLOW}.xml  

 done

Upvotes: 2

Lars G Olsen
Lars G Olsen

Reputation: 1118

Yes it’s possible

Create your own shell script that executes the ‘pmrep’ command multiple times. Personally I would create a query inside the repository manager client tool, and then execute that query with pmrep.

Please get back to us if you have further questions.

Upvotes: 0

Related Questions