Extracting data from a SQLite database

Provide the proper connection parameters for the SQLite database file on a DB component.

You can use SQLite-supported SQL commands in the preprocessing or postprocessing SQL properties of components connected to databases.

Use the Content Explorer from the Tools menu to manipulate or browse objects of the SQLite database connected to components in your project. Also, you can use client applications available from sqlite.org to connect to SQLite database files.

NoteTo use external client applications to connect to your SQLite database files, you must be familiar with the locking strategy of SQLite.