Tag Archives: salesforce integration

Bulletproof Tips to Optimize Data Transformations for Salesforce

Optimize Data Transformations for Salesforce

Optimize Data Transformations for Salesforce

In the journey from a single-purpose cloud CRM app to the behemoth that it is today, Salesforce has made many smart acquisitions. However, the recent purchase of RelateIQ may have just been its most ingenious. Although a relatively small startup, RelateIQ has gained a big reputation for its innovative use of data science and predictive analytics, which would be highly beneficial to Salesforce customers.

As relevant from the acquisition, there is little doubt that the cloud application world is making a tectonic shift to data science and the appetite for Big Data to be pieced together to fuel the highly desired 360-degree view is only growing stronger.

But while looking ahead is certainly important, those of us who live in the present have much work yet still to accomplish in the here and now. For many, that means figuring out the best way to leverage data integration strategies and the Salesforce platform to gain actionable intelligence for our sales, marketing and CRM projects – today. Up until recently, this has involved manual, IT-heavy processes.

We need look no further than three common use cases where typical data integration strategies and technologies fail today’s business users:

Automated Metadata Discovery
The first, and perhaps most frustrating, has to do with discovering related objects. For example, objects, such as Accounts, don’t exist in a vacuum. They have related objects such as Contacts that can provide the business user – be it a salesperson or customer service manager, with context of the customer.

Now, during the typical data-integration process, these related objects are obscured from view because most integration technologies in the market today cannot automatically recognize the object metadata that could potentially relate all of the customer data together. The result is an incomplete view of the customer in Salesforce, and a lost opportunity to leverage the platform’s capability to strengthen a relationship or close a deal.

The Informatica Cloud platform is engineered ground up to be aware of the application ecosystem API and understand its metadata. As a result, our mapping engine can automatically discover metadata and relate objects to one another. This automated metadata discovery gives business users the ability to discover, choose and bring all of the related objects together into one mapping flow. Now, with a just a few clicks, business users, can quickly piece together relevant information in Salesforce and take the appropriate action.

Bulk Preparation of Data
The second instance where most data integration solutions typically fall short is with respect to the bulk preparation of data for analytic runs prior to the data transformation process. With the majority of Line-of-Business (LOB) applications now being run in the cloud, the typical business user has multiple terabytes of cloud data that either need to be warehoused on-premise or in the cloud, for a BI app to perform its analytics.

As a result, the best practice for bringing in data for analytics requires the ability to select and aggregate multiple data records from multiple data sources into a single batch, to speed up transformation and loading and – ultimately – intelligence gathering. Unfortunately, advanced transformations such as aggregations are something that is simply beyond the capabilities of most other integration technologies. Instead, most bring the data in one record or message at time, inhibiting speedy data loading and delivery of critical intelligence to business users when they need it most.

Alternatively, Informatica has leveraged its intellectual property in the market-leading data integration product, PowerCenter, and developed data aggregation transformation functionality within Informatica Cloud. This enables business users to pick a select group of important data points from multiple data sources – for example, country or dollar size of revenue opportunities – to aggregate and quickly process huge volumes in a single batch.

In-App Business Accelerators
Similar to what we’ve experienced with the mobile iOS and Android platforms, there recently has been an explosion of new, single-purpose business applications being developed and released for the cloud. While the platform-specific mobile model is predicated on and has flourished because of the “build it and they will come” premise, the paradigm does not work in the same way for cloud-based applications that are trying to become a platform.

The reason for this is that, unlike with iOS and Android platforms, in the cloud world, business users have a main LOB application that they are familiar with and rely on packaged integrations to bring in from other LOB cloud applications. However, with Salesforce extending its reach to become a cloud platform, the center of data gravity is shifting towards it being used for more than just CRM and the success of this depends upon these packaged integrations. Up until now, these integrations have just consisted of sample code and have been incredibly complex (and IT-heavy) to build and very cumbersome to use. As a result, business users lack the agility to easily customize fields or their workflows to match their unique business processes. Ultimately, the packages that were intended to accelerate business ended up inhibiting it.

Informatica Cloud’s Vibe Integration Packages (or VIPs) have made the promise of the integration package as a business accelerator into a reality, for all business users. Unlike sample code, VIPs are sophisticated templates that encapsulate the intelligence or logic of how you integrate the data between apps. While VIPs abstract complexity to give users out-of-the box integration, their pre-built mapping also provides great flexibility. Now, with just a few keystrokes, business users can map custom fields or leverage their unique business model into their Salesforce workflows.

