Page 1 of 1
DSMigrate - Has Anyone heard about it ?
Posted: Wed Sep 29, 2004 2:25 pm
by kiran_kom
Hi,
Has anyone heard about a Job migration tool called DSMigrate ? I want some information about this tool.
Posted: Wed Sep 29, 2004 2:38 pm
by kcbland
Well, Google seems to be a good search tool
DSMigrate doesn't look like it has anything to do with DataStage
Posted: Wed Sep 29, 2004 2:44 pm
by chulett
DSMigrate = Directory Services Migration Tool for NetWare. As Ken notes, Google is your friend.
Posted: Wed Sep 29, 2004 3:10 pm
by sumitgulati
DSMigrator is an Ascential's proprietary tool that converts ETL jobs\mapping from one tool to DataStage Jobs. It was under development and bug fixing until June.
I have heard of this tool being used to convert Infomatica mappings to DataStage Jobs. I do not know if it has been made compatible with any other ETL tool. I am also not aware of the level of complexity the tool can handle in Jobs.
Regards,
Sumit
Posted: Wed Sep 29, 2004 3:16 pm
by chulett
Ah... DSMigrator. Probably not something they allow "out of house", I would think.
Posted: Wed Sep 29, 2004 3:30 pm
by sumitgulati
I do not know if ascential has any plans to ever release it as a product.
Posted: Wed Sep 29, 2004 6:00 pm
by vmcburney
Could be in use by the Ascential/PeopleSoft team that is migrating Informatica PeopleSoft jobs across to DataStage jobs for PeopleSoft EPM clients.
Posted: Wed Sep 29, 2004 6:10 pm
by sumitgulati
Yaa, the tool development actually started for PeopleSoft migration from Informatica to DataStage.
Posted: Thu Sep 30, 2004 11:44 am
by kiran_kom
thanks for the information guys..... I hoping it was publicly available
Posted: Thu Sep 30, 2004 4:56 pm
by vmcburney
It would be very nice if Ascential released it as an unsupported utility, and it would probably get a tit-for-tat response from Informatica in the form of a migrator that goes the other way.
Informatica converter very complex
Posted: Mon Oct 04, 2004 4:23 pm
by flashgordon
Hi,
I had a chance to work on the Peoplesoft DW conversion of Informatica last February 04 at an Ascential client. The conversion tool got 90% of the job done but it's the other 10% that kills you. Ascential had one of their best Datastage guys in there plus myself and Peoplesoft employees, and it was a killer. All kinds of wierd things happen when you are dealing with datatypes between Informatica and Datastage. No conversion tool could anticipate how that business decided to use some of the data types and always do the right things. You want an example. This company had a simple integer code for one field. Informatica for some reason 0 filled it to a certain number of decimal places. This business got used to it and insisted that it be that way. The Ascential converter came along and converted it back to a simple integer (what I think was the right thing to do) but we spent all this time making Ascential do what Informatica did. So if Ascential were to give the tool out I would argue it should only given to very mature, technically competent people who don't have access to any lawyers.
... Flash