I use FME mainly for scheduled jobs that support our reporting system. It connects to SQL Server, pulls in some API data and then pushes cleaned outputs into Power BI datasets. The ability to chain multiple steps into a single workflow is useful. I’ve also used custom transformers to reuse the same logic across different reports, which saves time and keeps things more consistent in the long run. Review collected by and hosted on G2.com.
It can feel a bit heavy for fast changes. When a stakeholder asks for a small adjustment, I sometimes prefer to handle it outside of FME because its simply faster. Review collected by and hosted on G2.com.