SQLRelay connector (LibSQLRelay)

Features

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.