External databases

you can add connections to external structured databases to augment you time series data and event data you can use these databases to fill event properties on detected events configuration available at configuration > external databases , when viewing or editing an external database, are the following fields name description the administrative name for your external database description description give your database a description if you like (optional) database type description the type of database you would like to connect to factry historian supports several types of database postgres mysql oracle sql server sqlite sap (hdb and asa) connection string description you can use $user and $password if you wish to exclude this sensitive data from the connection string if you do 2 extra field will appear below these placeholders are replaced when creating a connection with the values filled in in the next two steps username description the username for the database connection make sure this is a user that only has read only permission on the database password description the password for the database connection timeout description the timeout used when querying the database, in milliseconds default 5000 retry interval description determines how often the connection can be retried default 5000 how tos creating an external database connection docid\ wfsr6qg3camlbib7g vza