Connect zenon to API and SQL Server

Connect zenon to API and SQL Server

Hi,

In my new project I have to preapre communication with SQL Server Data Base and with external API.
1) SQL Server: Exporting data from zenon by historian is not only one function that i need. I have to also communicate with zenon by using SQL, for example i need to use 'insert' method to put some data in zenon. Can you give me some tips how to do that.
2) External API: i need to preapre communication with external API to transfer all information from this API to zenon. Please give me some more info about this.

Thank you
Dawid HetmaƄczyk