Quickbase Pipelines Agent use cases

Use cases for Pipelines Agent include the following.

MSSQL to Quickbase

In this example we use the ODBC channel to access to a company MSSQL database and then add some current tenant personal data from that database to a Quickbase app.

1. In the first step of this pipeline we prepare a bulk import operation to import data into the Quickbase database. using Prepare Bulk Upsert
   
   
   
2. We then use Search Rows to find ODBC data.
   
3. We use the results of this search to Add Row to Bulk Upsert,
   
   
   
4. In the last step, we use Commit Upsert to update an existing record or create a new one.