Create Stock On Hand Database Elements and template it in Nifi

Description

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.

Assignee

Wam Bere

Reporter

Craig Appl

Labels

Story Points

3

Sprint

None

Fix versions

Affects versions

Priority

Major
Configure