You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Assumptions

  • installed opCharts

Overview

opCharts has dashboards built into the heart of it's engine.  Dashboards have the ability to display components, components can load data from many different sources and display it as a graph/table/pie/chart/etc.  Right now only graphs are supported.

Data Sources

/usr/local/omk/conf/data_sets.json defines the data sources that the system will make available to the charts.  Currently only SQL external data sources are supported.  The default configuration ships with examples for MSSQL and MySQL servers. Here is an example a data source definition: 

{
         "name" : "mssql_example",  # name used to access this data source in charts.json
         "type" : "sql", # fixed, no other types are currently available
         "data_models" : [ "sql_query" ], # also fixed.
         "parameters" : {
            "scheme" : "dbi", # fixed
            "driver" : "ODBC:DRIVER=FreeTDS", # dbi options that have been installed are available, only MSSQL and MySQL are tested
            "host" : "mani.opmantek.com", # SQL server host/ip
            "port" : "1433", # port SQL can be found on
            "database_name" : "testdb", # database to pull data from
            "username" : "sa", # username
            "password" : "password" #password
         }
},

The name specified for your data source will be used in other configuration files to access the data from this data source.

Dashboards

Dashboards can be created and set as the default for many different views of the system (depending on standalone mode the options to do this differ). 

    • defined application wide (not stored per user)
    • names are unique, cannot be changed after creation (because they are used to link into other places, like default dashboards
    • care should to be taken to ensure that a dashboard that is visible to a customer does not contain graphs that the customer should not see
      •  the inclusion of components in a dashboard means any user who is allowed to see and load those components
    • if a dashboard is deleted which is also set to a users default dashboard the user will just see the regular index page because the one picked cannot be found. 

 

  • No labels