Oracle REST Data Services (formerly known as Oracle APEX Listener) provides several key capabilities for the Oracle Database. REST Data Services accepts RESTful Web Service call URIs and directs them to the appropriate SQL statement or PL/SQL block. REST Data Services marshals data returned from SQL statements into JSON or .csv format and also redirects calls to Application Express applications to the Application Express run-time engine.
Oracle REST Data Services is a J2EE-based alternative for Oracle HTTP Server (OHS) and mod_plsql. The J2EE implementation offers increased functionality including a web based configuration, enhanced security, and file caching. REST Data Services also provides flexibility by supporting deployments using Oracle Web Logic Server (WLS), Oracle Glassfish Server and Apache Tomcat.
The standard Oracle REST Data Services configuration is applicable for the majority of installations for local systems or multi-tenant private clouds where there is no requirement to handle requests from outside a firewall. Oracle REST Data Services is installed onto a J2EE compliant Web Server and the users are provided the appropriate link directly to that service.
For public systems or hosted environments it is important that the Oracle REST Data Services is installed inside of the firewall, and the HTTP listener is installed outside of the firewall. The requests are sent to the external Web server and passed through the firewall to the REST Data Services.
Connection The Database Connection allows you to enter the database credentials and provides JDBC options.
Security The Security features provide protection by validating the procedure requests and determining if the user is allowed to access the procedure.
Caching The REST Data Services allows you to cache file-based content for quick access.
Pre-Post Processing The Pre and Post Procedures allows you to specify the database procedures to invoke before or after executing the procedure specified on the URL.
Reports The Reports information provides statistics, error tracking and logging information.
Database Settings The Database Settings allows you to specify multiple database connections. Use the URL mapping to define the rules for how requests are routed to the appropriate database.
Why use REST Data Services
Allows easy integration with Java-based middleware
Can be used for Application Express or any Oracle web-toolkit application
Ease of configuration
When combined with Glassfish, just unzip and you are good to go