SQLite is a relational database system which stores data directly in local disk files. Many applications, including Exago, use SQLite in order to store local data. For example, the Exago Monitoring service collects monitoring data in SQLite files.
You can add SQLite data files as Exago data sources. Exago uses Open Database Connectivity (ODBC) as a translation layer in order to read the files. Before adding a SQLite data source, you need to install a SQLite ODBC driver on the Exago host computer.
There are several options for drivers, but the recommended one is a free and open source package by Christian Werner and other authors.
To install the SQLite ODBC Driver:
sqliteodbc.exe
from Christian Werner's website.
sqliteodbc_w64.exe
.Once the SQLite ODBC Driver is installed, SQLite files can be added as ODBC data sources. Most operating systems include a graphical user interface to manage ODBC data sources. In Windows, this is called ODBC Data Source Administrator.
To add a SQLite file as an ODBC database:
odbcad32
.ODBC data sources are added to Exago in the same manner as other data sources. You can specify an optional Column Delimiter for an ODBC data source.
Either use the Administration Console or edit the Configuration File to add an ODBC data source to Exago:
http://.../{Exago}/Admin.aspx
DRIVER=driver;Database=path;[LongNames=0|1];[Timeout=timeout];[NoTXN=0|1];[SyncPragma=NORMAL|OFF|FULL];[StepAPI=0|1];
where:DRIVER=driver
specifies the type of SQLite ODBC Driver.Database=path
specifies the file path to the SQLite file.
DRIVER=SQLite3 ODBC Driver;Database=C:\Exago\databases\Northwind.sqlite;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;
<datasource></datasource>
element in the <webreports>
parent element.<datasource>
element add the following fields:
<id>id</id>
where id is a unique integer identifier for the data source<name>name</name>
where name is a name for the data source<dbtype>odbc</dbtype>
<dataconnstring>connectionstring</dataconnstring>
where connectionstring is a formatted connection string (See "Administration Console" Step 3.4, above)<schema>schema</schema>
where schema is a Schema/Owner Name<odbcdelim>delim</odbcdelim>
where delim is a Column Delimiter(s)<webreports>
...
<datasource>
<id>1</id>
<name>Northwind</name>
<dbtype>odbc</dbtype>
<dataconnstr>DRIVER=SQLite3 ODBC Driver;Database=C:\Exago\databases\Northwind.sqlite;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;</dataconnstr>
</datasource>
...
</webreports>
After you add the data source, you must add the data objects and joins. See Data Objects and Joins.
Note. The Automatic Database Discovery tool is not compatible with ODBC.