Data extraction from Mango to Cloud Services Providers

[jyc9999]

I have the following use case and looking for the best way to get data point values data out of Mango Automation into a centralized cloud platform for analytics purpose.

I learned there are 2 different "types" of APIs: one of the REST API through Swagger, another one is the API in the system. Am I understanding it right? Any guidance will be greatly appreciated.

Use case:

1. one SCADA system, such as Mango Automation System, is installed in one facility. There are multiple facilities which located in different geographic locations. Each facility operates independently. The SCADA system captures similar data points (but not all data points are the same nor being captured at the same frequency).
2. Some facilities use Mango Automation as the SCADA system and some other facilities use other types of SCADA systems due to legacy reasons.
3. We want to integrate all SCADA systems data into a centralized cloud platform and put an analytics layer on it. This is why we are seeking the best way to extract data out of Mango Automation System.

Thank you very much!

Jack

[JoelHaggar]

Hi Jack,

This is a very common application for Mango and there are some really nice tools build-in to make it happen.

You would put Mango at each remote location collecting data via the local network using any of the protocols available.

You would then have a central Mango running on a server or in the cloud or use a hosted Mango server provided by us.

In each remote Mango, you would configure a "Mango Persistent TCP Publisher" pointing at the central Mango and in the Central Mango you would configure a "Mango Persistent TCP Data Source" for each remote Mango.

There are a lot of options of how the publishers work but you can basically configure it to sync real-time and/or historical data. It's a very reliable way to get the data to a central location as all data is buffered on the remote site and validation is done to make sure it all gets synced. If the connection is down for a period of time all data will be synced once it comes back.

Let me know if this is what you had in mind?

[jyc9999]

@joelhaggar, thank you for quick response!

What you described is 90% of what we want to do. If each remote location has a Mango installed, what you described would be spot on.

The only problem is we don't have mango installed in not every remote location. Mango is new to our environment. We have quite a few different types of systems handling similar process in different remote location. That is why we are looking for a way, preferably a built-in API in Mango, to extract data point values into a system independent data warehouse-ish as part of the analytics platform.

Does this make sense?

[JoelHaggar]

Mango pretty much is a "system independent data warehouse", If you could use it in this way the question would be how to get the data from your other systems into Mango. Normally the answer to this is to install Mango on site and get data from the system via Modbus, SQL Database, API, CSV file, etc.

If you just want to get data out of Mango into a third party system you have a lot of options. You can use the REST API, you can have Mango make an HTTP post, you can write scripts to send the data, you can have Mango email out the data. You can have Mango insert data into an SQL Database and probably many more. I think the answer will come down more to what your data warehouse prefers.

I would still suggest looking at Mango as your central warehouse and then working on how to get the data from your other systems into Mango but it will work either way for you. You can also call us to discuss more of these options.

[jyc9999]

@joelhaggar Thank you for your expertise on Mango! I will bring this info back to our folks. We might take up your offer if we still have questions.

Thank you again!

Jack