ODBC vs Plugins

[Edwink]

friends,

whats the difference between ODBC and plugin types of connections.


Thank you

[ArndW]

The difference is that the methods of connecting other than ODBC are usually direct ones supplied either by the manufacturer or a third party. ODBC is an open de-facto standard interface (free on windows, not always free elsewhere) to allow a common access to databases or database-like objects (i.e. MS Excel)

Plugins tend to be faster with DataStage.

[DSguru2B]

Plugins tend to be faster with DataStage.

...due to the fact that it uses native drivers than generic ones.

[ArndW]

I used "tend to" because I seem to recall the Informix ODBC driver was faster than the direct connection for server.

[dsdoubt]

...due to the fact that it uses native drivers than generic ones. ...

Then what is the difference between, Enterprise stages and API stages?

[DSguru2B]

Enterprise stages utilize full parrallism and can do loads along with inserts. More is available by going through the manuals.

I should have added that in cases where native api stages are faster, its due to the usage of native drivers.

[vmcburney]

An IBM technical article on the DataStage DB2 enterprise stage had it benchmarked at extracting data 250% faster than the parallel DB2 API stage. You can assume this also makes it a lot faster than an ODBC extract or a server edition job.
See my blog entry DataStage Tip: Extracting database data 250% faster for details.

[DSguru2B]

As always, great article Vincent.

[ray.wurlod]

Pity the DB2 Enterprise stage doesn't actually exist in server jobs.