Informatica Cloud -- a professional level product for professional organizations
February 20, 2019
Informatica Cloud -- a professional level product for professional organizations
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Informatica Cloud
We currently use Informatica Cloud to integrate data between our Oracle financial system, Salesforce.com and our internal transactiton processing system. Being cloud-based, we do not have the added overhead of maintaining our own server infrastructure to implement this solution. Informatica Cloud is a critical part of allowing us to meet both our technical and business requirements.
- Informatica Cloud has a relatively easpy learning curve for new users and developers
- Multiple database sources and targets are easily defined
- Extensive built-in features and functions allow us to define the required mapping for our data needs
- Some of the error messages are cryptic and difficult to discern the meaning and cause of the error
- The ability to use sophisticted and complex SQL is somewhat limited
- Some of the syntax for the built-in data formatting is a little difficult to understand
- Informatica Cloud has proven itself a worthwhile investment as it has allowed us to "retire" numerous other data systems through integration
- The only negative to Informatica Cloud (the same with most other tools) is the substantial upfront cost of implementation (licensing/professional services, etc.)
Having used SQL Server Integration Services (SSIS) in the past, Informatica Cloud was a huge-step up in functionality, usability and performance. Hands-down, Informatica Cloud is a much more robust product overall. While SSIS is well-suited for specific instances (i.e. SQL Server-specific implementations), Informatica Cloud is a much better product as an overall integration/transformation tool.