The drivers (JSON/XML and SQL) are all included in the base product. JSON/XML is only for querying an HTTP(s) server, which responds with a string in either JSON or XML format. The SQL driver allows you to capture data from an ODBC-compliant database.
The REST Interface is for creating queries against the VTScada databases. VTScada also includes an ODBC Driver for windows machines and an Excel Plugin, which allows users to interface with the VTScada API using various methods.
I believe there is also a method to pass data from VTScada in a report by exception method, I'm not familiar with the best method to accomplish this.
While the info above lacks detail, you can read more about each in the help files:
SQL Driver - https://www.vtscada.com/help/Content/D_Tags/D_SQLDataQueryDriver.htm
JSON/XML Driver - https://www.vtscada.com/help/Content/D_Tags/Dev_JSONDriver.htm
REST Queries: https://www.vtscada.com/help/Content/D_LogAndReport/D_RESTQueries.htm
The drivers (JSON/XML and SQL) are all included in the base product. JSON/XML is only for querying an HTTP(s) server, which responds with a string in either JSON or XML format. The SQL driver allows you to capture data from an ODBC-compliant database.
The REST Interface is for creating queries against the VTScada databases. VTScada also includes an ODBC Driver for windows machines and an Excel Plugin, which allows users to interface with the VTScada API using various methods.
I believe there is also a method to pass data from VTScada in a report by exception method, I'm not familiar with the best method to accomplish this.
While the info above lacks detail, you can read more about each in the help files:
SQL Driver - https://www.vtscada.com/help/Content/D_Tags/D_SQLDataQueryDriver.htm
JSON/XML Driver - https://www.vtscada.com/help/Content/D_Tags/Dev_JSONDriver.htm
REST Queries: https://www.vtscada.com/help/Content/D_LogAndReport/D_RESTQueries.htm
Trihedral Engineering Ltd.