Integrate with Database Table

Last 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).

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).

 

 

 

Figure 2

In the Database Integration dialogue under Table Name, choose the database that you will integrate with from the drop down (Figure 3).

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).

Figure 4

Continue to define the Flow Steps on the Database Integration (Figure 5).

Figure 5

In the Database Integration dialogue, the Get All step has been selected (Figure 6).

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).

Figure 7

Links

 Integrate with an External Database

 

Additional Resources