The Coming Democratization of Data Integration

Michael Vizard, September 4th, 2012

Salesforce.comIt used to be that integrating data across different applications required an unnatural act involving complicated pieces of middleware. In recent times, accomplishing that act has become easier thanks to lighter-weight middleware based on standard Web services and RESTful APIs. But even still, accomplishing that task still requires the skills of a developer. In contrast, the next revolution in data integration is going to be characterized by business users integrating data across applications on their own at will.

That’s the ultimate end goal of the data integration technologies being developed by Salesforce.com. According to Quinton Wall, director of technical platform marketing for Salesforce.com, the company created technologies such as streaming APIs to allow business users to more easily reach that “aha moment” where all the data their organization collects has material business value because it’s now easier to correlate information across Salesforce.com and other applications.

Historically, in order to achieve that “aha moment” business users were dependent on the IT department to query databases using carefully crafted code. Once that answer was obtained, however, the next logical question that the business user would want to ask would require more careful crafting of code. It’s not too long before a few hundred business users with thousands of queries overwhelm the IT organization.

To give business users more control Wall says that Salesforce has been developing a metadata model around the information stored in its databases that makes the information in its namesake customer relationship management (CRM) application not only more accessible, but actually more malleable. As that capability continues to mature, Wall says the ability to identify what records in the database are related to what information becomes more automated. In addition, Wall says in time records in the databases will become more “social” in that as new information is collected, the database itself in real time will be able to provide additional insight and even actual recommendations. Most significantly, all of this can happen in an application centric way that is easily accessible to the end user, versus an approach that requires direct intervention from an IT department and a small army of developers.

In fact, it’s that accessibility that helped convinced Indicee to build a cloud-based analytics application for the Chatter social networking component of Salesforce.com. According to Indicee CEO Mark Cunningham, is designed to not only help organizations track opportunities and increase CRM adoption by making it apparent who in the organization is not only using the application, it also shows how proficient each particular Chatter user is with the application. All that can be easily accomplished with a minimal amount of professional services because of the way Salesforce makes data accessible to third-party applications, says Cunningham.

Salesforce is hardly the only application vendor working to make integration simpler by making broader use of metadata. But in comparison to other vendors, it’s a farther along if for no other reason than its customers tend to be business users trying to access corporate data residing in other applications with little to no support from an internal IT department. That doesn’t necessarily preclude the use of other middleware technologies to access that corporate data. But for the mostpart it generally means that in terms of data integration in the enterprise, the assumption should be that the Salesforce CRM system isn’t the highest application on the internal IT list of project priorities. The good news, says Wall, is that because a new era of data integration democratization is upon us, that may not matter as much as it once did.

Both comments and pings are currently closed.

5 Responses to “The Coming Democratization of Data Integration”

September 4th, 2012
at 8:51 am
Comment by: Chris

It is good news that apps providers themselves are facilitating data integration with their users. There are also third party services that provide API automation. Kin Lane has recently shared a list of 8 API automation platforms: http://apievangelist.com/2012/08/21/api-automation-platforms/

September 10th, 2012
at 8:35 am
Comment by: Nancy Beckman

” all of this can happen in an application centric way that is easily accessible to the end user, versus an approach that requires direct intervention from an IT department and a small army of developers.”

Agility is key to long term success. Being able to make changes/decisions in real-time makes your business that much more competitive. Cutting out the IT intervention time means your developers can focus on more pressing projects.

September 10th, 2012
at 8:45 am
Comment by: Link Roundup – September 9, 2012 | Enterprise Information Management in the 21st Century

[...] The Coming Democratization of Data Integration (ProgrammableWeb.com) – Good luck to them… [...]

September 10th, 2012
at 9:02 am
Comment by: Link Roundup – September 9, 2012 | Enterprise Information Management in the 21st Century

[...] The Coming Democratization of Data Integration (ProgrammableWeb.com) – Good luck to them… [...]

October 30th, 2012
at 12:01 am
Comment by: An API Renaissance Period in the Cloud

[...] more business users become increasingly comfortable with multiple cloud applications, it’s only a matter of time before APIs transform how innovative business processes proliferate across the ente…. Related ProgrammableWeb ResourcesLearn more Tarpipe API [...]

Follow the PW team on Twitter

ProgrammableWeb
APIs, mashups and code. Because the world's your programmable oyster.

John Musser
Founder, ProgrammableWeb

Adam DuVander
Executive Editor, ProgrammableWeb. Author, Map Scripting 101. Lover, APIs.