DS7.5 Enterprise Edition - SQL Server 2000 plug-in

satish_valavala · Post by **satish_valavala** » Tue May 31, 2005 9:49 pm

Hi,
We have DataStage 7.5 Enterprise Edition(with PX). Target DB is on SQL Server 2000 Database.
Is there any specific plug-in stage for SQL Server 2000 connectivity. We are looking for the best stage for SQL Server connectivity.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 01, 2005 1:07 am

There is no specific stage type. You can use the ODBC Enterprise stage (which is probably "best"). You can also use the Dynamic RDBMS stage (DRS) with protocol set to ODBC. In either case, you will need to set up a "DSN" entry in $DSHOME/.odbc.ini describing where the SQL Server database is, and an entry in the uvodbc.config file in your project indicating that this DSN is an ODBC (not a UniVerse) connection.

satish_valavala · Post by **satish_valavala** » Thu Jun 02, 2005 10:30 am

Hi Ray,
Thanks for your response.
I found a new plug-in SQL Server Enterprise stage in DataStage 7.5 Enterprise Edition (PX) documentation. I am confusing in this regard. Could you suggest the best.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2005 3:44 pm

Not at the moment. I'm working on a non-PX site. If it's there, by all means plug it in and use it.

satish_valavala · Post by **satish_valavala** » Fri Jun 03, 2005 2:17 pm

Thanks Ray

vinaymanchinila · Post by **vinaymanchinila** » Wed Mar 08, 2006 2:35 pm

Hi Ray,
Is this still the case or are they out with the Plug in for SQL ?

Thanks,

alisoviejo · Post by **alisoviejo** » Wed Mar 08, 2006 3:26 pm

Or is it a standard plug in ?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 08, 2006 5:28 pm

Been working on a 7.5.1 site this week, and it is not there.

Maybe it's only available for 7.5x2 - that is, on Windows platforms.

The ODBC Enterprise stage can certainly access SQL Server via the supplied ODBC driver from a UNIX platform - we did exactly that today.