Can MangoAutomation connect to MS SQL Server?
mebius last edited by
One of my customer need a SCADA which can connect to an existing MS SQL Server. as I know, Mango Automation can't connect to the SQL Server.
Is it right？ and is there a method to make it possible? thanks.
ThomasEinasto last edited by
Does your customer want to use their existing MS SQL server as their Mango database? If so then I guess you are out of luck because to my knowledge mango can use 3 main types of databases: H2 (default), Derby, MySQL and also their own fast NoSQL database.
If your customer wants to use their SQL server so that Mango gathers data from it then you should look into the SQL Datasource module which supports MS SQL server connection. As I have never used this module I cannot help but there is help in the datasource module if you click the blue questionmark while creating the datasource.
JoelHaggar last edited by
Thomas is exactly right with the exception that we don't support Derby anymore as the main Mango database. The SQL data source is very flexible and can be used to pull or insert data from a MS SQL database but Mango does not currently support MS SQL as the main database. Mango could certainly be made to with MS SQL as the main database but it means that every new release then needs to be tested on it as well. When you are using the NoSQL module with Mango there is a lot less load on the database so most people are very happy with using MySQL combined with the MangoNoSQL (Time Series Database).