title: Which Nifi processor to use for RDBMS Extract
body: <p>i will explain my use case to understand which DB extract utility to use.</p>
  
  <ol>
  <li><p>I need to extract data from SQL Server tables with varying frequency each day. Each extract query is a complex SQL statement, involving 5-10 tables in joins etc with multiple causes. Have around 20-30 such statements overall.</p></li>
  <li><p>All these extract queries might be required to run multiple times a day with varying frequencies each day. It depends on how many times we receive data from source system or other cases.</p></li>
  <li><p>We are planning to use Kafka to publish a message to let Nifi workflow know whenever a RDBMS table is updated and flow needs to be triggered (i can't just trigger Nifi flow based on "incremental" column value, there might only be all row update scenarios and we might not create new rows in tables).</p></li>
  </ol>
  
  <p>How should i go about designing my Nifi. There are ExecuteSQL/GenerateTableFetch/ExecuteSQLRecord/QueryDatabaseTable all sorts of components available. Which one is going to fit my requirement best?</p>
  
  <p>Thanks!</p>