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.

I like how powerful it is when working with different types of data. It makes transforming and moving data between systems much easier. Once you understand the workflow it becomes very efficient. It handles complex data tasks that would otherwise take a lot of manual effort.

FME platform handles data from a range of systems, including APIs, Excel sheets and GIS tools and it makes it straightforward yo bring everything together in FME and i regularly use transformers such as Tester and Joiner and the integrations with PostgreSQL and REST APIs have worked smoothly for me without issues. We also rely on automation through FME flow on a daily basis, once the workflows are set up, they run reliably and require very little ongoing input.