SQLite

The SQLite adapter imports device information from an SQLite database.

Types of Assets Fetched

This adapter fetches the following types of assets:

• Devices

Parameters

1. SQL Server Table Name (required) - The table name of the required SQL table.
2. Server Tag (optional) - Add a desired tag to the server to be queryable.
3. File name (required) - A unique name for the adapter connection. The value supplied here will be populated in the File name field for the data supplied by a specific adapter connection.
   Note:

   The specified File Name does not need to be the actual imported file name. This field is an identifier for use in the Query Wizard.

4. Upload file (optional) - Select a local SQL file to import
   Note:

   • When using this option, the data imported from the SQL table will never be fetched again, as the file is static.

To learn more about common adapter connection parameters and buttons, see Adding a New Adapter Connection.

Advanced Settings

• SQL pagination (required, default: 1000) - Set the number of results per page received for a given SQL query, to gain better control of the performance of all connections for this adapter.