A savings sweet spot
For over 9 years, EnterpriseDB has built a solid practice around reducing, capping or eliminating high Oracle costs with EDB™ Postgres Advanced Server's database compatibility, and simultaneously preserving your investment in Oracle volume licensing, infrastructure, skills and practices. We have helped customers just like you save money for their applications built around PL/SQL, OCI, and Pro*C. In spite of attractive licensing deals during a company’s database growth phase, many organizations regret the loss of control to manage costs that inevitably occurs a few years later. EDB™ Postgres Advanced Server with database compatibility for Oracle gives you cost savings options.
Read our white paper: Optimizing Open Source for Greater Database Savings and Control
If you can't replace Oracle, you can control costs
For many customer applications Oracle simply cannot be replaced for various reasons including volume licensing, migration risk, and COTS applications certified to work with Oracle. However, you can still gain control over ever increasing expenses with various cost containment strategies.
One method is moving existing and easy to migrate applications off their authorized volume licenses to Postgres Advanced Server at a much lower cost. Then recycle the volume licenses to account for growth or hardware upgrades in your difficult to migrate or unqualified to migrate applications. A smart re-balancing of your database mix can result in you paying less in total fees with Postgres Advanced Server than your current proprietary maintenance fees alone.
When it comes to choosing which applications to migrate, you have many options. A sample of strategies used by our customers includes:
- build new OLTP and operational applications
- use Advanced Server based on criteria specific to your needs (SLAs, database size, concurrent users, etc.)
- service archival or read-only applications that don't justify expensive licenses
- build non-mission critical applications
- assign Advanced Server to particular business units or departments
- use it to offload reporting tasks from a master database as an inexpensive replication server
Database compatibility explained
Advanced Server's database compatibility focus's on five critical areas of technology. A schema migration toolkit converts Oracle objects (data types, tables, partitions, database links, users, roles, triggers, stored procedures) to Advanced Server.
The second focus is on procedure processing; in additional to processing native PostgreSQL's PL/pgSQL, it also has a native parser for Oracle's PL/SQL. This includes Oracle syntax, function packages (e.g. DBMS_UTL, DBMS_RLS, and DBMS_PROFILER), user defined exceptions, named parameter notation, private synonyms, partitioning syntax, GOTO, Bulk Collect/Fetch/Bind, VARRAY, table() expressions, and more.
The next focus is on Oracle SQL extensions that are popular with users such as: decode(), the DUAL table, ROWNUM, Object Types and sub-types.
Application compatibility is the next focus with support for OCI and Pro*C as well as multiple library interfaces.
Finally, Advanced Server comes with tools critical to Oracle users with similar look and feel to minimize re-training. Examples of these tools include: EDB*Plus, EDB*Loader, EDB*Wrap and a stats pack like toolset for DBAs.
View a video explaining how Advanced Server provides database compatibility for Oracle.
We make managing change easy
EDB understands that a technology change in your databases is far from trivial. That’s why we provide a comprehensive set of strategies, features, tools, and services to make a change as smooth as possible. EDB’s database compatibility addresses the software for schema, data, and code compatibility, as well as the people who use it by providing the same objects, syntax, extensions and tools they use today for an environment that feels very familiar. You can even replicate data bi-directionally from Postgres Advanced Server making it extremely easy to integrate our low cost platform into your existing environment.
Customer conversions of their easy to migrate applications take only days or a few weeks. EDB services like the Migration Assessment for Oracle quickly identify high-payback applications to help you realize savings sooner.
Learn more about a Migration Assessment
Additional database compatibility resources