Home > Deploy > Add-on Modules > WsSQL

WsSQL

WsSQL is a service that provides an SQL interface into HPCC Systems. The web service accepts a subset of prepared and standard SQL queries. It provides access to most HPCC data and published queries.

The WsSQL service maps HPCC Systems logical files to RDBMS tables and HPCC Systems published queries are exposed as RDBMS stored procedures. The WsSQL service also provides convenient methods to obtain system information, metadata, and results from previously executed queries.

This service is intended to be used in a programmatic fashion (for example, via database drivers), but can also be used in an interactive fashion by users who are more comfortable using SQL than ECL. This makes it possible to submit ad-hoc queries without learning ECL.

Features:

  • Submit SQL queries directly to HPCC Systems via SOAP
  • Access HPCC Systems data files and Published queries
  • Analyze HPCC Systems data using familiar SQL syntax
  • Supports SQL SELECT or CALL syntax
    • Access HPCC Systems data files as DB Tables
    • Access published queries as DB Stored Procedures
  • Supports SQL Create and Load Syntax
  • Harnesses the full power of HPCC Systems under the covers
    • Submitted SQL request generates ECL code which is submitted, compiled, and executed on your target cluster
    • Automatic Index fetching capabilities for quicker data fetches
  • Creates entry-point for programmatic data access
  • Leverage HPCC Systems data without need to learn and write ECL!
    • Opens the door for non ECL programmers to access HPCC Systems data.

Installation and Documentation

Previously, WsSQL was installed using a separate download package. From HPCC Systems 7.0.0. Beta onwards, WsSQL functionality has been fully integrated into the HPCC Systems platform package. We recommend that existing WsSQL users preparing to upgrade from an earlier version of our platform (such as version 6.x.x), uninstall the old WsSQL package before upgrading to avoid potential compatibility issues.

View Older Versions