As an oil & gas client, we collect millions of data points from field/plant automation points through Cygnet and store data in the Canary data historian - a NoSQL timeseries database. Canary suggests using the ODBC driver to connect to Spotfire, but this does not allow for you to browse table structures so intimate knowledge of database is required to build analyses.