DS7.5 Enterprise Edition - SQL Server 2000 plug-in
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
DS7.5 Enterprise Edition - SQL Server 2000 plug-in
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.
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.
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
-
- Premium Member
- Posts: 353
- Joined: Wed Apr 06, 2005 8:45 am
-
- Participant
- Posts: 49
- Joined: Fri Nov 11, 2005 10:19 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.