Enterprise vs Plug in

agpt · Post by **agpt** » Wed Oct 06, 2010 12:28 pm

Hi,

What is the difference between Enterprise stage and plug in stage? For example FTP enter prise stage vs FTP plug in stage or ODBC Enterprise stage Vs ODBC Plug in?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 06, 2010 3:26 pm

Why so many "what is the difference between..." posts?

Enterprise stages have innate parallel capability (even if it can't always be gainfully employed). API stages originate from the server engine and always execute in a single (sequential) process.

agpt · Post by **agpt** » Wed Oct 06, 2010 11:09 pm

ray.wurlod wrote:Why so many "what is the difference between..." posts?

Enterprise stages have innate parallel capability (even if it can't always be gainfully employed). API stages originate from the server engin ...

Thanks Ray!!!!

Reason for so many what's diff posts is just to get things clear in my head.

I am really thankful to the guys reading and replying to my posts to clear my doubts.

vmcburney · Post by **vmcburney** » Wed Oct 06, 2010 11:48 pm

Soon you are going to have to consider Connector vs Enterprise vs Plug In. If you are on 8.1 it is worth considering the connectors for ODBC, DB2, Oracle and Teradata as they are newer, tend to have better reject handling, can be faster and have more accurate metadata import.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 06, 2010 11:59 pm

Not to mention the Connector for MQ Series