Skip to main content

SingleStore components

tSingleStoreBulkExec Loads data from a file into a table of a database connected through JDBC API.
tSingleStoreClose Closes an active SingleStore connection to release the occupied resources.
tSingleStoreCommit Commits in one go a global transaction instead of doing that on every row or every batch and thus provides gain in performance.
tSingleStoreConnection Opens a connection to the specified database that can then be reused in the subsequent subJob or subJobs.
tSingleStoreInput Reads any database using a JDBC API connection and extracts fields based on a query.
tSingleStoreOutput Executes the action defined on the data contained in the table, based on the flow incoming from the preceding component in the Job.
tSingleStoreOutputBulk Prepares the bulk file to be used as a parameter to feed the database connected.
tSingleStoreOutputBulkExec Provides performance gain when loading data from a file into a table of a database connected through JDBC API.
tSingleStoreRollback Avoids commiting part of a transaction accidentally by canceling the transaction committed in the connected database.
tSingleStoreRow Acts on the actual DB structure or on the data (although without handling data) using the SQLBuilder tool to write easily your SQL statements.
tSingleStoreSP Centralizes multiple or complex queries in a database in order to call them easily.

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!