Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
Can MangoAutomation connect to MS SQL Server?
-
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.
-
Hi,
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.
Thomas
-
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).
