Skip to main content

Oracle components

tOracleBulkExec Offers gains in performance during operations performed on data of an Oracle database.
tOracleClose Closes the transaction committed in the connected Oracle database.
tOracleCommit Validates the data processed through the Job into the connected Oracle database
tOracleConfiguration Stores connection information and credentials to be reused by other Oracle components.
tOracleConnection Opens a connection to the specified Oracle database for reuse in the subsequent subJob or subJobs.
tOracleInput Reads an Oracle database and extracts fields based on a query.
tOracleInvalidRows Checks Oracle database rows against specific Data Quality patterns (regular expression) or Data Quality rules (business rule).
tOracleLookupInput Reads a database and extracts fields based on a query.
tOracleOutput Writes, updates, makes changes or suppresses entries in an Oracle database.
tOracleOutputBulk Writes a file with columns based on the defined delimiter and the Oracle standards.
tOracleOutputBulkExec Executes the Insert action in the specified Oracle database.
tOracleRollback Cancels the transaction commit in the connected Oracle database to avoid committing part of a transaction involuntarily.
tOracleRow Executes the stated SQL query on the specified Oracle database.
tOracleSP Calls an Oracle database stored procedure.
tOracleTableList Lists the names of specified Oracle tables using a SELECT statement based on a WHERE clause.
tOracleValidRows Checks Oracle database rows against Data Quality patterns (regular expression).

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!