Creating an external database connection

to create an external database connection, go to the configuration tab on the bottom left your can find the external databases overview in the organization setting section click the create database button enter a unique name optionally enter a description select a database type currently mysql, sap (hdb and asa), postgres, oracle, sql server and sqlite are supported timeout in milliseconds (this is the default maximum time factry historian will wait for a query to complete ) enter a connection string 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 enter the username for the database connection make sure this is a user that only has read only permission on the database enter the password when you’re done you can press the save button, if everything is working you’ll see a success notification if something went wrong more details are available in the error message always make sure you configure a user with read only privileges to prevent possible data loss by misconfiguration