SmartConnector integrated SQL database

[TomeLu]

hello experts
Has anyone tried to integrate SQL database toEBO through SmartConnector?

Is there a procedure for sharing relevant information?
Thanks in advance

[SteveGregory · Accepted solution]

There is a generic SQL SmartConnector you can get that will allow you to configure a query and will create the EWS points to represent the result. https://exchange.se.com/api/navigation-service/shop/apps/39687/smart-connector---microsoft-sql-datab... 

[TomeLu]

Hi @SteveGregory 

thanks for your reply
I am currently trying to write a program to let PostgreSQL return to EBO through MQTT,
But I'll try your way
Thanks

[Erwin-vd-Zwart]

Can you elaborate on what you are trying to achieve?

[TomeLu]

Hi @Erwin-vd-Zwart 

My purpose is to write machine learning scripts in EBO,
So I import the historical data into the EBO script program
make the program more complete

[Erwin-vd-Zwart]

Well you could create a SC that acts as a REST GW between Postgresql and script so you can fetch data from the DB with a web request, however there are already API's available that can run as a services on a windows machine, like https://postgrest.org/ that exposes an API on the DB without having to write a SC.

The downside is that most responses are JSON and parsing JSON via script is a trivial task.

If you realy want to create AI inside EBO i would look into the option to connect EBO via MQTT to Azure IoT Hub and write your AI in Azure, but that is just a suggestion how to build something future proof..  

[TomeLu]

Hi @Erwin-vd-Zwart 

If possible, I want to use Azure IoT Hub, after all, there are many extended functions on it
But customers remain concerned about information security and cost in the cloud
Therefore, I thought of this way to deal with local data
thanks for your comments
Thanks

[huynhngochoi]

Hi Sir,

I have followed this link but I can't see "ISC.SqlReaderExtension.dll" in "C:\Program Files (x86)\Schneider
Electric\SmartConnector".