Automation on Migration

vamsi_4a6 · Post by **vamsi_4a6** » Tue Dec 08, 2015 4:20 am

I have one project A consists of parallel Jobs,shared containers,parameter sets,parallel routine etc.
I have some job list present in excel which needs to migrated to another project B.I want to automate this thing using script and is it possible in datastage.basically if i have list of components and i want to migrate the components from one project to another project.

Questions:
1)Which one i need to use DSXImportService.sh or dsexport/dsimport commands or dscmdexport/dscmdimport?

2)Any inputs on how to proceed?

PaulVL · Post by **PaulVL** » Tue Dec 08, 2015 9:16 am

You should look into the "istool" command on the Unix side. That is your best bet for automation.

It does component extract as well as load.

You can (and should) use that extracted file and place it into an external file control system (subversion, etc...)

vamsi_4a6 · Post by **vamsi_4a6** » Thu Dec 10, 2015 3:38 am

1)Thanks for input.I know how to use Istool command but not sure how to proceed in my case since i have job list present in excel which needs to migrated to another project.How to give Data Input from excel to Istool?

PaulVL · Post by **PaulVL** » Thu Dec 10, 2015 12:32 pm

Datastage 11 reads excel sheets right?

vamsi_4a6 · Post by **vamsi_4a6** » Mon Dec 14, 2015 6:02 am

./istool export -domain serviceshost:9080 -u dsadm -p password -ar test.isx -ds '-incdep -base="ENGINEHOST/Dev_Project" Jobs/*/*.*'

Question:
I know how to read the excel file in Datastage.I have list of jobs to be migrated in excel sheet but not sure how to give input from excel to above istool command.Basically the code highlighted in bolt colour

qt_ky · Post by **qt_ky** » Mon Dec 14, 2015 6:30 am

Have fun with that.

PaulVL · Post by **PaulVL** » Mon Dec 14, 2015 9:50 am

Well... you shall be calling a command line function and passing a parameter.
You could write a shell script that accepts N amount of parameters... or reads a text file with N amount of lines...

Many ways to deal with it... but... you should be able to think of something that suites your needs.

I would shell script something that accepts a few parameters. 1) project name 2) text file that has the code to load 3) output log file name for status output.

Assuming of course that the user id running the job has authority to load the code. Passing an Auth File might be best since you could then use the same code across multiple projects.

BTW: you won't be doing port 9080 with version 11x.