Direct Connection gives your applications an unrivaled advantage - connection to SQLite databases directly via TCP/IP avoiding SQLite Client Library.

Our ODBC driver fully supports standard ODBC API functions and data types and enables easy and secure access to live SQLite data from anywhere.ĭatabase applications based on our solution get an opportunity to establish a connection to SQLite by means of native SQLite client software and directly.

The workflow as introduced has not been successfully tested in Tableau Desktop for Mac OS X due to unsolved issues related to SQLite3 ODBC driver for Mac OS X.Devart ODBC Driver for SQLite is a high-performance connectivity solution with enterprise-level features for accessing SQLite databases from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows, macOS, and Linux. Non-commercial license can be requested from the Tableau Academic Program for self-learning, teaching and non-commercial research purposes. The tutorial is based on Tableau Desktop Professional Edition (ver 10.4.1, 64-bit) in Windows 10 with an instructor license. SQLite ODBC driver for Windows (please refer to Appendix 1) To use the Tableau dashboards as provided that read SQLite database, the following software need to be installed: sql suffix in EnergyPlus project folder to which Tableau will connect later.

The SQLite database file is the one with the. In order to generate the SQLite database file as one of the many output files from EnergyPlus simulation, the following line needs to be added to the IDF file: Output:SQLite, Simple

The SQLite database and IDF files for one example case as produced from its hourly, monthly and annual simulations, respectively. Please download the latest version of the following files used in this tutorial which are shared through link 1 or link 2 :Ī Tableau workbook file which contains the pre-customized dashboards to connect to and visualize SQLite database generated from EnergyPlus (It will be updated from time to time as new dashboards are included).

Sqlite driver for tableau on mac