Hey Cristi,
We have some online index operations that the Datamart jobs depend on (pentaho API) that SQL Server Standard Edition does not support. You would end up on an error like this when you try to do load data:
ERROR 2018-01-10 06:38:25,986 [dm_ticket UUID: 8c1a386a-466e-41cb-bb63-0529f1d9d6c1] pentaho.di.eventAdded() :: Rebuild Index - An error occurred executing this job entry :
Couldn't execute SQL: EXEC dbo.disableOrRebuidIndexes 'dm_ticket', 'CREATE'
Online index operations can only be performed in Enterprise edition of SQL Server.
So it forced us to support SQL Enterprise Edition only for Datamart.
_R