DSMigrate - Has Anyone heard about it ?

kiran_kom · Post by **kiran_kom** » Wed Sep 29, 2004 2:25 pm

Hi,

Has anyone heard about a Job migration tool called DSMigrate ? I want some information about this tool.

kcbland · Post by **kcbland** » Wed Sep 29, 2004 2:38 pm

Well, Google seems to be a good search tool

DSMigrate doesn't look like it has anything to do with DataStage

chulett · Post by **chulett** » Wed Sep 29, 2004 2:44 pm

DSMigrate = Directory Services Migration Tool for NetWare. As Ken notes, Google is your friend.

sumitgulati · Post by **sumitgulati** » Wed Sep 29, 2004 3:10 pm

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

chulett · Post by **chulett** » Wed Sep 29, 2004 3:16 pm

Ah... DSMigrator. Probably not something they allow "out of house", I would think.

sumitgulati · Post by **sumitgulati** » Wed Sep 29, 2004 3:30 pm

I do not know if ascential has any plans to ever release it as a product.

vmcburney · Post by **vmcburney** » Wed Sep 29, 2004 6:00 pm

Could be in use by the Ascential/PeopleSoft team that is migrating Informatica PeopleSoft jobs across to DataStage jobs for PeopleSoft EPM clients.

sumitgulati · Post by **sumitgulati** » Wed Sep 29, 2004 6:10 pm

Yaa, the tool development actually started for PeopleSoft migration from Informatica to DataStage.

kiran_kom · Post by **kiran_kom** » Thu Sep 30, 2004 11:44 am

thanks for the information guys..... I hoping it was publicly available

vmcburney · Post by **vmcburney** » Thu Sep 30, 2004 4:56 pm

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.

flashgordon · Post by **flashgordon** » Mon Oct 04, 2004 4:23 pm

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

DSXchange

DSMigrate - Has Anyone heard about it ?

DSMigrate - Has Anyone heard about it ?

Informatica converter very complex