Cost Effective Data Integration Software for Low - Mid Complex Architecture
April 21, 2016

Cost Effective Data Integration Software for Low - Mid Complex Architecture

Raviraj Raikar | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User

Overall Satisfaction with Informatica Cloud Data Integration

Informatica Cloud Data Integration Suite is used by our client for seamlessly integrating data between Infor ERP and Salesforce CRM. Salesforce CRM is used across Organization by the key users of the different business entities. Informatica Cloud Data Integration helps in asynchronous transfer of data from Infor ERP to Salesforce CRM and vice versa. Since it is a cloud based application, a physical server is not required to house the applications. It helps meet the business requirements and is very cost effective.
  • Implementation of any integrations with Informatica Cloud Data can be done easily. A consultant with base knowledge about integrations can easily implement.
  • It has inbuilt aggregate functions which can be used during mapping source table fields with target table fields.
  • Source and Target database connections can be easily configured with minimum no of steps.
  • Source data can be easily filtered through by applying conditions.
  • It doesn't quite support complex implementations.
  • It doesn't support complex SQL Queries.
  • Working towards attaching a document to a mail, needs a work around. A shell script has to be written and to be executed.
  • Configuring integration for Re-processing of failed records needs proper design of the system.
  • Implementation of Integration of Infor ERP with Salesforce through Informatica Cloud Data Integration was cost effective.
  • Business users benefited with a lot of analytical business reports and historical data reports that would help them in better decision making.
  • Business benefited in having all required information in one application/dashboard, instead of wandering to multiple applications/screens for getting the required information.
The major reason in selecting Informatica Cloud Data Integration over the others was because of
1) Non-Complex Integrations
2) Cost factors for Licensing
3) Cost & Time Factors in Implementation
4) Data Volume involved in Integration
5) Error Handling
Informatica Cloud Data Integration is well suited for integration projects which involve non-complex architecture. For non-complex system integrations, Informatica Cloud Data Integrations is one of the most cost effective tools. Informatica Cloud along with MDM is widely used for integrating with Salesforce CRM. MDM helps in removing the duplicate customer information, and site/address details. For complex system architectures one would need to use Oracle Data Integrator or Informatica Power Center.

Informatica Intelligent Cloud Integration Services Feature Ratings

Pre-built connectors
Connector modification
Support for real-time and batch integration
Data quality services
Data security features
Monitoring console