Ascert expands Relate to offer direct SQL and JDBC access

 Ascert expands Relate product family to offer direct SQL and JSBC access to Enscribe Databases 

SAUSALITO, Calif. (PRWEB) August 16, 2022
Ascert’s newest Relate addition, Relate EnSQL, extends the capabilities of the Relate family of data maintenance products for the NonStop server. Relate allows users to easily query, manage, and compare Enscribe file data. Relate EnSQL extends these capabilities to meet the needs of enterprise environments by providing powerful data management functionality and advanced reporting capabilities. The new product solves many of the limitations inherent in the Enscribe flat file database by using standard SQL syntax for data access without having to replicate the data or intercept any API calls. Included in Relate EnSQL are a local command line interface (CLI) for use directly on the HPE NonStop system and JDBC (Java Database Connectivity) support for both local and remote Java client programs.

The command line interface provides comprehensive SQL syntax for querying Enscribe data directly in its file-based form, without needing to export it to an external SQL database. SQL queries are applied directly to the underlying Enscribe data, saving time, effort, and cost. Such queries can be used to discover, analyze, and update file contents in place using standard SQL syntax statements without additional data manipulation.

Relate EnSQL's JDBC support allows Java programs to query and update the Enscribe data also using standard Java tools and SQL syntax. The JDBC support includes access directly from Java programs running under the HPE NonStop OSS personality using NonStop Java, or remotely using Java on other platforms (such as Windows or Linux machines). The standard JDBC interface and syntax is supported regardless of whether clients are running locally on the HPE NonStop or remotely.

Developed by Ascert over two decades ago to meet the needs of a major U.S. bank, Relate rapidly became the leading product for the management of these Enscribe databases, with its “SQL-like” syntax. This new product, Relate EnSQL, developed for another major bank but this time in mainland Europe, raises the bar yet again. “We are pleased to make available this major expansion to our Relate product line with the addition of Relate EnSQL," says Andrew Mould, Managing Partner at Ascert. “Developers and database administrators not versed in Enscribe can now easily access that data with standard SQL commands using our new command line interface, accessible directly from the NonStop Server’s TACL shell. Relate EnSQL also includes a JDBC layer that provides standardized data access for remote client programs, allowing the data to be readily used by sophisticated third-party data maintenance, reporting, and visualization tools.”

To find out more about Relate EnSQL visit the Ascert website or contact a local Ascert office.

About Ascert: 
Ascert is recognized as a leading provider of premier testing software solutions. Ascert was founded in 1992 to provide automated software testing solutions that help companies measure performance and reliability. With over 100 clients worldwide, Ascert's products and services are used at some of the world's most successful companies.

Off-the-shelf simulators for Ascert’s VersaTest product include solutions for EFT testing, POS testing, stress testing, ATM testing, Fraud testing, IFX testing, EMV/chip card testing, ISO8583 testing, ISO 20022 testing, Faster Payments testing, and 3270 & 6530 terminal testing. Ascert’s custom simulators have been used for testing air traffic control systems and biometric payment systems. Ascert delivers flexible solutions that are either customer site installed or accessed via Ascert’s Remote Testing Services. Ascert's products assist testing professionals across industry segments to better manage their testing processes and environments through an end-to-end toolset.

For inquiries in the America’s and Asia-Pacific: 
Rich Greene 
Ascert, LLC 
180 Harbor Drive Suite 225
Sausalito, CA 94965, USA 
Telephone: 1-415-339-8500 
Toll Free:1-877-ASCERT-IT 
E-mail: info(at)ascert.com 
http://www.ascert.com

For inquiries in Europe, the Middle East, and Africa: 
Martin Travers
Ascert Limited 
Telephone: +44 (20) 7488 3470 
E-mail: ukinfo(at)ascert.com 
http://www.ascert.com