connect SQL to apache nifi

sam picture sam · Jan 5, 2017 · Viewed 15.5k times · Source

I'm new to nifi and i want to connect SQL server database to nifi and create a data flow with the processors. how can I do this, can any one Help me with this clearly.

Thanks in Advance sam

Answer

mattyb picture mattyb · Jan 5, 2017

Here are two great articles on getting information in and out of databases with NiFi:

  1. http://www.batchiq.com/database-injest-with-nifi.html

  2. http://www.batchiq.com/database-extract-with-nifi.html

They describe/illustrate how to configure a DBCPConnectionPool service to provide connection(s) to an RDBMS, and example flows to extract data and ingest data.