Ascert Expands Relate to Offer Direct SQL and JDBC Access
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.
Recommended AI News: 1 in 3 Employees Do Not Understand the Importance of Cybersecurity at Work
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.”
Recommended AI News: Data Sprawl Creating Risk for Organizations Worldwide as Personal App Use in Business Continues to Rise
[To share your insights with us, please write to sghosh@martechseries.com]
Comments are closed.