Moving data out of Salesforce
You can create a NiFi dataflow to move data out of Salesforce. To do this, you must meet some prerequisites, configure Salesforce, configure your controller services, build your dataflow, and configure the source and target processors.
Objects in Salesforce are database tables. The rows are known as records, and the columns are called fields. The QuerySalesforceObject processor queries Salesforce objects and retrieves their records.
The processor constructs the query using Salesforce Object Query Language (SOQL) and retrieves the result record dataset using the Salesforce REST API.
The processor utilizes streams and NiFi record-based processing to be able to handle a large number of records and to allow arbitrary output format.