Page 1 of 1
SQLSERVER stage
Posted: Fri Sep 03, 2004 6:45 pm
by ksmurthys
Hi
I am new to datastage.Is there any stage to connect directly to SQLSERVER 2000 database? Pls help me out.
Thanks,
Murthy.
Posted: Fri Sep 03, 2004 7:26 pm
by ray.wurlod
The only way to connect to SQL Server from a UNIX machine is via the ODBC driver supplied with DataStage. You will need to declare a DSN bu editing .odbc.ini in the Engine and uvodbc.config in the project.
On a Windows server, again ODBC is the usual method, though you will also be able to use OLEDB. Either will need a DSN configured. Don't use a User DSN, however.
To answer the question implied by your subject line, there is no specific SQL Server stage type, even in the Windows-based version of DataStage. While it would be possible to write one (the API is published), no-one's felt the need, and there are lots of sites out there connecting to SQL Server.