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.
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.
--
Outputs
Property
Description
Data Type
Error Details
Outputs a string of Error Details.
String
Error Message
Outputs a string with an Error Message.
String
Step Changes
Description
Version
Release Date
Developer Task
The Batch Insert to Oracle with Delay Step was added as a new Flow Step to the Product.
.png)