At my current client they use SQL Server 2016 as database for both table source and target with PDI 9.4 on Windows. Now when I run some very simple transformations, they stay on idle. Also when closing the SQL editor of the table in step, this won't close and I have to force close it. What is the source of this issue and how can I solve it? Now PDI looks like a flawed tool, making it hard to give a proper demo of it's capabilities to my client.
On internet I find something that suggest that it might be that PDI keeps a session open. Is that correct? If so, how can that be fixed from PDI itself? My team DBA can't kill sessions.