I had been exploring best possible ETL tools for extracting data loading it to SQL Server. We have to create data warehouse Can we achieve it using Pentaho Community Edition or we need to buy the enterprise edition?
We can also explore other better options apart from Pentaho.
you can create a job in pentaho community edition and schedule it for every 5 minutes execution to refresh your data,in linux machine then you can achieve this using cronjob,windows machine you can do this using windows task scheduler.