DSXchange

Hi,

I am interested in exploring the possibility of integrating a COM object into a DataStage job. I'm not quite sure how I am going to tackle this, but I was wondering if anyone has attempted or done this before.

The reason I am trying to do this is the company I am currently at has a requirement to parse names. However, the company does not want to shell out 100-200k to IBM for QualityStage because they already purchased a different matching tool and are having a difficult time justifying purchasing QualityStage simply as a name parser.

There are some other cost effective solutions for JUST name parsing, but the majority seem to use COM objects. I don't have much experience in this area, so I am looking for anyone who does to point me in the right direction.

Thanks,
Jason

Importing External Function definitions - still known as ActiveX at this point !!

Be aware that invoking functions exposed via COM objects is noticeably slower than invoking other functions.

Also I'm not totally sure that you can call these external functions from parallel jobs - is it a C-callable interface?

To simplify the solution, I am going to run a batch job via shell script from a sequence job.

Thanks for the input,
Jason