Integrate with Database TableLast Updated: 01/15/2019 Introduced in Version:
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] (Figure 1).
On the Database Integration dialogue in the Connection section under connection, select the radio button next to Select an existing connection. Choose Next to continue (Figure 2).
In the Database Integration dialogue under Table Name, choose the database that you will integrate with from the drop down (Figure 3).
The Database Integration dialogue will display with all of the Table Fields checked. Make sure to uncheck any Feilds that you will not be using (Figure 4).
Continue to define the Flow Steps on the Database Integration (Figure 5).
In the Database Integration dialogue, the Get All step has been selected (Figure 6).
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 (Figure 7).