DSXchange

Can anybody tell the difference between Connector and Enterprise stage?

I have searched alot on the net and gone through both stages,but i only found that---
In Connector stage we can test the connection which we cannot do in enterprise stage.

If anybody knows more difference please let me know.

Basically, they are completely different under the covers with the Connectors being 'new' and which are what you should be using, while all other types (including the Enterprise ones) have been deprecated.

The enterprise stages are all fairly unique for each database, giving them a moderately high learning curve. The database connectors all use a standardized interface, which means if you learn one, you know how the others work.

That doesn't mean that there aren't specific database functions you must still be aware of - like the Temporary Work Tables the Netezza Connectors use.

In general, the connectors are faster and easier to use.

Thanks for reply Andy,

Can you please explain in detail. I am not able to understand

Deprecated stages
Connectors, which offer better functionality and performance, replace some stages, which have been deprecated and removed from the palette. However, you can still use the deprecated stages in jobs, and add them back to the palette.

- Quoted from this link.

I am curious if there any specific questions that are not answered in the product documentation.

Here's a Redbook that explains the differences between the Connector and Enterprise stages:

Redbook - InfoSphere DataStage Parallel Framework Standard Practices
http://www.redbooks.ibm.com/abstracts/sg247830.html

See Chapter 14 "Connector stage guidelines"

It details the LOB support, reject link enhancements, schema reconciliation, common stage design and other differences.