We implement business intelligence solutions, including data warehousing tools, data integration to load data into warehouses, and then creating reports.
What is our primary use case?
How has it helped my organization?
It improves decision-making overall for the company. Informatica is usually the tool for setting up the data, streaming the data into your data warehouse from your source, transforming the data, and preparing and modeling it into some desired format.
It improves the performance. You need to know how to use it and how to implement it, but it improves performance.
What is most valuable?
It helps with real-time data processing.
What needs improvement?
Skill requirement is required. There is a learning curve.
For how long have I used the solution?
I have been using it for ten years.
Which solution did I use previously and why did I switch?
Azure Data Factory is a Microsoft product. It is a similar tool, but it's mostly for Microsoft implementations. Informatica is generic; it can work with any environment.
How was the initial setup?
The deployment process is difficult.
You can install it within a few hours or a day, and in theory, it works. But the reality is that to implement proper business intelligence products usually takes from a few weeks to up to a few months.
What other advice do I have?
Overall, I would rate the solution an eight out of ten.
Usually, Informatica is for big clients because of its pricing, and it also requires some skill sets. It requires investment into a proper data integration team or investment into some consultancy.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
![Informatica Data Engineering Streaming [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_100/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT)