Postgres Plus® Advanced Server Oracle Features
Reduce Your Oracle License Fees!
With Postgres Plus Advanced Server's Oracle compatibility features, you can use existing Oracle-based applications on the PostgreSQL platform, or run adjacent applications that dove-tail seamlessly with your mission critical databases without additional Oracle licenses. You can use these same compatibility features to build new Postgres applications, saving money without re-training and re-coding issues.
Advanced Server's compatibility features focus on five common feature areas:
- SQL Extensions. Advanced Server supplies many critical SQL extensions you rely on, including decode(), the DUAL table, ROWNUM, Object Types and sub-types.
- PL/SQL Support. Advanced Server's procedural language runs Oracle triggers, stored procedures, function packages (like 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.
- Compatibility Tools and Utilities. Advanced Server's Oracle-compatible tools include: EDB*Plus, EDB*Loader, EDB*Wrap, DBLinks, and Oracle Catalog Views, providing experienced DBAs and developers the familiar look, feel, and functionality on which they depend.
- Application Compatibility. The programming framework includes support for 12+ programming languages and 12+ library interfaces including OCL(OCI support).
- Push Button Migration. Finally, the Advanced Server Migration Toolkit provides an easy, low-risk Oracle application migration path that converts schema, data, packages, triggers, stored procedures, and functions into a working Postgres based application.
What should I do now?
Use the following links to learn more about: