Item: Informatica Intelligent Cloud Integration Services
Rating: 7
Author: Raviraj Raikar

Use Cases and Deployment Scope

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.

Pros and Cons

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.

Return on Investment

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.

Alternatives Considered

Oracle Data Integrator

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

Other Software Used

Infor BI, Microsoft Access

Likelihood to Recommend

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.

Cost Effective Data Integration Software for Low - Mid Complex Architecture

Overall Satisfaction with Informatica Cloud Data Integration