A greater whole

Exporting data from one database to another can be a source of real problems for a growing business. Often, the task has to be performed manually which, aside from being time consuming, generates a lot of errors such as typos or multiple entries.

Data Integration

Data Integration

Enterprise-level organisations can use specialist data integration companies to merge, clean and monitor their databases following mergers and acquisitions. It’s an unglamorous niche of the software industry, but like plumbing, absolutely necessary.

Noticing that the demand for data integration was growing not just at an enterprise-level, US-based Informatica recently launched a software-as-a-service (SaaS) version of data integration aimed at smaller customers.

‘We’re not aware of anyone else delivering on-demand integration,’ says general manager of Informatica on Demand, Ron Papas.

On automatic

Currently the company’s SaaS offering allows data loading between online programs like Salesforce CRM and Google Docs, and includes a quality assessment tool enabling the removal of duplicated data (multiple entries of the same customer or invoice, for example).

It’s simple enough that you can run the whole operation from an Iphone, so sales staff can access customer information on the fly, or scrub databases on the way to work.