06:28 PM

Taking The Pain Out Of Data Integration

Data integration is a big headache for smaller businesses. Can Jitterbit's "no coding" software solution offer a remedy?

Data integration is a big headache for smaller businesses. Can Jitterbit's "no coding" software solution offer a remedy?Multi-source data integration was once an issue that concerned only large enterprises. Yet as more smaller firms employ various applications to store, manage, deliver, and analyze business data, they face many of the same integration challenges.

Smaller firms, however, often lack the in-house IT resources to tackle data-integration projects. That leaves them with an unpleasant choice: Hire outside developers capable of doing the job, or avoid complex data-integration tasks completely.

The first option is expensive, and the second can place a company at a significant competitive disadvantage.

Over the past few years, a number of software vendors have introduced a third option: Data-integration tools designed for business users with limited IT expertise.

Jitterbit recently launched version 3.0 of its commercial open-source data integration software. It is designed to allow non-programmers to integrate data from a variety of data sources, including enterprise applications, databases, content management systems, Web 2.0 applications, and software-as-a-service apps. Jitterbit's client-side interface, for example, supplies graphical, drag-and-drop data mapping and transformation components that allow a user to build their own data-integration tools.

A key selling point for Jitterbit is its use of "Jitterpaks": Modular, reuseable packages that abstract the process of integrating and working with particular sets of data sources. Companies may distribute Jitterpaks internally, allowing them to handle similar data-integration tasks in the future still more easily. Jitterbit also offers its own collection of Jitterpaks that cover a variety of common applications and integration scenarios.

With Jitterbit 3.0, the company is introducing a number of new features designed mostly for large enterprise users, including streamlined support for multi-user, multi-project environments. In a recent interview, however, Jitterbit CTO Ilan Sehayek said that as midsize companies learn how to work with his company's product, they often deploy it far more widely, and use it for more complex projects, than they initially planned.

As a commercial open-source vendor, Jitterbit distributes both a free "community" version of its software and a paid "enterprise" version that includes support and service.

Can Jitterbit offer a silver-bullet solution for every data integration project? Probably not, since problems as simple as a character-mapping disparity or a bit of sloppy SQL can monkey-wrench a project and require on-site, expert assistance to fix.

As a solution, however, for reducing the marginal cost and complexity of a data-integration project, Jitterbit is a very interesting product. The company claims that its "no coding" approach can cut the delivery time of a project by up to 80 percent. That's a compelling promise, since it also reduces the need to hire expert data-integration consultants -- or to tie up in-house IT staff better employed elsewhere.

Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
InformationWeek Elite 100
InformationWeek Elite 100
Our data shows these innovators using digital technology in two key areas: providing better products and cutting costs. Almost half of them expect to introduce a new IT-led product this year, and 46% are using technology to make business processes more efficient.
Register for InformationWeek Newsletters
White Papers
Current Issue
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of July 24, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.