Page 1 of 1
SQLServer_Enterprise UNIX
Posted: Wed Jul 08, 2009 8:41 am
by marcelo_almeida
Hi,
We can use the stage SQLServer_Enterprise in DataStage version 8.1 with UNIX?
Or is there some SQLServer driver that can be used on UNIX?
Thank you!
Posted: Wed Jul 08, 2009 8:46 am
by priyadarshikunal
Don't know if it is available in version 8.1 for Unix. But you always have ODBC based stages to connect to SQL Server.
Wait till someone working on 8.1 for unix replies.
Posted: Wed Jul 08, 2009 12:21 pm
by prasad111
SQL Server stages are availabe only for windows environment.
Posted: Wed Jul 08, 2009 12:59 pm
by chulett
True but they've supplied ODBC wire drivers for SQL Server for some time now. They are there on both my 7.5.2 and 8.1 servers and are how you'd connect from a UNIX server.
Posted: Thu Jul 09, 2009 10:23 am
by marcelo_almeida
In fact, I'm doing the migration of a project that was created on a windows server to a UNIX server. This project has several jobs that use the stage SQLServer_Enterprise and I scaled the work that we have to perform the migration.
Thank you all!
Posted: Fri Jul 10, 2009 5:52 am
by Sreenivasulu
SQL Enterprise Stge is only avaiable in wiindows versions of datastage.
In Unix versions of dtastage you can use ODBC Connector or ODBC Enterprise stage.
Regards
Sreeni