Integrate with Database Table
  • Updated on 05 Mar 2019
  • 1 minute to read
  • Print
  • Dark
    Light

Integrate with Database Table

  • Print
  • Dark
    Light

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]
Add-Table1.jpg

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.

Select-connection.jpg

In the Database Integration dialogue under Table Name, choose the database that you will integrate with from the drop down.
2018-07-26_110446.jpg

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

Continue to define the Flow Steps on the Database Integration
integ.jpg

In the Database Integration dialogue, the Get All step has been selected .
2018-07-26_112108.jpg

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 .
2018-07-26_113152.jpg

Was this article helpful?