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.
- In the first step of this pipeline we prepare a bulk import operation to import data into the Quickbase database. using Prepare Bulk Upsert
- We then use Search Rows to find ODBC data.
- We use the results of this search to Add Row to Bulk Upsert,
- In the last step, we use Commit Upsert to update an existing record or create a new one.