Posts Tagged 'data synchronization'

Cloud Integration: Batch vs. Real Time

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 (and other SaaS application vendors). Doug Henschen wrote about both cloud data integration product launches.

  1. 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).
  2. 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?

To me it gets back to a topic I’ve written about before: What to Look for in a Cloud Data Integration Solution.

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 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.



Oracle CRM On Demand Synchronized with

Migrating from Oracle CRM On Demand to 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.

Upgrading from the Data Loader to Cloud Data Integration Services

  • 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 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:

  1. Direct Enterprise Application Integration
  2. Connect to Multiple Endpoints
  3. Unlimited Schedules and Jobs
  4. Develop, Run, Reuse Integration Tasks
  5. Connect to Multiple Source Tables at Once
  6. Powerful LookUps
  7. Cross-Object Taskflow
  8. Any-to-Any Integration
  9. Performance
  10. Support

More information on Informatica Cloud Services for Salesforce CRM and integration is  available on the AppExchange.

Informatica Recognized by for Cloud Data Integration

appexchange award data integrationInformatica, 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’s AppExchange Best of ‘09 Awards for data integration.

Some highlights from the press release:

  • customers have voted the Informatica Cloud the top data integration solution for the second consecutive year.
  • recognizes top AppExchange partner solutions based on user reviews. (Check out Informatica Cloud Services here.)
  • More than 400 companies are now relying upon the Informatica Cloud to integrate Salesforce CRM and the platform with on-premise databases, flat files, and enterprise applications.
  • The Informatica Cloud is now running an average of 20,000 integration jobs per day and moving and manipulating more than four billon records a month.

Here’s a video summarizing the Informatica and partnership:

Cloud Integration Driving Business and IT Collaboration

In December, Informatica’s Chris Boorman predicted that, Cloud Data Integration will eclipse both security and availability to be the defining capability that drives Cloud Computing success.” He went on to note that:

“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.

From Cloud Data Loading to Synchronization

The Informatica Cloud Data Loader Service was recognized by in 2008 as the number one integration application on the AppExchange. In 2009 it has become the most popular *free* application (followed by Salesforce for Twitter) and the feedback has been truly amazing.
The Data Loader Service is designed to automate basic loading and extraction of data between, 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:
  • ERP Synchronization:  Opportunity-to-Order & Customer Master Synch (SAP, Oracle); Quoting Integration, etc.
  • 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:

Cloud Integration Use Cases

I wrote a post for the Perspectives blog today about Cloud Integration Use Cases. The obvious ones are:

  • Data Migration
  • Data Synchronization
  • Data Replication
  • Data Quality

What are yours? Here’s a quick poll:

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 7,150 other followers

Follow Me on Twitter


Sheffield View

Trying to keep up with Big Data Vendor Landscape

A Passion for Research

Focusing on CRM, cloud computing, ERP and enterprise software

SnapLogic Blog

Accelerate Your Integration. Accelerate Your Business.

Learning by Shipping

products, development, management...

Laurie McCabe's Blog

Perspectives on the SMB Technology Market

Andreessen Horowitz

Software Is Eating the World

%d bloggers like this: