Skip to content

VCHDecisionSupport/OdbcProfiler

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

45 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ODBC Profiler Web App

Automatically profile and visually review Sql Server and Denodo (ODBC driver) data sources

  • Table Row Count
  • Column Distinct Count
  • Column Value Histogram (ie GROUP BY)

Use Case

Centralized starting point for testing

  • Quick and easy access to volumes for high level validation
  • Compare equivalent tables across different servers
  • Compare Denodo and Sql Server
  • Monitor profiles to detect deviations
  • Drill into profiles to identify underlying causes

Rules Based Monitoring

For each profile measure:

  • Simple Moving Average
  • Exponential Moving Average
  • Variance