Migration tools for Datastage

afreas · Post by **afreas** » Mon Jan 12, 2004 10:12 am

Anyone run in to any migration tools for datastage that can assist in the process of moving jobs from development environments to production environments. Looking particularly at tools that could integrate with things like Clearcase. Thanks much.
ART

chulett · Post by **chulett** » Mon Jan 12, 2004 10:20 am

The obvious answer is Version Control which ships with the product, except for the Clearcase part. I believe you'll find that other people are doing that via custom jobs, DSX 'cutters' that hack exports into bite-sized chunks. A search of this forum should turn something up.

vmcburney · Post by **vmcburney** » Mon Jan 12, 2004 4:37 pm

You've got import / export which saves the components to text or XML files, these can be loaded into a version control tool. If you go down this path you should look at an application that sets the read only field on all jobs in the export file so they can only be modified back in the development project.

You also have the version control tool which is very good for delivering components to other environments as read only and with a version history.

You have the parameter manager tool which manages job parameters between environments. Have a look at www.datastagexchange.com for details on this product.

I usually go with the Version Control tool for migrating components and use flat files to hold the job parameters so each environment has its own set of parameters. Have a look at the Custom Folders functionality in this tool for creating sub folders containing scripts called up by DataStage jobs.