User`s guide

CHAPTER 6 Components
User’s Guide 75
One or more SQL statements can be executed when all components
finished processing the project.
Note When using multiple statements, you can separate the statements by
using a semicolon.
Connecting to a SQLite database
A SQLite database is represented as a single file with the extension .db. The
database file can contain any number of tables.
❖ To connect to or to create a SQLite database
1 Select SQLite Persistent from the Interface drop-down list.
2 Enter a new or existing file name for the SQLite database in the Host
Name property. A new name will automatically create a new SQLite
database file with an extension .db. Do not enter the extension .db when
entering the name of an existing SQLite database.
For example, to create a new SQLite database file mySQLite.db or to connect
to an existing mySQLite.db database file:
• Interface: SQLite Persistent
• Host Name: mySQLite
The database file created is named mySQLite.db.
Creating a SQLite table
Use Content Explorer to manually enter attribute information for creating a
table. Right click a Staging component and select Add Staging table from input
or Add Staging table from port to automatically create a table matching the
conventions of the database connected to the component using the port
structure.
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.