auto_stories Knowledge Base chevron_right Work Flow chevron_right Article

DB Query

This control makes transferring data to the database by running a query.

mceclip0.png

DB Query control icon at Flow Tools

 

mceclip1.png 

How it looks like on the Canvas

 

Remarks

This control makes data transfers to Integration DB.  This control only runs if there is the name of the integration DB in the project. This control has a Connection at the end of the control. The resource result of the Connection must be chosen as No Requirement.

 

Properties

Text: The text that appears on the screen is written here.

SQL Query: Data is transferred to the database by running a query. For instance; this can be done by running the procedure.

DLL triggering can also be performed from this area.

For this, the C#Library option should be selected from the SQL Query options.

mceclip0.png

Mapping: This is the section where connection settings are made between Db Query and flow form.

 

Example Used

In this example, the data in Xpoda is transferred to Micro Application. This control makes integration.

mceclip2.png

Flow screen

 

For example; converting to micro was run in this query.

mceclip3.png