The SQL Server interface library

InfoSphere® DataStage® can share data with external Microsoft SQL Server data sources.

Four InfoSphere DataStage operators provide this access:

• The sqlsrvrread operator reads records from an external data source table and places them in a data set.
• The sqlsrvrwrite operator sets up a connection to SQL Server and inserts records into a table. The operator takes a single input data set. The write mode of the operator determines how the records of a data set are inserted into the table.
• The sqlsrvrupsert operator lets you insert into or update a table with data contained in a data set. You can match records based on field names and then update or insert those records.
• The sqlsrvrlookup operator lets you perform a join between a table and a data set, with the resulting data output as an InfoSphere DataStage data set.