Batch Insert to Oracle with Delay

Updated on 06 Feb 2025
1 Minute to read

Print
Share
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Step Details
Introduced in Version	8.20.0
Last Modified in Version	8.20.0
Location	Database > Oracle

This Step performs a batch insert (writing multiple entities at once) to an Oracle Database, with a delay before execution. This Step also schedules the write as a Thread Job.

Prerequisites

Users must Integrate an External Oracle Database with the Decisions environment.
After the External Database has been successfully connected, Users must use the following Documentation to Integrate with a Database Table.

Properties

Database Information

Property	Description	DataType
Table Name	This property is the table name associated with the Database Table Definition ID.	--
Connection Name	This property is the name of the Database Connection.	--

Environment

Property	Description	DataType
Use Transactional Data	When this property is checked, a Transaction field appears under Inputs, enabling Users to utilize Transaction Data within the Flow.	TransactionData
Run In Defined Environment	This property is checked by default and enables Users to run the Flow within a defined environment.	--
Override Connection String	When this property is checked, a Connection String field appears under Inputs, enabling Users to manually enter a Connection String for a desired Database.	String

Settings

Property	Description	Datatype
Delay Write to Database	This setting enables Users to customize the Delay Write to the Database and is pre-selected by default.	--
Insert Batch Size	This setting enables Users to customize the Insert Batch Size and is pre-selected by default.	--
Database Table Definition ID	This setting enables Users to enter a Database Table Definition ID from a desired Database Table Integration.	--