Last update: November 17 2023
About APEX Message Service
APEX Message Service makes working with real-time data like chats, auctions, and dashboards in Oracle APEX or PL/SQL much easier.
You can efficiently utilize real-time data communication to create a chat application, auction application, dashboard, etc., in APEX, where the users don't have to refresh to see the latest updates.
APEX Message Service (AMS) is a product of APEX R&D / United Codes in Leuven, Belgium. We are an experienced partner that helps you facilitate, improve, and accelerate your business through new and innovative solutions. Built on in-depth technical expertise, our company provides custom-made IT services for managing business data and processes.
AMS Main Features
APEX Message Service focuses on the following:
Quick and Easy Setup Import the APEX Plug-in in your application.
Support for different data inputs Use JSON, SQL, or PL/SQL as data inputs.
Scalable and Secure APEX Message Service is a scalable and secure product that allows for real-time data.
PL/SQL API support Lets you send messages to the AMS server directly from your PL/SQL code.
Optimized for Performance Great design with the finest details to enhance your business productivity.
It's the database (APEX Plug-in, PL/SQL API, REST Webservice) that is making a request to the AMS Server (either on-premises or on our cloud). The data is sent in JSON format to the AMS Server. The browser needs to have access to the AMS server.
How it works (technical)
The APEX Message Service package includes a server component, an Oracle APEX plug-in, and the PL/SQL API.
The server makes rooms that clients can join and send messages to (emits). The client can emit data to the server to send them to the correct rooms. These requests can be sent directly via the socket or HTTP POST Requests. The server requires a structured JSON file that, for example, can be inferred from a SQL database.
The APEX plug-in will generate the HTTP POST requests for the server. The plug-in makes sending messages to all users or specific rooms easy.
The PL/SQL API allows to print directly from the Oracle database. The PL/SQL API is perfect if you need to connect to the server without using the APEX plug-in.
A sample application comes with the download, so you see plenty of use cases in action.
Cloud vs On-Premises
There are two types of versions available:
- a cloud version, which will send the requests to APEX Message Service in the cloud.
- an on-premises version, including the APEX Message Service server component. It's an executable you run on your server. In the APEX Plug-in, you reference your own local version of APEX Message Service. In this case, nothing is sent to the AMS cloud.
APEX Message Service is commercial software; you must obtain a valid license to use this software and its plug-ins in your application. For the on-premises version, a license is required per server (MID i.e., machine ID) on which you are running APEX Message Service.
Please visit our website https://www.united-codes.com/products/apexmessageservice/ for the different packages. You can even sign up for a FREE Cloud account.
All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosures protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.