Migration from OWB to datastage

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jan 08, 2013 10:39 am

In our account we have 1000 OWB Jobs approximately, these Jobs to be migrated to NEW tool Datastage.

1)I do not know how to proceed could anybody please help me how to proceed for migration?
2)Do we have any tool like connector Migration to achieve my requirement?

AS of now I am analyzing existing Jobs in OWB.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 08, 2013 3:39 pm

I would continue along the path you are on - analyse the logic and reproduce it using DataStage.

There may be conversion tools (I am not aware of any, but IBM are always keen to nab Oracle sites, so may be prepared to help). In my experience, however, the results produced by conversion tools, even where functionally correct, are usually sub-optimal.

chulett · Post by **chulett** » Tue Jan 08, 2013 4:49 pm

Don't expect or force a one-to-one conversion, either. 'Reproduce it using DataStage' means the logic / work being performed, not the number of steps involved - although they could be similar.

lstsaur · Post by **lstsaur** » Tue Jan 08, 2013 5:19 pm

Absolutely no other conversion tools, but re-write using DS.