Skip to main content

SQLite components

tSQLiteClose Closes a transaction committed in the connected DB.
tSQLiteCommit Commits in one go, using a unique connection, a global transaction instead of doing that on every row or every batch and thus provides gain in performance.
tSQLiteConnection Opens a connection to the database for a current transaction.
tSQLiteInput Executes a DB query with a defined command which must correspond to the schema definition. It passes on rows to the next component via a Main row link.
tSQLiteOutput Executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the job.
tSQLiteRollback Cancels the transaction committed in the SQLite database.
tSQLiteRow Executes the defined query onto the specified database and uses the parameters bound with the column.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!