SQL Server Enterprise OR DRS connector?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

SQL Server Enterprise OR DRS connector?

Post by abyss »

Hi all
I am choose between SQL Server Enterprise and DRS connector (with wire protocol) to connect our SQL Server database.

Any suggestion on which one we should use?

Thanks
asorrell
Posts: 1707
Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas

Post by asorrell »

Based on some recent issues a couple of us have run into with the DRS Connector, I'd suggest only using the DRS Connector when you truly need the multi-database functionality.

I have not used the SQL Server Enterprise stage - can't make a strong recommendation either for or against it.
Andy Sorrell
Certified DataStage Consultant
IBM Analytics Champion 2009 - 2020
abyss
Premium Member
Premium Member
Posts: 172
Joined: Thu May 22, 2014 12:43 am

Post by abyss »

thanks asorrell

i did some further research on it:
The Microsoft SQL Server Client cannot be installed on UNIX. Because of this, The DRS plug-in stage on Windows uses the Microsoft OLE DB API for Bulk Load operations and the API is not available on UNIX.

The DRS Connector stage does not support Informix, Sybase and Microsoft SQL Server database types.
When a Dynamic RDBMS stage configured for one of these database types is migrated to a DRS Connector stage, the Database type property in the DRS Connector stage is set to value ODBC.

And SQL Server Enterprise stage use native SS connectors, as our engine tire installed on window server.

referencee read:
https://www.ibm.com/support/knowledgece ... RS060.html
https://www.ibm.com/support/knowledgece ... erver.html
https://www.ibm.com/support/knowledgece ... RS057.html


and asorrell :
do you use Wire protocol to connect to sql server?

thanks
abyss
Post Reply