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!


RSS In(tegrate) the Clouds RSS

  • An error has occurred; the feed is probably down. Try again later.

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

Join 4,804 other followers

Follow Me on Twitter


A Passion for Research

Focusing on CRM, cloud computing, ERP and enterprise software

SnapLogic Blog

Thoughts on Integration Platform as a Service (iPaaS), Analytics and the SnapLogic Integration Cloud

Learning by Shipping

products, development, management...

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

Follow

Get every new post delivered to your Inbox.

Join 4,804 other followers

%d bloggers like this: