Ingres and Pentaho speed BI

Ingres has teamed up with BI company Pentaho to improve the processing speed of the company's software


Ingres has entered into an agreement with Pentaho in a move to push open source technology into organisations.

The two companies have certified that their products work with each other and are jointly marketing the solutions. This co-certification gives organisations the chance to process analytics much quicker by combining Ingres' VectorWise technology with Pentaho's BI software.

"It's not just about value for money," said Emma McGrattan Ingres's senior vice president of engineering, "that just doesn't cut it any more. With Pentaho we're going to work together to find opportunities to make money. The phrase we're using is business intelligence at the speed of thought."

The move with Pentaho follows the release last week of Ingres Database 10, the latest version of its flagship software and its strongest attack so far on alternative database suppliers. "The primary focus of Ingres 10 is helping people looking for an alternative strategy," said McGrattan.

The whole focus was in addressing weaknesses in the database where we couldn't meet what other suppliers were offering added McGrattan. "For example, we didn't have multi-version concurrency control (MVCC), which provides concurrent access to the database

Among other areas tackled were allowing the database to recognise non-standard SQL code that was being used by Ingres' competitors, better handling of batch queries and improved migration tools. "We wanted to help mass migration to Ingres – that's where things like the relationship with Pentaho come in. We provide tooling, an Ingres migration toolset, which is basically a wizard that you point at Oracle or MySQL, and then point it at Ingres and use something like Pentaho or Talend to complete the move," she said.

The process hasn't only been an Ingres initiative, McGrattan said. "We've introduced single column encryption that we got from an Ingres admin from Oxford University."

She said that the there was growing interest in migrating away from other vendors' databases, particularly MySQLusers. "We're seeing a demand for partner applications for MySQl – they're looking for an alternative supplier and we've got the open source set they're used to. They're certainly very suspicious of the Oracle road map."

McGrattan reiterated that promoting open source to organisations was not purely about emphasising cost savings. "That's not just a big enough motivator. We are seeing encouraging signs from governments in US and UK and we need to build on that but it's by doing more than just cut prices – I think there's been too much emphasis on cost savings and not enough on the other benefits of open source. If you compete with the likes of Oracle on price, there's plenty of deal they can do to lower the cost – we have to offer more than them."

"Recommended For You"

Ingres benefits from Oracle-related angst Pentaho Pumps Up the GPL's Power