---
title: "Insert, Update, Insert and Update Steps"
slug: "integrated-database-steps"
updated: 2022-07-26T17:55:36Z
published: 2022-07-26T17:55:36Z
canonical: "documentation.decisions.com/integrated-database-steps"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://documentation.decisions.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Integrated Database Steps

| ## Step Details |
| --- |
| **Introduced in Version** | --- |
| **Modified in Version** | 8.4.0 |
| **Location** | Integrations > Database > [DatabaseName] |

The Integrated Database steps allow users to manipulate database tables that have been externally added to the platform. The Insert step allows a user to add a record to the integrated table and the Update step allows a user to change the details of an existing record in the table.

---

## Properties

The Integrated Database steps include the following steps that can insert and/or update a record in a table:

- Insert
- Update
- Insert and Update

### Environment

| Property | Description | Data Type |
| --- | --- | --- |
| Use Transaction Data | Allow users to use transaction data with the integrated database table | --- |
| Run In Defined Environment | Allows the step to run in the environment or use an Agent | --- |
| Override Connection String | Allows users to manually override the connection string of the database | --- |

### Inputs

| Property | Description | Data Type |
| --- | --- | --- |
| Inserted/Updated/Merged Objects | Allows the user to insert and/or update a record in the table (for Postgres integrations, the Insert, Update, and Insert and Update steps allow the generation of auto-increment Serial Primary Key columns if the id field is set as NULL) | Object |

### Outputs

| Property | Description | Data Type |
| --- | --- | --- |
| Failed |
|  | Error Details | Description of the error displayed | String |
|  | Error Message | Error message to be displayed | String |

![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1658857833367.png)

Related Information

Forum Posts: [Integration Settings](https://support.decisions.com/forum/topic3326-integration-settings.aspx)

## Related

- [Bulk Insert to [Database Name]](/bulk-insert-to-step.md)
- [Batch Insert Entities Step](/batch-insert-entities-step.md)
- [Wait On External System](/wait-external-system.md)