Integrate with Database Table
  • 02 Sep 2021
  • 1 Minute to read
  • Dark
    Light

Integrate with Database Table

  • Dark
    Light

Integrating with a Table grants the Designer access to data in the external database. Designers may choose to create new a Table within Decisions as exemplified below or reference an 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 it's database through internal Flow logic thus removing the necessity of external updates.

To add a database within the portal, navigate to the folder and select System > Designers > Integrations > Databases, choose the Add Database action button and supply the necessary details. Once a database is introduced, components to query, insert, or update data to or from the database within the Flow Designer can be used. They are found under Integrations > My Integrations > Database > [Database Name] > [Table Name]

  1. Databases connection can be found in the Databases folder. Right-click the database connection and select Add Table.  
     
  2. In the Tables Integration window, pick a Table from the database that was integrated with and hit next.

  3. Select the Table Fields needed for integration and 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 integration was successfully.



Was this article helpful?