SQL Relay Client API

An open-source database connection management solution.

SQL Relay Client resides between your application and the database providing additional functionality like database connection pooling, proxyfying, throttling, high availability, query filtering, query translation, and connection scheduling. The current release of the SQL Relay Client API for OpenVMS is based on the SQL Relay 1.9.3 open-source distribution.

Of particular interest from an OpenVMS perspective are the proxyfying capabilities of SQL Relay which can be used to facilitate access to databases from unsupported platforms. Databases that can be accessed via SQL Relay using the client API include Oracle, Sybase, Microsoft SQL Server, IBM DB2, MySQL, MariaDB, PostgreSQL, Firebird, and SQLite, as well as ODBC data sources.

This OpenVMS port of the SQL Relay client API includes all functionality provided by the open-source release, including SSL/TLS support (based on OpenSSL 3.0-x). Also included is a wrapper API that makes it easier to use the SQL Client with OpenVMS programming languages other than C/C++, such as COBOL, Fortran, Pascal, and BASIC. Additionally, the kit provides several SQL Relay command-line tools, including sqlrsh (an interactive tool similar to Oracle SQL*Plus), sqlr-export, and sqlr-import which can be used to export and import data from XML files on a per-table basis.

Software Requirements

VSI OpenVMS V8.4-1H1 or higher (Integrity); V8.4-2L1 or higher (Alpha); V9.2-1 or higher (x86)
VSI TCP/IP, HPE TCP/IP Services for OpenVMS, or MultiNet TCP/IP
C or other language compiler (depending upon which language or languages you intend to use to develop applications using the SQL Relay client API)
VSI SSL 3.0-5 or higher (Alpha, Integrity), VSI SSL 3.0-8 or higher (x86). Note that if you wish to statically link application code requiring with the supplied object libraries and require SSL/TLS support, it will be necessary to link with a comparable OpenSSL distribution.