How to create Plugin

[gsherry1]

Hello Forum,

How does one go about creating their own Plugin in DS? Is it feasible? Where is the procedures/interface documented? Does anybody have experience in doing this?

Thanks,

Greg

[ray.wurlod]

It's all documented in the DataStage Plug-In Writer's Guide, which should be available for the asking from the vendor.

To create the stage itself you need to be a very competent C programmer while to create a GUI for it you need C++ skills.

In my experience there ought almost never be a need to create your own plug-in stage; most things can be done with the product as it stands. For what functionality do you believe you need to create your own stage type?

[gsherry1]

Hello Ray,

Thank you for your response.

My client is using Teradata, and is discouraged by the performance of the Teradata API stage. They are using the API stage in some situations where they are not using MultiLoad because of some extra indexing requirements required by that stage.

A improvement in non-multiload loading to Teradata is expected in Hawk, but my client wanted to research some alternate solutions to waiting for that fix:

1. Calling BTEQ script to load from file via job control, sequence, or before job subroutine.
2. Writing their own plugin around BTEQ.
3. Using a Wrapper in Parallel Edition.
4. Migration of existing jobs to use Multiload instead.

[ray.wurlod]

Ah, one of those clients! OK, request the manual, maybe it will scare them off.

That said, if you have the skills, writing your own plug-in can be useful for functionality that DataStage lacks. For example, Hitachi (in Japan) created plug-in stages that allowed their database (HiRDB) to be accessed by DataStage.