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.
Migration from DataStage to Talend
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 45
- Joined: Wed May 02, 2007 8:30 am
- Location: Prague, Czech Republic
Migration from DataStage to Talend
Regards,
Abhishek
Abhishek
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn