DataStage and SQL Server 2008 connectivity

harborboy76 · Post by **harborboy76** » Mon Apr 12, 2010 12:17 am

We just completed 8.1 DataStage installation on Windows OS. I need to
create a connection to SQL Server 2008. But when I create a parallel job
and pick SQL Server Enterprise, I do not know how to point to the SQL
Server environment. Is there a step-by-step documentation that I can
follow anywhere or has anyone successfully connected to SQL Server
without using ODBC ?

Thanks!

ray.wurlod · Post by **ray.wurlod** » Mon Apr 12, 2010 3:22 am

Welcome aboard.

Open the manuals (Start > All Programs > Information Server > Documentation) and scroll down to "Connectivity Guide for Microsoft SQL Server and OLE DB Data"

Sreenivasulu · Post by **Sreenivasulu** » Mon Apr 12, 2010 7:56 am

I think the metadata db on sqlserver2008 is not supported but as a target database its supported

Regards
Sreeni

harborboy76 · Post by **harborboy76** » Wed Apr 21, 2010 11:20 pm

I have been able to create a connection to SQL Server from Windows but
not much luck on the Linux server. Does anyone know if SQL Server Enterprise Stage is available ?

I was able to create an ODBC data source but wondering if there is a simpler way.

Eventually, what I'm trying to accomplish is be able to pass different
database names in my job parameters at runtime. Using ODBC would
mean that I have to pre-create all data sources ahead of time.

ray.wurlod · Post by **ray.wurlod** » Thu Apr 22, 2010 1:35 am

SQL Server Enterprise stage is not available on any UNIX/Linux platform. You need to use ODBC Enterprise stage.