Extracting data from an existing SQLite table

Provide the proper connection parameters for the SQLite database file on a DB Data Provider component or a Staging Component.

SQLite supported SQL commands can be used in the pre-processing or post-processing SQL properties of components connected to databases.

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

Note Before using external client applications to connect to your SQLite database files, become familiar with the locking strategy of SQLite.