Migration options for Informix, Sybase and MS SQL Server database types

The DRS Connector stage does not support Informix®, Sybase and Microsoft SQL Server database types.

When a Dynamic RDBMS stage configured for one of these database types is migrated to a DRS Connector stage, the Database type property in the DRS Connector stage is set to value ODBC.

In order for the migrated job to run, you must ensure that the ODBC data source definition (DSN) specified for the Connection name in the DRS Connector stage is defined on the system and configured to point to the same database to which the original Dynamic RDBMS stage was pointing. InfoSphere® Information Server provides a set of ODBC drivers. Drivers for Informix, Sybase and MS SQL Server database types are also included.

If the Update action property in the original Dynamic RDBMS stage was set to Bulk insert, the Write mode in the target DRS Connector stage will be set to value Insert. The stage that originally used to write data to the database through the native bulk load interface provided by the backend database will be inserting the data using SQL INSERT statements instead.

Note: The Sybase and Microsoft SQL Server ODBC drivers included with Information Server support bulk write mode of operation. This option can be configured for the ODBC DSN definitions used by the DRS Connector stages that were migrated from the Dynamic RDBMS stages configured for Microsoft SQL Server or Sybase bulk load write mode.