Page 1 of 1
Is SQL Server plug-in available with DS 7.5(server edition)?
Posted: Wed May 25, 2005 4:00 pm
by sh_valavala
Hi,
To access SQL Server 2000 database, is there any exclusive SQL Server plug-in available with DataStage 7.5 version(server edition).
Regards
Posted: Wed May 25, 2005 4:38 pm
by ranga1970
Nothing else other than ODBC
Posted: Wed May 25, 2005 4:41 pm
by chulett
Exclusive? As in 'native', like the OCI stages for Oracle? No, not that I've seen.
Posted: Wed May 25, 2005 4:50 pm
by kiran_418
Hi
New version of datastage 7.5.1 has plug in for Misrosoft OLE database and Microsoft SQl server Load.
Posted: Wed May 25, 2005 4:56 pm
by chulett
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.
Posted: Wed May 25, 2005 6:25 pm
by sh_valavala
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
Posted: Wed May 25, 2005 6:31 pm
by ranga1970
I guess still its ODBC
Posted: Wed May 25, 2005 8:26 pm
by sh_valavala
Thanks Ranga.
Regards