External databases

connections to external structured databases can be added to augment time series data and event data these databases can be used to docid\ ds e9huv8qe7bngq4y3cd and/or docid\ agu54 sclo0ds8tawvn2d 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 $user and $password can be used as placeholders to exclude this sensitive data from the connection string when these placeholders are present, their fields will be made available these placeholders are filled in when creating a connection with the values filled in in the next two steps username description the username for the database connection preferably make sure this is a user that has read only permissions 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 10000 how tos docid\ wfsr6qg3camlbib7g vza