ETL 4.9 includes support for connection sharing for all these destination components:
DB Bulk Load Sybase IQ
DB Data Sink Insert
DB Data Sink Update
DB Data Sink Delete
This new functionality allows you to use multiple database components to access the same source or target table without any lock table failure error. It allows components to share a single connection to the database with other target components that have defined identical connection and database parameters. In versions earlier than 4.9, project execution failed when two or more components tried to access the same table at the same time. Now, with the new connection sharing functionality you can extract data from multiple source tables and upload it into a single target table simultaneously. It also allows you to perform bulk-loading into a Sybase IQ database, leading to better performance.
The connection sharing functionality is supported only between components in the same project. Components that exist in different projects but inside the same job cannot share a connection. Also, you cannot use connection sharing functionality with the existing ETL multiple writer functionality.
Components that define the same database interface and
login information, but have differing database options cannot share
a connection, and generate an error when the project is executed
or simulated.
See Chapter 5, “Components” in the Sybase ETL 4.9 Users Guide.
