How to move from ETI *EXtract to Datastage

kshivan · Post by **kshivan** » Mon Jul 19, 2004 1:04 am

HI Guys,

I come from an ETI background, One of my client would like to migrate to Datastage. I would need some help in assessing, what are the points we need to conver to move the existing ETI conversions to DataStage. The current ETI conversion jobs are running on Mainframe.

If you guys could help with your ideas it will be really great.

mleroux · Post by **mleroux** » Mon Jul 19, 2004 2:06 am

Mainframe accessibility in DataStage is not included in the software by default. As far as pricing is concerned, you'll need to take the pricing of the relevant plug-in(s) into account.

vmcburney · Post by **vmcburney** » Mon Jul 19, 2004 9:30 pm

You need to decide whether you want to leave the processing on the mainframe:
- use DataStage 390 jobs that compile into cobol code for mainframe execution
- pull the data off the mainframe and process it on the ETL server as server jobs or parallel jobs

There is no way to automate the migration from ETI to DataStage, you will be building the DataStage jobs from scratch (with all the advantages of shared containers, routines and table definitions to speed things up). What you need from ETI is a way to show the data lineage in each job and the transformation rules. This means going back to the documentation of the jobs (if it exists) or generating documentation out of the ETI repository or screen shots of ETI jobs.

s_boyapati · Post by **s_boyapati** » Tue Jul 20, 2004 9:35 am

Before all, you need to make a decision where you want to store your data( what DB and which OS). You need to choose appropriate products like DS390 and/or parallel extender(depends on servers and load size). look into accelerators and DSL used in ETI and the most important how you want to mange your metadata. MetaStage will tightly integrate with Datastage to solve that.

Sree