OpenVMS / RMS Dynamic API

The Stirling & Young Group's new OpenVMS RMS API is the first ever API designed to give your applications direct access to your RMS data files in real time. The SGCO API is to JSON-based RESTful API Installed on your VMS server which then listens to your RMS files and adapts dynamically to file structure changes without the need to re-map your data file.

Interact REALTIME with your RMS data Dynamically in Real Time. The Stirling API enables your application to: INSERT * READ * UPDATE * DELETE records in your RMS data file in real time. Functionality includes file and record locking and all data types including binary, as keys and members of compound keys.

Lightweight

The major design concern in architecting our API was to be lightweight and efficient. The competing solutions put an unnecessary load onto the host computer resulting in the need to upgrade hardware to compensate. This is turn leads to more issues and a cycle of constant hard to identify problems.

Our API uses only the processing power and memory needed to provide access to RMS. There are no unnecessary spoolers, tracking tables etc. needed to keep the API working as it relies only on the current state of the RMS data in 100% real time. Other commercial solutions either require a service that runs on OpenVMS and a service that runs remotely that must semi manually be kept in sync and are not truly real time or dynamic or they put an unnecessary load on the OpenVMS host to generate full web content.

Our API consists of only a very small application the runs detached on the OpenVMS OS. It accepts JSON input via posts to a listener that can be assigned to any port, processes that input, performs the requested tasks on the RMS files and returns and necessary response.

The Stirling API is ideal for user authentication and custom content filtering based on user ID or other user characteristics.
The Stirling API also plays well with others by interacting seamlessly with other APIs.

The Stirling API is the latest addition to a full suite of mission critical products which include: custom PDF Conversion system, document management system, and RFID asset Tracking systems. The Stirling API is now available for installation on your VMS system. For pricing, licensing, or other product information contact: The Stirling Young & Murch Group LLC, at info@sgco.com.




Dynamic:

By leveraging RMS indexing in conjunction with the DDL/Data Dictionary for the target data we are able to access the needed data even as the RMS structure is changed. The DDL/Data Dictionary is housed on the remote system and used to dynamically structure queries to RMS as well as the parse the RMS returned records.

Because it is dynamic, the Stirling API eliminates the multi-step process of creating copies of your data files, a requirement for other solutions. No duplicate of data or duplication of effort.

Secure:

Our API is by design as secure as possible. The API is not only limited to accept only properly structured JSON input but will only accept input stings that are structurally compatible with the target RMS file. This prevents the API from blindly accepting possibly dangerous input.

Security may also be further enhanced by front ending the API using a second network interface on the host OpenVMS box onto a dedicated LAN with two other entities: A PCI compliant - WAF enabled reverse proxy and a Cisco 5500 series firewall. The Cisco 5500 provides further traffic management as well as the ability to add Cisco Firebox IDS functionality.

It should be noted that this is addressing only the security of the API and that security for the remote applications that manipulate the RMS filesystem via the API are a separate and equally important issue.


Connect your RMS data files to any external file or report source including:
  • - Business Intelligence applications such as dashboards,
  • - Web services such as sales/vendor portals, customer portals,
  • - Mobil device application/portals,
  • - Spreadsheet report templates,
  • - Any Dynamic Reporting Service(s).

The Stirling API is ideal for user authentication and custom content filtering based on user ID or other user characteristics.
The Stirling API also plays well with others by interacting seamlessly with other APIs.

The Stirling API is the latest addition to a full suite of mission critical products which include custom PDF Conversion system, document management system, and RFID asset Tracking systems. The Stirling API is now available for installation on your VMS system. For pricing, licensing, or other product information contact: The Stirling Young & Murch Group LLC.

See PRODUCT INFORMATION HIGHLIGHTS

See FULL PROJECT WHITE PAPER HERE

NEWS and Updates

OpenVMS RMS RESTful API: It’s amazing what tuning can do when you have to. Tuning end to end we can query RMS and returnover the wire JSON for 1m records in 70 seconds and insert 10k records in 25 seconds. - May 06




SGCO OpenVMS RESTful API query (search) tuned to 150,000 records returned in 20 seconds, insert / update 10,000 records with local decision to insert or update )no DUP key, row lock when update) in 1 min - April 25




SGCO OpenVMS RESTful API new module perf tuned returns JSON array of search results 5k records per second! 100% native OpenVMS - 04/13




SGCO OpenVMS RESTful API update: Recent addiions to our API have included server and all modules distributed compiled, passing file and row locking parameters and multi-step insert/update. API runs 100% native on VAX Alpha and Itanium with no sling data to MSSql. – 04/03




SGCO OpenVMS RESTful API now distributed and run as a compiled Python extension. 300% performance increase – 02/28




SGCO OpenVMS RESTful API update: We just completed the ability to fully interact with binary field types for complete CRUD functionality including simple and compound binary indexes – 02/19