ARDI SQL Addon

The ARDI SQL addon provides a simple and more familiar way for people to access tables of ARDI data.

It's designed for people who want to get quick and easy access to ARDI data and are already familiar with SQL, and who don't need the extra capabilities of AQL.

When enabled, the SQL addin provides two web endpoints…

http:<servername>/sql/show is an interactive page where you can write SQL queries, and http:<servername>/sql/api/query is the endpoint you can call directly from applications that need data (Excel, for example).

SQL Support

At the present time, the SQL addin only provides the bare minimum of features. It only supports the SELECT function, and only for very simple queries - it doesn't support any functions, expressions or even filters as yet (other than time).

Supported Functions