EnterpriseDB Bidding For Customers With Oracle Compatibility - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Government // Enterprise Architecture
07:00 PM
Connect Directly

EnterpriseDB Bidding For Customers With Oracle Compatibility

Postgres Plus Advanced Server's latest retooling could make it easier for existing Oracle users to migrate a reporting or transaction application.

At a time of slowing commercial database sales, EnterpriseDB this week announced it is adding features to its Postgres Plus Advanced Server and turning up the volume on its compatibility with Oracle's popular database system.

EnterpriseDB is the commercial firm formed to capitalize on PostgreSQL, an open source relational database project. It's maintained a lower profile than the highly successful MySQL, but PostgreSQL is distinguished by its high degree of ANSI standard SQL compliance and enterprise system features. EnterpriseDB has added Oracle compatibility, such as an ability to field PL/SQL queries, on top of the standard relational system and sells it as Postgres Plus Advanced Server.

Now it's going further on the Oracle compatibility front with Advanced Server 8.3, Release 2. "We're focused on broadening our offering to a wider swath of companies," said Ed Boyajian, CEO of the Westford, Mass., company, in an interview.

Part of that effort is making it easier for existing Oracle users to migrate a reporting or transaction application from Oracle to Postgres Plus.

"The LA Times moved an Oracle reporting application to Postgres. We've widened the on-ramp," said Boyajian.

The way it's doing so is to building into Postgres Plus an ability to duplicate the way Oracle handles transaction success or recovery from a transaction failure. Each database system handles the process a little differently, and Oracle-based applications understand how Oracle does it.

"We actually mimic the behavior of Oracle in how it handles transaction success or failure," said Jim Mlodgenski, Advanced Server's chief architect.

Postgres Plus Advanced Server's PL/SQL support already means it can run Oracle database triggers and stored procedures. In 8.3 Release 2, additional SQL extensions, such as DUAL Table, supported by Oracle are now supported by Advanced Server. DBLinks and Oracle Catalog Views are also supported by Advanced Server.

Boyajian said 300 customers had downloaded and tested the release prior to its becoming generally available June 16.

The release also includes additional built-in packages to make execute certain Oracle-compatible functions connected with database operations, including the ability to schedule a job, print out a screen or send displayed results as e-mail.

"We've added the top used 10% to 20%" of such functions; they number over 100 in Oracle, said Mlodgenski.

In previous releases, Postgres Plus included push-button migration, where a database administrator, after designating the target Oracle application, could convert schema, data packages, triggers, stored procedures, and functions into a Postgres application.

Postgres Plus Advanced Server is the high end of EnterpriseDB's commercial product line. A license is priced at $4,495 per socket on a four-way server, with a total price of $17,980.

InformationWeek has published an in-depth report on application development. Download the report here (registration required).

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

11 Things IT Professionals Wish They Knew Earlier in Their Careers
Lisa Morgan, Freelance Writer,  4/6/2021
Time to Shift Your Job Search Out of Neutral
Jessica Davis, Senior Editor, Enterprise Apps,  3/31/2021
Does Identity Hinder Hybrid-Cloud and Multi-Cloud Adoption?
Joao-Pierre S. Ruth, Senior Writer,  4/1/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Successful Strategies for Digital Transformation
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll