New mashups add muscle to your business tasks and applications

A strong argument could be made that any new type of software can’t make it to the enterprise without a link to Excel, the lifeblood of many businesses.

Makers of mashuptools are making their move this week to expand their potential customer base by unveiling such links and other features at the Google Maps into a common process.

Now, mashup vendors say, the updated tools can be used as a quick and easy way to integrate data from disparate systems for use in a wide variety of processes like monitoring competitor pricing and automating manual processes that include Web services or content.

Kapow Technologies, for example, Tuesday plans to unveil an on-demand enterprise mashup service that allows companies to incorporate data from various Web sites and services directly into Excel spreadsheets .

The new Kapow OnDemand hosted service is based on the Kapow Mashup Server, which is deployed at more than 300 companies, including Audi, Morgan Stanley and Simply Hired.

The new product adds an Excel Connector that can be used to point to a wide variety of data sources on the Web for automatic insertion into an Excel spreadsheet.

For example, a company could use the application to monitor competitor’s product pricing schedules or to add user reviews of their own products to adjust sales efforts, noted Joe Keller, Kapow’s chief marketing officer.

The service could help eliminate the manual efforts most companies now use to scour the Web for such information, Keller said. Once the data has been populated into spreadsheets, it can be analyzed with installed products like business intelligence tools and visualization technology, he added.

“By connecting [Web mashups] to Excel users can have real-time data inside their spreadsheets along with their corporate data to get that 360-degree view of the data they are analyzing,” Keller said.

Kapow OnDemand also includes a robot designer to construct custom Web harvesting feeds and services in a role-based execution runtime, along with tools for monitoring and managing services and feeds to provide site administrators with control and insight into their environment, the company said.

“If users can build spreadsheets, if they can do the programming of those spreadsheets, the plug-in makes [mashups] a native element inside of Excel,” Keller added. “Mashups provide that layer we need to really let the business do a lot of the work themselves. It still governs the services and creates the services, but it allows the business start doing business themselves.”

JackBe, which first launched its Presto enterprise mashup server a year ago this month, will unveil Presto 2.0 at the Web 2.0 show this week. Presto 2.0 aims to allow users to make mashups portable and includes a connector to Excel.

Presto 2.0, for example, allows users to create what JackBe calls “Mashlets” by syndicating existing mashups into widgets – small pieces of code that can contain information from the Web or from enterprise ERP or other systems. The Mashlets are then available to users in their portals, on their iPhones or in an Internet start page.

“Users want to be able to get at smaller pieces of information quickly,” said Joe Crupi, JackBe CTO. “They want to be able to point and click and get this data and to be able to customize it, tag it and send it to others.”

In addition, like Kapow’s new connector, Presto 2.0 allows users to consume any mashup directly into Excel. The new Presto Excel plug-in is connected to the spreadsheet so whenever data is changed, the Presto server updates the data.

“This is the whole difference between the consumer side of mashups and the enterprise side — strong adherence to security and governance,” Crupi noted. “You still get that same foundation of security and governance. No matter what services or systems are accessed, the proper auditing or authorization polices are in place.”

The enterprise mashup business will grow from $61 million in 2008 to $165 million in 2010 and $682 million in 2013, according to new research due to be released by Forrester Research Inc. on Monday. According to that report, the overall enterprise Web 2.0 market will grow from $764 million in 2008 to $4.6 billion in 2013. Forrester defines the enterprise 2.0 market as social networks, RSS, blogs, wikis, mashups, podcasts and widgets.

For many companies, mashups represent an easy way to eliminate “swivel chair” applications, where employees take data from one or more computer screens and then swing their chair around to another screen where they manually re-enter that data.

Cleveland-based Corporate Screening Inc., a preemployment screening and background investigation firm, is turning to enterprise mashups to eliminate the need for workers to manually extract data from multiple public Web sites and subscription-based Web services for background screenings of potential employees.

The company expects to be using enterprise mashup software from Denodo Technologies Inc. by June to extract Web content and mash it into its SQL database, noted Tom Drellishak, the company’s CTO.

“Denodo allows us to add more resources,” to get data from more Web content sites for aggregation, Drellishak added. Today, he said data feeds are not aggregated in real time “and a lot of times it is a bulk upload so you get more data than you need or there is a massive delay. We basically replacing humans with a computer.”

Bob Gourley was CTO of the Defense Intelligence Agency (DIA), the Defense Department’s lead intelligence agency until he left six months ago to join consulting firm Crucial Point LLC. The DIA gave Gourley permission to speak to Computerworld about? Mashup Exchange ? online marketplace to allow users to find, buy and sell prepackaged mashups and Web services.

Serena will provide a public exchange to provide users of its Mashup Composer mashup server or subscription service with access to 100 mashups for things like easing the process of bringing new employees on board, noted Jeremy Burton, CEO of Serena. That mashup could encompass various steps that span different systems, he noted. For example an on-boarding mashup could monitor the status of offer letters sent to potential new employees all the way though alerting the IT department that a new employee has been hired and will need laptop.

“Today all of this stuff happens in email,” Burton noted. “It is untraceable and untrackable. It is a nightmare.”

Or, companies can create a private mashup online marketplace where, for example, an IT department could publish mashups to business users. Companies also can create online communities where they can collaborate around mashups, Burton added.


Share on LinkedIn Share with Google+