/EPIC.track

Integration of formsflow.ai to EPIC for administration support

Primary LanguagePythonApache License 2.0Apache-2.0

EAO Project Tracker img

Environment Assessment Office Project Tracker

Solution Objectives

Prototype a modern and digital project tracker, compliance and enforcement tool using low code and open source solution.

Determine the value an feasibility of this solution.

Solution Constraints

Nbr Constraints
1 The solution should be deployed in Openshift environment
2 The solution should use low code tehnology stack
3 The solution should use open source technologies

Solution

Use formsflow.ai which is a completely free and open-source framework that integrates intelligent forms, decision making workflows, and powerful analytics.

Solution Components

Here is a snapshot of various solution components for this solution

Soluttion Components

Nbr Component Description
1 Staff The users who access the system for faily work.
2 Identity Service Service that provides authentication and authorization for staff identity.
3 Electronics form Provides the capability to create online forms quickly and easily with an intuitive low code form designer with advanced capabilities including data validation, conditional fields, file uploads, and signatures.
4 Decisions/Processing Workflows Provides the capability to design and deploy automated and human-centric workflows.
5 Insights Provides the capability to visualize data relevant with customizable dashboards. Track submission metrics and derive insights from submitted form data.
6 Line of Business Systems These are the internal systems of the organization that is either created as part of the solution or solution integrate.

Solution Architecture

Here is the overall architecture for the solution Soluttion Architecture

formsflow.ai components

This solution make use the full set of components provided by formsflow.ai

Nbr Component Description
1 Web Web Portal for staff.
2 Analytics Redash based Analytics component to provide insights and dashboards.
3 Electronics form Form.io based form manager that provides the capability to create online forms quickly and easily with an intuitive low code form designer with advanced capabilities including data validation, conditional fields, file uploads, and signatures.
4 BPM Camunda based process automation engine that provides the capability to design and deploy automated and human-centric workflows.
5 APIs Python based APis integrate all other components with in the formsflow.ai.
6 Identity Service Keycloak for identity management and SSO across formsflow.ai components.

Additional Components

Nbr Component Description
A IDIR Identity Servuce BC Gov SSO via OIDC's Keycloak for authentication. Staff users can authenticate with IDIR.
B EAO Reporting API Python](https://www.python.org/) based APis used to integrate between formsflow.ai solution components and the reporting db. Access to APIs are secured by OIDC tokens from Keycloak.
C Central Database PostgreSQL based database store information.

Technologies Overview

formsflow.ai

Use formsflow.ai which is a completely free and open-source framework that integrates intelligent forms, decision making workflows, and powerful analytics as the core solutoin component. This will be further customized and extended to meet the prototype requiremnts.

Central Database

PostgreSQL is used as central database for the project due to the large adoption on BC Gov projects.

This decision is only applicable to the additional solution components. formsflow.ai comes with its own set of databases.

APIs

Python was selected as the technology to develop APIs required for integration between formsflow and additional solution components.

Staff Identity

BC Govt uses IDIR as the identity for their staff. BCdevexchange already setup a Keycloak to provide IDIR based authentication for SSO. The Keycloak instance installed as part of formsflow.ai is updated to add BCdevexchange Keycloak instane as a Identity Provider.