SGCO Universal Legacy API v2.0

Real Time OpenVMS Native RMS / Oracle / Oracle RDB Dynamic API

This is a Demo for the RMS module

The Stirling & Young Group's OpenVMS RMS API is the first ever API designed to give your applications direct Real Time access to your RMS / RDB data files. The SGCO API is a JSON-based RESTFull API installed on your OpenVMS server. The API listens for incoming JSON requests and interacts with your RMS or RDB files in real-time.

This simple example is connected to our demo instance of OpenVMS RMS API. (This web page is hosted on Vercel web hosting connecting to our RX2660 box at a remote data center.) Feel free to insert a few records using the "Insert a Record" tab below. After you insert several records you may want to switch to "Query RMS file" tab to read your newly added records from the remote OpenVMS RMS file. Every time you switch to "Query RMS file" tab the contents of the remote RMS file will be read. This web page will always show current contents of the remote RMS data file. There is no need to wait for the data to be synchronized with another customer-facing database.

You can delete any record using the "Delete" button in the query results table. When you click this button two queries will be sent - one to delete the record and another one to refresh the results table. The entire remote RMS file can be cleared by clicking "Delete All Records" button from the last tab.

The bottom pane will populate with the actual requests sent and the responses received from the API. The API log is linked to your browser session and will show only the queries you make in the current session. If the log becomes too long you can clear it by clicking the "Clear Log" button. Clearing the log does not affect the data in the remote RMS file. You can also clear API log by reloading this page.

If you would like to interact with the API directly, please contact us, and we will provide an API endpoint you can use directly.

Please note: the demo app on this page will work properly in any current web browser (Microsoft Edge, Google Chrome, Mozilla Firefox or Opera). Internet Explorer is not supported.

A functioning demo of the API is available by contacting SGCO. We will need to only know the version of Python that is installed on your OpenVMS system. (Python 2.7 for HP OSs and any Alpha systems and 3.8 for VSI Itanium OS. The demo is delivered as an OpenVMS ZIP achive. It can be unzipped in any directory on OpenVMS. Once started either interactivly or detached the configurator GUI will be available to your web browser. It is delivered with a fully mapped/indexed/functional RMS data file to server as an example that is immediatly available from your system to any remote API calls.