Pentaho

1 ) Yes (I only play with it to test)

2 ) Yes (But at version 8 > I got some erros, I dont use it in production any more)

3) Yes, you can use a job and make a schedule on it (by start step) but I do use external tools to do that (cron/git/CI-CD);

4) Yes, CE its very stable, EE version gets you extra features and support (most of the features are focus on cloud based services);

1.can we create clustering in CE ?

How can i perform clustering ? Is Carte server is the only way ?

4.Is it possible to use PDI CE in production environment ?

Have you used CE clustered environment in Production ?

1

Yes we can!

You can setup carte and use it in the spoon by add slave servers (or you can add and app from BA, i didnt test it yet);

I only use with it, it is possible to use BA Server but I never tested it (as a cluster);

4

• PDI CE in production yes, the most common (classic) for me is linux server with PDI and cron schedule;
• I dont. For my scenario didnt find the performance worth it