Can we connect to MS SQL server thru DataStage

dsxdev · Post by **dsxdev** » Thu Oct 07, 2004 8:20 am

Hi All,
We are using MS SQL server as our Database and DataStage is installed on Unix Server.

Can we pull data from MS SQL Server thru DataStage and process it. If it is possible how can this be done.

Any inputs on this will be welcome.

Thanks

trokosz · Post by **trokosz** » Thu Oct 07, 2004 12:49 pm

You can access SQL Server in one of two ways (1) ODBC Stage (2) On the SQL Server platform extract and create a flat file, then have the flat file FTP'd to the DataStage Server where you then would read via a Sequential File Stage or use a FTP Stage

You can write to SQL Server in one of two ways (1) BCPLoad Stage is a passive plug-in stage supplied by Ascential. A BCPLoad plug-in stage bulk loads data into a single table in a Microsoft SQL Server (Release 6.0 or 6.5) or Sybase (System 10 or 11) database. The files are loaded into the target database using the bulk copy API. By default, the BCPLoad stage is configured to bulk load data into a Microsoft SQL Server (2) ODBC Stage

ray.wurlod · Post by **ray.wurlod** » Thu Oct 07, 2004 4:22 pm

Look in the .odbc.ini file; there will be an entry for the SQL Server driver. Its library name is of the form vmmsssnn.so (or .sl).
Search the forum; others have done this before you.