DSXchange

friends,

whats the difference between ODBC and plugin types of connections.


Thank you

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.

ArndW wrote: Plugins tend to be faster with DataStage.

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

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

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

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

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.

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.

As always, great article Vincent.

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