Fetch Data from DB
Last updated
Last updated
From the Processing & Pipelines
module select Build Pipelines
section.
Click the Fetch Data from DB
button, a popup appears.
Frontier allows two option to store the fetched data from database :
Add a new file
allows user to create a new file when the file doesn't exist in frontier system.
Modify a pre existing file
allows user to update the old file from the new updated file on the database.
Frontier allows two options to fetch data from the database :
Normal Fetch Operation
allows user to write normal select queries from the database.
Query in Fetch Operation
allows user to combine two or more tables to join them and extract into frontier system. The source key and the file name that has the common key should be given.
After the query is written, the Preview Data button
can be used to check if the connection works and will the data get reflected in the Frontier.
Click Save
button to save the pipeline, or Save & Execute
button to execute the pipeline right away.