SQLServer_Enterprise UNIX

marcelo_almeida · Post by **marcelo_almeida** » Wed Jul 08, 2009 8:41 am

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!

priyadarshikunal · Post by **priyadarshikunal** » Wed Jul 08, 2009 8:46 am

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.

prasad111 · Post by **prasad111** » Wed Jul 08, 2009 12:21 pm

SQL Server stages are availabe only for windows environment.

chulett · Post by **chulett** » Wed Jul 08, 2009 12:59 pm

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.

marcelo_almeida · Post by **marcelo_almeida** » Thu Jul 09, 2009 10:23 am

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!

Sreenivasulu · Post by **Sreenivasulu** » Fri Jul 10, 2009 5:52 am

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