We are currently using PDI to capture data changes in one system and send them to another.
The system it is getting data from is a MSSQL 2005 Instance and this is where the locks are occurring.
We use a MYSQL Repository to host the transformations. The jobs seem to run fine but then hold onto the locks on MSSQL which takes the user application down.
Is there anything I can do to prevent this. It is causing massive disruption.
I'm not sure where to look to debug this.