Export DataStage Jobs as XML

[rbanavar]

Hey Guys,
The SCM team for our project expects us to export each job individually as a dsx file and store it in PVCS, so that they can migrate it. The issue is, we have over 12 projects and each project has a lot of jobs. Individual job export as a dsx file, using the DS Manager would be such a painful and time-consuming task. Does anybody have an automated way to export jobs? Any help would be greatly appreciated!
Thanks
Ravi B

[chulett]

Sure! There is a lovely little DOS batch job over on the ADN website that will automate this for you. If you are subscribed to it, then here is a direct link to the DataStageBackup.zip file in the Product Application file library there. It will export all jobs from all projects on a server.

Only thing to note is that command line exports will be in .dsx format, not XML as you have in your title. Oh, that and the fact that it will export all jobs in one .dsx, not many seperate ones. You would need to tweak it in order to that, either that or search the forum for the 'DSX Cutter' that someone posted awhile ago.

[T42]

I believe there IS an option to export as XML. However, I do not know what this option are. I do not have access to a server at the moment to experiment with this.

Play around with that script chulett suggested. Hope you know DOS batch script language.

[chulett]

I believe there IS an option to export as XML.

Unless there is something new in 7.5, command line exports are strictly dsx format. Yes, you can do xml exports from the Manager, but they must be done manually.

[Sainath.Srinivasan]

Try to grep the lines between (including) BEGIN JOB and END JOB lines and put them in seperate dsx. You will need to extract the generic header line in dsx across all jobs.

[chulett]

Here is the cutter I mentioned. No need to reinvent the wheel.