Datasets and SQL
The Dataset Module included in FactoryStudio provides an easy-to-use interface to exchange data in real-time with external Databases, XML, CSV or text files and access SQL queries and tables.
For the most common databases and data sources (Microsoft SQL Server, Oracle, CSV files, Microsoft Access, PI, Firebird, Informix, Excel), FactoryStudio supplies pre-defined configurations that reduce the configuration to a mouse-click. Any database that supports ODBC, ADO.NET or OLE-DB can be accessed. A built-in SQL Database engine is also supplied as a local database for your application(s).
The data collected with the datasets can be dynamically mapped to real-time points/tags and can be used in scripts or reports, or presented on displays using a powerful Data Grid Visual Object, with cell-editors and support for multiple visualization themes.
