Create Stock On Hand Database Elements and template it in Nifi

We need to create stock on hand data source in postgreSQL autoloaded and templated from Nifi.

Activities:

• 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

Acceptance Criteria:

• 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.