We’ve posted code samples and instructions for using the SNAP PAC REST API and T-SQL to import tag values from a controller into a SQL Server 2016 database.

The instructions also explain how you can get Microsoft’s free developer version of SQL Server 2016.

To run the code sample, you’ll need to enable SQL Server’s OLE Automation stored procedures. A script for doing this is also available on the website.

The code sample is available at http://developer.opto22.com/rest/pac/examples/use-openjson-to-insert-tag-values/