Today is...
Saturday, February 25, 2017
The OPC Community Forum.
SQL Data to Cloud EMIS
Looking for some direction/clarity on a SQL integration project

I've been out of the automation/controls industry for awhile and wondering if my approach on a project is the best approach or if there are better ways to do it now.

Have a project in which we want to connect some existing WAGES metering data to a new cloud based EMIS system. All the data from the plant automation network is stored in a SQL db.

What I would have done in the past is installed a OPC DA server and and a data acquisition server with an FTP push out to the cloud server.

Example:
Install the OPC DA server on the local PC with the SQL db then an ethernet connection to an ODBC to ModbusRTU gateway to a data acquisition server that can FTP push the data to the cloud base EMIS server.

Is there a better way to go about this? Is there hardware gateway that can run SQL queries and push the data out to the cloud?

How would I tackle this if I couldn't install the OPC server on the same PC as the SQL db?

Any input, direction, or clarity would be appreciated