What is our primary use case?
Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was very difficult to connect and integrate with other new applications. We used Informatica to read from our Hospital Information System and transform the data into a relational model in order to speed up reporting and do cleansing of the data. We also used Informatica to integrate SQL Server based applications with our Oracle applications.
How has it helped my organization?
Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System.
What is most valuable?
For how long have I used the solution?
Which solution did I use previously and why did I switch?
What's my experience with pricing, setup cost, and licensing?
Its maintenance is expensive.
Which other solutions did I evaluate?
Yes, we evaluated SSIS and IBM. We also looked at additional features in Informatica.