Integrating COM Objects

JSimon · Post by **JSimon** » Tue Feb 19, 2008 10:20 am

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

deanwalker · Post by **deanwalker** » Tue Feb 19, 2008 12:06 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Feb 19, 2008 3:09 pm

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?

JSimon · Post by **JSimon** » Fri Mar 07, 2008 8:17 am

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

Thanks for the input,
Jason