Bulk Insert to [Database Name]

Updated on 20 Dec 2024
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	3.0.0
Last Modified in Version	8.2.0
Location	Integration > Database > [Database Name] > [Table Name]

For an External Database Integration, multiple entities can be added to a table using the Bulk Insert to [Database Table Name] step.

This step operates similarly to a Batch Insert step, allowing users to add multiple instances of a specific DataType that are either mapped from another source or mapped directly on the step via Constant mapping to a Database.

However, this step can only insert a specific External Database Table with the Insert Property enabled.

In versions 7.13+ and 8.4+, if a Postgres database is used, the Serial Primary Key column will be generated and auto-incremented when a new value is added to the table.

Oracle Databases

This step does not function for Oracle Databases.

MySQL

This step is not currently available for MySQL integrations.

Properties

Environment

Property	Description	Data Type
Use Transaction Data	If enabled, creates an additional input for a Transaction Data data type to be included with the insert.	Boolean
Run in Defined Environment	Enabled by default. Runs the query in the defined environment when setting up the table integration.	Boolean
Override Connection String	Overrides the connection string used by the step.	Boolean

Inputs

Property	Description	Data Type
Inserted Objects	The object being inserted into the database	Varies

Outputs

Property	Description	Data Type
Error Details	Output displayed when the step fails. This will contain details on why the transaction failed to complete	String
Error Message	Output displayed when the step fails. This will contain the exact error message as to why the transaction failed to complete	String

Enabling Bulk Insert For External Databases

To use the Bulk Insert step for an External Database Table, the Insert Property must first be enabled for the Table. To do so either enable it from the Define Flow Steps window upon adding the Table Integration or:

From the Decisions Studio, navigate to System > Integrations > Databases [NAME OF DATABASE].
Right-click the desired Table, then click Edit Table.
Click NEXT through each window until the Define Flow Steps window appears.
Under Define Flow Steps, check the Insert Boolean.
Click SAVE to save the changes and close the window.