View Only

 Transformation stays idle with SQL Server table source PDY CE 9.4

Marc Stroo's profile image
Marc Stroo posted 09-27-2023 09:20

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.