Integrating an External Database with a FlowLast Updated: 05/02/2018 Introduced in Version: 2.0
Database entities represent external databases which can be integrated with a flow. To add a database within the portal, navigate to the folder System > Designers > Integrations > Databases, click the Create Connection 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 Integration > Integration Database > [Database Name] > [Table Name].
Our example flow will access a local database called Basic, retrieve all of the records from the table MockData, and display them in a data grid form.
Begin in the portal by navigating to the folder System > Designers > Integrations > Databases. Click the Create Connection button.
In the resulting Database Integration pop-up, define the details of the connection. Give this connection the same name as the database to integrate – “Basic.”
Then, click the Test Connection button to see if we can connect to our database with these details. If the platform can connect to the database, a message appears in the lower left corner of the pop up. Click OK to continue.
Next, Navigate to a Designer Folder. Select Datatypes/Integrations > Database Integration > Add Table
Begin building our example flow in a Designer Folder by clicking the Create Flow button.
In the resulting pop-up, name the example flow “External DB Flow” and click OK to create it.
First, it is necessary to retrieve all records from the MOCK_DATA table. This is done using the component Get all from dbo.MOCK_DATA. Find this component in the Toolbox panel, under the category Integration > Database > Basic (Database) > dbo.MOCK_DATA (Table).
This completes our mapping; click OK to close the Mapping Editor. Connect the output path from the form to the End step.
This completes our flow. We can test it by clicking the link Debug Flow at the top of the Flow Designer.