A few paragraphs back I began this discussion with the recent acquisition of RelateIQ by Salesforce. While we can make an educated guess as to what that will bring in the future, no one knows for sure. What we do know is that, at present, Salesforce’s completeness as a platform – and source of meaningful analytics – requires something in addition to run your relevant business applications and solutions through it. A complete iPaaS (Integration Platform as a Service) solution such as Informatica Cloud has the power to make the vision into reality. Informatica enables this through the meta-data rich platform for data discovery, Industry leading data and application integration capabilities and business accelerators that put the power back in the hands of citizen application integrators and business users.

Join our webinar August 14 to learn more: Informatica Cloud Summer 2014: The Most Complete iPaaS

FacebookTwitterLinkedInEmailPrintShare
Posted in Cloud, Cloud Application Integration, Cloud Computing, Cloud Data Integration, Uncategorized | Tagged , , , , , | Leave a comment

What do CIOs think about when integrating Salesforce?

Viswanath_0416Salesforce.com is one of the most widely used cloud applications across every industry. Initially, Salesforce gained dominance from mid-market customers due to the agility and ease of deployment that the SaaS approach delivered. A cloud-based CRM system enabled SMB companies to easily automate sales processes that recorded customer interactions during the sales cycle and scale without costly infrastructure to maintain. This resulted in faster growth, thereby showing rapid ROI of a Salesforce deployment in most cases.

The Eye of the Enterprise

When larger enterprises saw the rapid growth that mid-market players had achieved, they realized that Salesforce was a unique technology enabler capable of helping their businesses to also speed time to market and scale more effectively. In most enterpises, the Salesforce deployments were driven by line-of-business units such as Sales and Customer Service, with varying degrees of coordination with central IT groups – in fact, most initial deployments of Salesforce orgs were done fairly autonomously from central IT.

With Great Growth Comes Greater Integration Challenges

When these business units needed to engage with each other to run cross functional tasks, the lack of a single customer view across the siloed Salesforce instances became a problem. Each individual Salesforce org had its own version of the truth and it was impossible to locate where in the sales cycle each customer was in respect to each business unit. As a consequence, cross-selling and upselling became very difficult. In short, the very application that was a key technology enabler for growth was now posing challenges to meet business objectives.

Scaling for Growth with Custom Apps

While many companies use the pre-packaged functionality in Salesforce, ISVs have also begun building custom apps using the Force.com platform due to its extensibility and rapid customization features. By using Salesforce to build native applications from the ground up, they could design innovative user interfaces that expose powerful functionality to end users. However, to truly add value, it was not just the user interface that was important, but also the back-end of the technology stack. This was especially evident when it came to aggregating data from several sources, and surfacing them in the custom Force.com apps.

On April 23rd at 10am PDT, you’ll hear how two CIOs from two different companies tackled the above integration challenges with Salesforce: Rising Star finalist of the 2013 Silicon Valley Business Journal CIO Awards, Eric Johnson of Informatica, and Computerworld’s 2014 Premier 100 IT Leaders, Derald Sue of InsideTrack.

FacebookTwitterLinkedInEmailPrintShare
Posted in Business/IT Collaboration, CIO, Cloud Computing, SaaS | Tagged , , , | Leave a comment

Hybrid IT and the Latest Informatica Cloud Release

In a recent Information Management blog post, Alex Bakker from Saugatuck Technology noted:

“There is an underlying problem facing many, if not most enterprise IT leaders and organizations: these technologies [Cloud, Mobile, Social, Analytics and Integration] have developed much faster than enterprise IT groups and practices have been able to adopt and manage them.”

Sound familiar? Gartner (and others) have referred to the new reality of enterprise IT as Hybrid IT. At Informatica World next month, we have an entire track on this topic.

The good news is a topic that was once considered the “Achilles heel of cloud computing” is increasingly being recognized as the key enabler of cloud success:  integration and data management. With that in mind, Informatica rolled out our Summer 2013 release this week. Here are some highlights and useful resources. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Cloud Computing, News & Announcements, PaaS, SaaS | Tagged , , , , , , | 1 Comment

Announcing Informatica Cloud Spring 2013

On Wednesday we announced our latest cloud integration release – Informatica Cloud Spring 2013. It’s a major step forward in terms of breadth and depth for our software as a service (SaaS) solution. Why, you ask?

Well, yes…but…there are a few aspects to today’s announcement that I think are particularly noteworthy. Here’s a summary.

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Application ILM, Cloud Computing, Data masking, Data Quality, Master Data Management, Mergers and Acquisitions, News & Announcements, PaaS, SaaS | Tagged , , , , , | Leave a comment

Informatica Cloud Customer Success

