• ABOUT
    • Clients
    • Partners
  • PRODUCTS
    • VersaTest >
      • VersaTest Add-ons
      • Versatest Editions Comparison
    • Relate
  • SOLUTIONS
    • EFT Testing
    • Stress Testing
    • EMV Testing
    • ATM Testing
    • Green-Screen Testing
    • ISO 20022 Testing
    • Faster Payments
    • INTERAC Testing
    • Continuous Integration Testing
    • Enscribe
  • CLOUD
  • SERVICES
    • Ascertified Hosted Testing Services >
      • FPS Hosted Accreditation
    • Training >
      • Introduction to VersaTest Automator
      • VersaTest Automator Test Case
      • DFS Driver Development
  • SUPPORT
  • CONTACT
Ascert Automated End-to-End Testing and Certification
  • ABOUT
    • Clients
    • Partners
  • PRODUCTS
    • VersaTest >
      • VersaTest Add-ons
      • Versatest Editions Comparison
    • Relate
  • SOLUTIONS
    • EFT Testing
    • Stress Testing
    • EMV Testing
    • ATM Testing
    • Green-Screen Testing
    • ISO 20022 Testing
    • Faster Payments
    • INTERAC Testing
    • Continuous Integration Testing
    • Enscribe
  • CLOUD
  • SERVICES
    • Ascertified Hosted Testing Services >
      • FPS Hosted Accreditation
    • Training >
      • Introduction to VersaTest Automator
      • VersaTest Automator Test Case
      • DFS Driver Development
  • SUPPORT
  • CONTACT

Ascert expands Relate to offer direct SQL and JDBC access

8/26/2022

 
 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

    Ascert News

    Testing Industry News, Updates & Commentary

    Archives

    August 2022
    March 2022
    December 2021
    July 2021
    January 2021
    January 2020
    October 2019
    May 2019
    January 2019
    December 2018
    March 2018
    December 2017
    November 2017
    October 2017
    September 2017
    July 2017
    May 2017
    March 2017
    February 2017
    December 2016
    November 2016

    Categories

    All
    API Testing
    ATM
    Cloud
    Company News
    GREEN SCREEN TESTING
    HPE NonStop
    Mobile ECommerce Testing
    VersaTest
    VTERM

    RSS Feed

Picture
© COPYRIGHT ASCERT, LLC 2022. ALL RIGHTS RESERVED.
Sales Contacts
US Toll Free:
1-877-ASCERT-IT
EMEA: +44 (20) 7488 3470
RoW: 
+1 415 339 8500 
sales@ascert.com
HOME
​
Resources
News
Events
​Partner Program

Jobs 
Privacy & Legal
​
    Stay Connected
Connect with Ascert
  • ABOUT
    • Clients
    • Partners
  • PRODUCTS
    • VersaTest >
      • VersaTest Add-ons
      • Versatest Editions Comparison
    • Relate
  • SOLUTIONS
    • EFT Testing
    • Stress Testing
    • EMV Testing
    • ATM Testing
    • Green-Screen Testing
    • ISO 20022 Testing
    • Faster Payments
    • INTERAC Testing
    • Continuous Integration Testing
    • Enscribe
  • CLOUD
  • SERVICES
    • Ascertified Hosted Testing Services >
      • FPS Hosted Accreditation
    • Training >
      • Introduction to VersaTest Automator
      • VersaTest Automator Test Case
      • DFS Driver Development
  • SUPPORT
  • CONTACT