Welcome to dmdma

Dirty Master Data Management Application

The aim of this project it to be an example/template/starting point for using flask for a quick and dirty approach to a Master Data Management Application AKA a Data Warehouse Management Application.

Code for this project can be seen on github: d-roman-halliday -> Dirty-Master-Data-Management-Application

Login (via the Authentication link above) to access applications

To Do

Short Term

• Document (in README.md):
  • Deployment
    • Apache WSGI Configuration
    • Python virtual environments for prod
    • Build & deploy process
  • PivotTable integration
  • layout
  • Libraries used
• Apply to python code Documenting Python Code practises.
• Do more Testing Flask Applications with Pytest tests.
• Application: Reporting
  • Try out: chartjs.org
  • Try out: apexcharts.com
• Application: Linking & Mapping
  • report for problems
  • CSV uploads
• Application: System & Information
  • Execute shell script/command (return output)
  • Link/download file(s) from location

Longer Term

• Relocate sqlite files in prod outside of python code (into configurable location)
• Convert Auth to dynamic pages (use bootstrap better)
• Alternative mod_wsgi deployment (compile)
• User Management
• Authentication - Google auth
• Dynamic applications list (using both user information/permissions and available applications)
• Databases (incorporate other connections/libraries for more integration.interaction)
• Application: Secure chart creation
  • Create charts/graphs which can be embedded in an iframe of another application with filter arguments as URL parameters
  • Create/enable secure connections/trust so that the only the host application can create charts (other calls result in error)