...
Charts
Data Sources
{{/usr/local/omk/conf/data_
...
sources.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 in data_sources.json file ships with examples for MSSQL and MySQL servers. Here is an example a data source definition:
| Code Block |
|---|
{
"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
}
}, |
...