Tuesday, January 25, 2011

Finally!! DRS plugin got its replacement as DRS Connector

Until recently DRS plugin was common and extensively used connectivity mechanism with-in InfoSphere DataStage. As it was intended to run sequential mode many performance concerns. As it provides one place shop for all RDBMS was 1st being considered as option. As it provides mechanism for custom SQL and use of SQL from file was famous with customers than other plug-ins.

IBM InfoSphere DataStage team recently released a new Dynamic Relational Stage Connector which can provide better performance and based on new parallel technology. Currently it is available only for IBM DB2, Oracle and ODBC database types. It even provides bulk load for DB2 and Oracle a complete add on compare to older DRS stage.
All older ETL jobs can be easily migrated to this new Connector Stage and get all benefits using Connector Migration Tool. As it is part of Next Generation Suite, will get all the benefits including more features and better support. It can use for all features available as part of other available Connectors including XML and blob. Also shared metadata. It wasn't the case with DRS Plug-in.

 Disclaimer: "The postings on this site are my own and don't necessarily represent IBM's positions, strategies or opinions.

1 comment:

  1. Ritesh,

    Thanks for the information on Dynamic Relational Stage Connector.

    We are trying to use the connector to connect to oracle db. We are not getting any oracle error messages in the Datastage log file. Can you please suggest any work around.