Posts Tagged 'data replication'

Tapping Into the Value of Your Cloud Application Data

Whether your a sales operations manager, analyst, CRM administrator or information architect, integrating cloud application data with other sources for reporting and analysis across systems has become a critical business requirement. The challenge with traditional data integration approaches is the frequency of change to the cloud application data model. How many new custom fields or objects did you add to Salesforce today? What was IT’s role in the change management process? How long were you willing to wait for your data integration scripts to be updated?

As one Salesforce customer put it in this AppExchange review:

“With a product like Salesforce.com, which gives you so much power to do quick database configuration changes, you need a product like Informatica Cloud to give you that same agility on the data integration side. What good is being able to add a new field in to Salesforce.com in just minutes if it takes months to get the data you want in to that field? For us, Informatica Cloud has all but eliminated that problem.”

Even Informatica’s own IT organization recognized the value of a cloud-based data replication service. According to Peter Vanderhaak,

“Once we realized how robust and easy to use Informatica Cloud could be, the following day we had a replication job moving data into a test data warehouse target – capturing incremental data changes and easily adaptable against an ever changing Salesforce data model. This would have taken weeks of development effort in a constantly changing SFA environment in the middle of a project that was still determining what fields and objects to create. Additionally, the ongoing maintenance would have caused major headaches and increased run-rate costs.

Well today I noticed this 5-star AppExchange review and I thought it was worth sharing:

Isn’t time you looked to see if cloud data replication might help you better tap into the value of your data?

Cloud Integration Customer Success

Ever wonder what the benefits are of having the right strategy for cloud integration?

Here is a summary of two Salesforce.com customers who integrate CRM and on-premise applications, databases and files. The first is a mid-sized company that enabled nontechnical business users to perform self-service cloud-based data integration. Benefits include:

  • Enhanced the accuracy and timeliness of enterprise data for better business decisions
  • Helped the company compete more successfully in a challenging building supplies market
  • Introduced 360-degree, near real-time, dashboard view of business operations
  • Improved customer service via launch of innovative customer portal and other initiatives
  • Reduced the cost and risk associated with managing technology
  • Increased cost control though improved agent and customer credit checking and management
  • Increased the reliability and availability of critical operational data

Download the case study here.

The second is a Global 2000 enterprise that introduced a fast, low-risk route to data replication as service for analytical reporting purposes. Benefits include:

  • Reduced the time required to prepare certain reports from days to minutes
  • Allowed the organization to make faster, more accurate decisions, based on a single version ofthe truth
  • Ensured delivery of timely, relevant, and trustworthy information throughout the organization
  • Saved money using low-cost subscription-based pricing
  • Enabled more robust reporting and analysis on Salesforce.com data
  • Leveraged existing skills in on-premise reporting tools to build better, faster reports

Download the case study here.

Cloud Data Replication for Better Business Intelligence

salesforce logoI posted an interview on the Informatica Perspectives blog today that highlights the importance of  data replication as a service as part of a Salesforce analytics strategy. A few highlights:

“Once we realized how robust and easy to use Informatica Cloud could be, the following day we had a replication job moving data into a test data warehouse target – capturing incremental data changes and easily adaptable against an ever changing Salesforce data model. This would have taken weeks of development effort in a constantly changing SFA environment in the middle of a project that was still determining what fields and objects to create. Additionally, the ongoing maintenance would have caused major headaches and increased run-rate costs.”

To populate hourly changes we use the data replication service to populate staging tables to populate our enterprise BI solution.”

“With the Informatica Cloud data replication service, new fields and changes to existing objects can occur without there being an impact on our analytics downstream. It allowed us to be able to report on every single piece of data in our sales system in our data warehouse on day one of the salesforce.com implementation.”

You can read the entire interview here.

Data Replication as a Cloud Integration Service

Last week the Informatica Cloud monthly webinar focused on Data Replication as a Service. The discussion was centered around the growing importance of data replication as part of a cloud application strategy and summarized three critical steps:

  1. Determine your use case. Potential data replication as a service use cases include compliance, archiving, reporting and analysis, and enterprise data warehousing.
  2. Identify specific objects and columns. Instead of replicating all objects and columns, can you take advantage of incremental loads, changed data capture, eliminate deletions, etc.
  3. Establish a replication schedule. While batch data movement is critical for backup, an operational reporting use case may require near real time.

Many of the questions were about on-premise to on-premise use cases:

  • Can you move data from an Oracle database to a file (and vice versa)? Yes!
  • Does the use case have to be focused on a Cloud application like Salesforce.com? No!

You can view the presentation here and download a best practice data integration as a service for Salesforce.com whitepaper here.

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

  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 Force.com integration is  available on the AppExchange.

Informatica Recognized by Salesforce.com 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 salesforce.com’s AppExchange Best of ‘09 Awards for data integration.

Some highlights from the press release:

  • Salesforce.com customers have voted the Informatica Cloud the top data integration solution for the second consecutive year.
  • Salesforce.com 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 Force.com 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 Salesforce.com partnership:

Cloud Integration: Helping to Deliver Your Morning Paper

Here’s an Informatica Cloud customer video illustrating a data replication use case from Salesforce.com to a database hosted on Amazon’s Cloud. Now that’s mission critical data integration as a service!

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.

Top In(tegrate) the Cloud Posts of 2009

Call me crazy, but I enjoy the annual Best and Worst, Top 10, and Prediction articles that are everywhere this time of year. And while I’m disappointed that none of my LucidEra posts made it on to Donald Farmer’s 2009 business intelligence blog highlight reel, here are the post popular In(tegrate) the Cloud Posts for the year:

  1. You Know You Work for a European Company When (clearly SAP’s new Budweiser marketing strategy works – 5000+ views for this BusinessObjects video)
  2. If It’s Not Multitenant, It’s Not Really SaaS (generated some good discussion)
  3. The Importance of Data Integration in the Era of Cloud Computing (one of the first posts on this blog)
  4. Data Loader Service: Most Popular AppExchange Free App (have you downloaded it yet?)
  5. IDC Publishes Cloud Services Benefits and Challenges (who hasn’t used these graphs in a slide yet?)
  6. Questions to Ask a Salesforce Integration Solution Provider (is it multitenant? how much training is required? can I try before I buy?)
  7. Cloud Integration Use Cases (replication is the primary based on the poll)
  8. Salesforce Integration with BigMachines (connecting 2 very popular SaaS apps)
  9. Cloud Integration for Competitive Advantage (competing on integration?)
  10. Twitter and Salesforce Integration with the Informatica Cloud (big news – Twitter is popular!)

And I’m pleased to say that traffic is growing. More validation that, “Cloud Data Integration will eclipse both security and availability to be the defining capability that drives Cloud Computing success?” Perhaps.

Integration Clouds Blog Stats

Thanks for reading (and commenting). Happy New Year!

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 4,586 other followers

Follow Me on Twitter


Laurie McCabe's Blog

Perspectives on the SMB Technology Market

saastr

thoughts on web services people pay for

hireED4HigherEd

studentforce .... designed by students for students

Richard Seroter's Architecture Musings

Blog Featuring Code, Thoughts, and Experiences with Enterprise Solutions

Kellblog

The official blog of Dave Kellogg

Follow

Get every new post delivered to your Inbox.

Join 4,586 other followers

%d bloggers like this: