![ETL Solutions Transformation Manager vs. OpenText Alloy [EOL] report](https://www.peerspot.com/assets/media/images/icons/pdf-c33db68f.svg){kind=icon}
![OpenText Alloy [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_64/durwsc3z47nd2vx5dltpkmpv49gk.jpg?_a=BACAGSDL)
![OpenText Alloy [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_30/durwsc3z47nd2vx5dltpkmpv49gk.jpg?_a=BACAGSDL){kind=small}
![OpenText Alloy [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_40/durwsc3z47nd2vx5dltpkmpv49gk.jpg?_a=BACAGSDL){kind=small}
Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing. I would like it if we could set the solution up to process and respond to real-time events. For example, say I want to configure an app to run based on the mileage a car has driven, and I configure the metering system, so the event occurs every 15 days. Let's say we want to automatically send an alert to EMS, police, etc. if a car gets into an accident. Transformation Manager is more of a conventional tool for reporting, extracting volume, bulk loading, etc. but there should be more provisions for dealing with real-time events, creating some insights, and dealing with perishable data. Ten minutes after the accident, the data doesn't have value. It has value before you saved the person.
