Page 1 of 1
Can we connect to MS SQL server thru DataStage
Posted: Thu Oct 07, 2004 8:20 am
by dsxdev
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
Posted: Thu Oct 07, 2004 12:49 pm
by trokosz
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
Posted: Thu Oct 07, 2004 4:22 pm
by ray.wurlod
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.