--- title: "Integrate with Database Table" slug: "integrate-with-database-table" description: "This document shows how to create an integration with a Database Table, by selecting Database Integration under the Create Data Types/Integration menu. After selecting this option, users can select an existing connection and have the option of which items in the database they wish to include in the table. " tags: ["Database Tables"] updated: 2024-09-17T19:28:06Z published: 2024-09-17T19:28:06Z --- > ## 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. # Integrate with Database Table ## Overview Integrating with Tables grants the Designer access to data in an external database. Designers may choose to create new a Table within Decisions as through the directions below or reference a preexisting table in the external database. Designers also assign defined Flow steps for the created Table enabling the Designer to easily update the Table and its database through internal Flow logic, removing the necessity of external updates. --- ## **Example** To [add a database within the portal](https://documentation.decisions.com/v9/docs/integrating-an-external-database-with-a-flow), navigate to the folder and select **Manage****> Integrations > Databases**, choose the**Add Database** action button and supply the necessary details. Once a database is has been connected, Steps to query, insert, or update data to or from the database within the Flow Designer can be used. They are found under **Integrations > Database > [Database Name] > [Table Name].** 1. Database connections can be found in the **Databases** folder. Right-click the database connection and select **Add Table. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/Screenshot%202024-09-16%20185204.png)** 1. To make an integration within a Project, go to any Designer Folder and press the create Datatypes/Integrations action. Then select Database Integration on the left. That will make this menu appear:![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1723736970475.png) 2. In the **Tables Integration** window, pick a **Table** from the database that was integrated with and hit next.![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1723737038534.png) 3. Select the Table Fields needed for integration. Make sure at least one **Table Key** is selected. 4. Next, check the boxes to have those Flow steps generated in the Flow Designer. Then click Save. 5. After clicking Save, the integrate database table will appear in the folder, indicating the successful integration. Below is a table of available actions when right-clicking a Database Table. | Edit [Advanced] | Can set the type as a [Lookup List](/v9/docs/type-lookup-list). | | --- | --- | | Edit Table | Opens all previous dialogs that are seen when creating the table. | | Manage Additional Access | Opens a new tab to create [Access Patterns](https://documentation.decisions.com/v9/docs/alternate-access-pattern-table-integrations) for the table. | | [Override Action Context](https://documentation.decisions.com/v9/docs/overriding-action-contexts-reports) | Enabling the Override Action Context Property allows users to add Actions for specifically sorted data. | ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/image-1726600403179.png) --- ## Custom Steps In addition to the standard Steps created through a Table Integrations, starting in v9.3 users can create custom Steps. This functionality is very similar to how Access Patterns work. In the top right corner press the + icon to enable custom Steps. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-16_17h47_09.png) The Custom Step functionality will Get whichever fields are selected from the list available in the Table. The new step can be found in the Step Toolbox under **Integrations > Database > [Connection Name] > [Table Name]**. This is useful in cases where it makes sense to fetch all the data from a particular field, rather than using the Get All or Get By Id that are created by default. After a new step is created it will appear in the [Access Patterns](https://documentation.decisions.com/v9/docs/alternate-access-pattern-table-integrations) section when viewing the Database Connection. ![](https://cdn.document360.io/6ef8bcc1-6489-4486-9ad1-83acff7e5df0/Images/Documentation/2024-09-17_15h24_56.png) --- ## Feature Changes | Description | Version | Release Date | Developer Task | | --- | --- | --- | --- | | Table Integration UI was redone. | [9.2](https://documentation.decisions.com/v99/docs/version-92x-release-notes) | August 2024 | [DT-039371] | | Custom Steps can now be created from a Table Integration. | [9.3](https://documentation.decisions.com/v99/docs/version-93x-release-notes) | September 2024 | [DT-041888] |