In the last few days there have been diametrically opposite messages coming from two vendors who claim to deliver best-in-class data integration solutions for Salesforce.com (and other SaaS application vendors). Doug Henschen wrote about both cloud data integration product launches.
The first vendor focused on data migration to the cloud. They acknowledged that data migration “often turns out to be more complex than expected” and highlighted the importance of performance to data integration (while throwing a few unsubstantiated haymakers at the competition I might add).
The second vendor focused on real-time application integration, making the claim that their product, “offers two-way, system-to-system, event-driven integration that is real-time rather than batch oriented.”
Hmmm. So which is more important? Real time or batch data integration? And is it really an either-or proposition? Are we really now dragging the old ETL vs. EAI debate to the cloud?
If a data integration vendor claims to be all about one or the other it should be a red flag. The bottom line is to understand your requirements, your data volumes (both today and long term), your integration complexity (both today and long term), your resources (on-premise or SaaS?), and the skill set of your users (SaaS administrators and IT roles). And when it comes to a Salesforce.com partner, be sure to dig into customer references and read the reviews on the AppExchange. This will reveal quite about about overall customer adoption and success.
Migrating from Oracle CRM On Demand to Salesforce.com? Looking for bi-directional synchronization between CRM applications? Check out this new Informatica Cloud integration demonstration. It’s drag and drop, point and click, cloud-to-cloud data integration as an on-demand service. Be sure to check out the working beta of the Informatica Marketplace for more examples.
Master data integration (customer, product, pricebook, etc.)
ERP synchronization (processes such as Opportunity to Order)
Business/IT alignment (self-service for the line of business, trust and control for IT)
I received a few questions from Salesforce.com customers who are already taking advantage of the popular (and free)AppExchange Data Loader Service about the unique capabilities that are continuing to drive upgrades to Informatica’s Cloud Services for bi-directional data synchronization as a service. Here’s my top 10:
Informatica, the leading independent provider of enterprise data integration software, today announced that Informatica Cloud Data Loader Service for Salesforce CRM, a component of the Informatica Cloud, was honored with salesforce.com’s AppExchange Best of ‘09 Awards for data integration.
“2010 will be the year when data integration delivers for the cloud and provides the ease of use that business users require together with the trust and control that IT demands.”
Here he is providing an overview of Informatica Cloud Services and explaining how the right approach to data integration as a true cloud-based service will help organizations deliver timely, relevant and trustworthy data.
The Data Loader Service is designed to automate basic loading and extraction of data between Salesforce.com, flat files, and relational databases on a daily basis. But the Informatica Cloud Data Loader Service is just the first step towards secure, powerful, and complete data integration as a service.
The next step, you ask?
The Informatica Cloud Data Synchronization Service. The industry’s only true enterprise-class software as a service integration solution, the Data Synchronization Service is designed for non-technical users to set-up, manage, and monitor bi-directional integration tasks. Primary use cases for the Data Synchronization Service include:
CRM Integration: Cases, Leads, Campaigns; Territory Management; Price Book & Product; Custom Objects, etc.
Business / IT Alignment: Business self-service to trusted information; IT avoids proliferation of point solutions.
This is a first in a series of posts that outline some of the key reasons that Salesforce customers continue to upgrade (in just a couple of clicks) from the Data Loader Service to the Informatica Cloud Data Synchronization Service. Here’s a brief demonstration of integrating secure FTP files with Salesforce using the Informatica Cloud: