Setting up a SQLite Connection

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Connecting to a Database >

Setting up a SQLite Connection

SQLite (https://www.sqlite.org/index.html) is a file-based, self-contained database type, which makes it ideal in scenarios where portability and ease of configuration is important. Since SQLite databases are natively supported by MapForce, you do not need to install any drivers to connect to them.

 

SQLite database support notes

SQLite databases are supported in the MapForce BUILT-IN transformation language (either when you preview the mapping or when you run a MapForce Server execution file).
SQLite databases are not supported in user-defined functions (UDF).
On Linux, statement execution timeout for SQLite databases is not supported.
Full text search tables are not supported
SQLite allows values of different data types in each row of a given table. In MapForce, all processed values must be compatible with the declared column type; therefore, run-time errors may occur if your SQLite database has row values which are not the same as the declared column type.
If your mapping should write data to a SQLite database, and if you don't have the target database file already, you will need to create it separately. In this case, you can either create it with a tool such as DatabaseSpy (https://www.altova.com/databasespy ) or download the SQLite command-line shell from the official website, and create the database file from the command line (see also Example: Mapping data from XML to SQLite). For complete reference to SQLite command syntax, refer to the official SQLite documentation.

© 2019 Altova GmbH