Is SQL Server plug-in available with DS 7.5(server edition)?

sh_valavala · Post by **sh_valavala** » Wed May 25, 2005 4:00 pm

Hi,
To access SQL Server 2000 database, is there any exclusive SQL Server plug-in available with DataStage 7.5 version(server edition).
Regards

ranga1970 · Post by **ranga1970** » Wed May 25, 2005 4:38 pm

Nothing else other than ODBC

chulett · Post by **chulett** » Wed May 25, 2005 4:41 pm

Exclusive? As in 'native', like the OCI stages for Oracle? No, not that I've seen.

kiran_418 · Post by **kiran_418** » Wed May 25, 2005 4:50 pm

Hi
New version of datastage 7.5.1 has plug in for Misrosoft OLE database and Microsoft SQl server Load.

chulett · Post by **chulett** » Wed May 25, 2005 4:56 pm

True, but the MS OLEDB stage has been around for awhile and is a fairly 'generic' stage. There still isn't a native SQL Server plugin stage as far as I know.

sh_valavala · Post by **sh_valavala** » Wed May 25, 2005 6:25 pm

I thank all,for your responses.
Is MS OLEDB is native Plug-in for SQL Server?
Which stage is best suitable to access SQL Server 2000 database with DataStage 7.5 server version.

Regards

ranga1970 · Post by **ranga1970** » Wed May 25, 2005 6:31 pm

I guess still its ODBC

sh_valavala · Post by **sh_valavala** » Wed May 25, 2005 8:26 pm

Thanks Ranga.

Regards