Migration from DataStage to Talend

abhishekachrekar · Post by **abhishekachrekar** » Fri Dec 30, 2016 3:36 am

Hi,

We are working on a project to migrate DataStage 8.7 to Talend.

Is there a tool/utility which can automatically convert DS code to talend?
If so then what is the percentage of code which can me automatically convert DS code to talend? what are the limitations?
Or do we need to manually migrate the code?
Can Unix scripts be called from talend code?
How to convert Routines in DS to talend?

Requesting DS folks who have worked on such migration to share their experiences which would be helpful to us for smooth migration.

chulett · Post by **chulett** » Fri Dec 30, 2016 8:05 am

Short answer? You are the tool.

vmcburney · Post by **vmcburney** » Sun Jan 08, 2017 8:25 pm

This is usually a fruitless exercise since it's a big waste of money without any gain for the business users and sponsors. You might be able to automate part of the migration by using a tool that can reverse engineer and generate ETL jobs like Analytix DS, otherwise you need to manually rebuild all jobs. This will cost a lot more than whatever money you are hoping to save by consolidating ETL tools.

You would be better off renegotiating the DataStage license - a DataStage WorkGroup Edition license is around the same price as Talend subscriptions. No need to redevelop any jobs.

Another option is to decommission your entire DW and start with a new one. Build the ETL from scratch and use something like the Data Vault to get a real time Data Warehouse that supports BI and analytics.

chulett · Post by **chulett** » Mon Jan 09, 2017 10:40 am

Thanks for stopping by Vincent! Always appreciated. :D

UCDI · Post by **UCDI** » Mon Jan 09, 2017 12:19 pm

chulett wrote:Short answer? You are the tool.

Hmm that could be taken a couple of ways.