We need to create stock on hand data source in postgreSQL autoloaded and templated from Nifi.
Define the data structure of the postgresql database for this report
Load the tables in using Nifi (create Nifi template)
(May be needed) Create a template to stand-up the database connection pool to the particular table.
Define the original data sources from OpenLMIS and build the Nifi template to extract this information
Test to ensure data is appropriately extracted and loaded into the database
The Create Table Template is created and exported to this ticket
The Nifi data ingestion template(s) are created and exported to this ticket
Tests pass and the system can be started and stopped.