ODBC vs Plug-in stages

nsm · Post by **nsm** » Mon Nov 17, 2008 3:50 pm

Hi,

I just started working on IIS 8. Until now I am under the impression that Plug-in stages are faster than ODBC stage.

is that changed in IIS 8?

My client is using ODBC connector/ODBC Enterprise even when they have Plug-in stages.

Please let me know which is better.
Also what's the new features in ODBC Connector stage?

Thanks
nsm.

chulett · Post by **chulett** » Mon Nov 17, 2008 4:32 pm

I don't believe that generalization of ODBC being "slower" is still valid. I prefer "native" stages but some folks are not willing to install the database clients they need on the DataStage server. What's new should all be documented in the release notes.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 18, 2008 12:21 am

And then, Connectors (particularly) and Enterprise stage types are supposed to be faster than API (plug-in) stage types. So please be wary of assuming that what was true in earlier releases remains true in new releases. "They" do a lot of work on identified bottlenecks.

nsm · Post by **nsm** » Tue Nov 18, 2008 8:59 am

Thanks Chulett, Ray.

I have source as Sybase and Target as DB2.
So are you suggesting to use ODBC connector, ODBC Enterprise instead of sybase Enterprise, Sybase OC(not sure what this is)?

chulett · Post by **chulett** » Tue Nov 18, 2008 9:21 am

The Sybase OC (Open Client) stage is a native stage for Sybase, probably more suitable to Server. Me, I'm not suggesting anything. You and yours need to decide what is appropriate to use.

nsm · Post by **nsm** » Tue Nov 18, 2008 2:01 pm

As I didn't have Sybase stages setup, I can't even test Sybase OC stage vs ODBC connector. I can see them in the palette but Sybase databse conectivity is setup as ODBC connection so I can't connect to Sybase using SYBASEOC.

what I am trying to get to is performance wise and usability wise which will be better? so that If SYBASEOC is going to perform better then probably I will have the admin do the setup.

nsm.

chulett · Post by **chulett** » Tue Nov 18, 2008 2:11 pm

You would need to have your admins install the Open Client software for Sybase. That and make sure it is a supported version, from what I recall 12.0 and 12.5 are supported.