Fetch Data from DB

Quick tutorial on Fetcher

Steps to follow

1. From the Processing & Pipelines module select Build Pipelines section.

2. Click the Fetch Data from DB button, a popup appears.

3. Frontier allows two option to store the fetched data from database :

   1. Add a new file allows user to create a new file when the file doesn't exist in frontier system.

   2. Modify a pre existing file allows user to update the old file from the new updated file on the database.

4. Frontier allows two options to fetch data from the database :

   1. Normal Fetch Operation allows user to write normal select queries from the database.

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

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

6. Click Save button to save the pipeline, or Save & Execute button to execute the pipeline right away.

Walkthrough

https://www.loom.com/share/d08ddc37c590447aa3c54c0506cd29eewww.loom.com