What is our primary use case?
We use the solution for cloud-to-cloud migration so our clients have all applications and data on their Oracle solutions, and we move it from there to AWS cloud and then to Salesforce. We're an implementation partner with Informatica and I'm the senior technical architect in the company.
What is most valuable?
The connectivity and their whole suite are valuable features. Whether we need data cleansing or data mastering, we get it all in one platform. There's no need to test different cloud vendors and then integrate with one solution. Informatica is a one-stop shop.
What needs improvement?
The one thing that I think could be improved is connectivity with the Salesforce because if you're loading a huge amount of data, whatever optimization is carried out, takes some time and it could be a little faster.
For how long have I used the solution?
I've been using this solution for a year.
What do I think about the stability of the solution?
We had some very minor issues initially, but the product is stable. We haven't experienced any down time.
What do I think about the scalability of the solution?
We've just completed the first part of the implementation. In the upcoming months we plan to carry out multiple implementations and then we might see some challenges in the scalability. I think it will be fine. I have about 35 users in my team - around 40% are developers, 30% are testers and QAs and then a few are designers, data modelers, and architects.
How are customer service and technical support?
The way we carried out our transformation was throwing some junk value as an output and that meant we had to reach out to Informatica to see what kind of configuration changes might be required. They were pretty quick to respond and knowledgeable about the issue, and dealt with it very well.
How was the initial setup?
The initial setup was very simple and took a couple of days. AWS provided everything for us.
Which other solutions did I evaluate?
We initially wanted to build the programming language in Python but the client's needs made us realize that Informatica was the way to go. Our initial design was something different and it was the cost that put us off going with Informatica as a first choice. If we had worked with something like Python, it could possibly have been more scalable and the cost reduced.
What other advice do I have?
If cost is not a issue then I would recommend Informatica as the tool of choice.
I would rate this product an eight out of 10.
Which deployment model are you using for this solution?
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)