Enterprise stage and Connector stage in Datastage

Suruchi · Post by **Suruchi** » Tue Dec 13, 2011 5:07 am

Hi can anyone help me with the performance comparison of Enterprise DB stages and the connector stages? How do we decide upon the particular stage?

chulett · Post by **chulett** » Tue Dec 13, 2011 7:36 am

Welcome.

Performance is such a relative term that I don't believe you'll be able to get any generic answers to your question. More important, in my humble opinion, is the fact that Connectors are what IBM wants you to exclusively use and all other stages are 'deprecated' if you check the documentation.

qt_ky · Post by **qt_ky** » Tue Dec 13, 2011 9:33 am

Exactly. Connector stages are recommended going forward. Migrating from the older stage types to Connector stages is encouraged. That's why they included a Connector Migration Tool. The tools is referenced in the various connectivity guides (PDF files) installed on your client.

Suruchi · Post by **Suruchi** » Tue Dec 13, 2011 11:00 pm

Glad to see your answers. Where can i find the details of the backend changes made by IBM to bring in the connector stage?

My another query is in Datastage 8 we have ODBC enterprise as well as ODBC connector stage. how do we decide upon the selection of the stage?

ray.wurlod · Post by **ray.wurlod** » Wed Dec 14, 2011 12:26 am

We're informed that you would choose ODBC Connector, because IBM wants you to prefer Connector technology going forward.

Suruchi · Post by **Suruchi** » Wed Dec 14, 2011 4:59 am

Thanks Ray. Where can i find the performance comparison of both the stages? Enterprise vs connector.

qt_ky · Post by **qt_ky** » Wed Dec 14, 2011 7:16 am

You can easily compare the performance yourself.