There’s been a lot written about the importance of customer adoption and success to the software as a service (SaaS) model – there’s even a manifesto and a Bill of Rights! Last month, Informatica Cloud received the Bronze Stevie Award for customer support. One of the drivers for this achievement was not only great front-line customer service from a world-class support organization (they even support trial accounts!), but also the establishment of a customer success team, which is run by Bryan Plaster. I sat down with Bryan to discuss his views on the importance of customer adoption to any cloud computing application, platform or infrastructure initiative, as well as some specifics on how Informatica Cloud approaches customer success. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Business/IT Collaboration, Cloud Computing, Customer Services, Customers, Data Integration, Data Synchronization, PaaS, Real-Time, SaaS | Tagged , , , , , , , , | 2 Comments

Informatica Cloud Recognized by #Salesforce Customers for Data Integration

I’m pleased to announce that Informatica Cloud has once again been honored by salesforce.com customers with the AppExchange Best of ‘11 Award for Integration. Based entirely on user reviews for the Informatica Cloud listing on AppExchange, it’s clear that when it comes to Salesforce CRM and Force.com data integration requirements, Informatica Cloud has become the clear choice for salesforce.com customers. This is the  fourth year in a row that Informatica Cloud has achieved this honor, and our free Data Loader Service continues to be the all-time most popular application on the AppExchange. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Cloud Computing, Data Integration, Data Integration Platform, Data Migration, Data Synchronization, News & Announcements, PaaS, Partners, Real-Time, SaaS | Tagged , , , , , , , , , , , | Leave a comment

2011 #Cloud Integration Predictions in Review

‘Tis the season, but before I post my 2012 cloud integration predictions, I thought I’d spend a few minutes scoring how I did this year.  Last year I predicted the following:

  1. Cloud adoption will drive two-tier cloud integration strategies
  2. LOB-driven cloud integration projects will lead to strategic MDM initiatives
  3. Cloud integration platforms will emerge
  4. Database.com will gain enterprise adoption
  5. Private Cloud confusion will continue

Here’s my assessment: (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Business/IT Collaboration, CIO, Cloud Computing, Data Governance, Data Integration, Data Integration Platform, Master Data Management, PaaS, SaaS | Tagged , , , , , , , , , , | 1 Comment

Informatica Cloud Winter 2012 Announced

This week we announced the 11th release of Informatica Cloud. What’s Informatica Cloud you ask? Well according to the our 2011 “Best Cloud Management” CODiE Award, Informatica Cloud is an, “easy-to-use, multi-tenant cloud integration service that empowers users to create, schedule and automate bi-directional cloud-to-cloud and cloud-to-on-premise integration tasks without coding and without requiring a hardware appliance.”

This is an important release for 4 reasons:

  1. Informatica has expanded our cloud integration service to data quality
  2. We have greatly expanded our cloud connectivity
  3. We continue to deliver enterprise-class functionality via the cloud
  4. We are broadening the capabilities of Informatica Cloud Express, our pay-as-you-go cloud service. (more…)
FacebookTwitterLinkedInEmailPrintShare
Posted in Business/IT Collaboration, Cloud Computing, Data Quality, Marketplace, News & Announcements, PaaS, SaaS | Tagged , , , , , , , , , , , , , | 2 Comments

Video: Informatica Cloud @ Dreamforce 2011 #df11

I discussed cloud integration and Informatica Cloud momentum and customer success with SIIA’s Rhianna Collier at Dreamforce 2011. Some of the questions:

  • Are times changing when it comes to the importance of data integration to cloud computing adoption and success?
  • With the growth of social and mobile, how is innovation changing your customer needs?
  • Are you getting different questions from customers now with all of the industry changes?
  • Is the social revolution the focus of next year or is it more than that?
  • How do you monitor customer interactions and measure the ROI?

(more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Cloud Computing, Data Integration, Data Quality, PaaS, SaaS | Tagged , , , , , , , , , | Leave a comment

More On The “Achilles Heel Of Cloud Computing – Data Integration”

In March of last year I posted a blog here entitled: The Achilles Heel Of Cloud Computing – Data Integration.  “In fact, what currently limits the number of cloud deployments is the lack of a clear understanding of data integration in the context of cloud computing. This is a rather easy problem to solve, but it’s often an afterthought.”

So more than a year later, where are we?

While some progress has been made, many cloud computing implementation projects continue to ignore the value of a sound data integration strategy and the use of the right data integration technology.  Most paint themselves into a data quality and data synchronization corner, but give them time. (more…)

FacebookTwitterLinkedInEmailPrintShare
Posted in Big Data, Cloud Computing, Data Governance, Data Integration, Data Migration, Data Synchronization, News & Announcements, Partners, Professional Services | Tagged , , , , | Leave a comment