Integrate with Database Table

Overview

This document discusses how to add a database within the Portal.

Example

1. Navigate to the Folder and select System > Designers > Integrations > Databases.
2. Choose the Add Database Action button and supply the necessary details. 
3. Once a database is introduced, components to query, insert, or update data to or from the database within the Flow Designer can be used. 
4. These tools are found under Integrations > My Integrations > Database > [Database Name] > [Table Name]

   

5. On the Database Integration dialogue in the Connection section under Connection, select the radio button next to Select an existing connection. 
6. Choose NEXT to continue.

   

7. In the Database Integration dialogue under Table Name, choose the desired database to integrate with from the drop down.
   
8. The Database Integration dialogue will display with all of the Table Fields checked. 
9. Make sure to uncheck any fields that will not be used.
   
10. Continue to define the Flow Steps on the Database Integration
    
11. In the Database Integration dialogue, the Get All step has been selected.
    
12. Now the Database Table has been created and defined and the Database Entity can be found in the Designer View as seen in the image below.