SQL Server

[aFouraker]

I am confused about the support that WEbIQ will provide for the SQL database available from WebIQ. The documentation here for the front end and here for the backend implies that these are useable features that we can integrate into applications. However, the forum response here says this is not an option. 

What is the correct answer to this question? Is it supported and if not, does WebIQ intend to remove these features? 

[minuable1]

Is there anyone give the answer for it?

[webiq-eg · Accepted solution]

Hi there,
Please excuse the very late reply on this topic, I would like to give some information on this:
- WebIQ internally uses a SQLite database to store information such as trend data, historical alarms, etc.
- Direct SQL access via the API you specify is possible, but switched off by default via the WebIQ authorization system (Access Control List) to prevent misuse etc. We will mark these API functions as deprecated in the future.
- However, indirect access to the WebIQ server data, e.g. via the Recorder Manager, Recipe Manager or Alarm Manager, is possible at any time.

I will prepare an example, e.g. to transfer the trend data from the WebIQ server to an external SQL server, maybe that will help you understand. I will post here if it es ready.
Many greetings
webiq eg

[aFouraker]

I have an application that is using the Web IQ server based on the documetation that is available. It is possible to retain those features moving forward? From my perspective an integrated database is a powerful saling point of WebIQ. 

[webiq-eg]

I see it that way too, but a database query via SQL command is a major security gap. You can use the database and access it, but via the ready-made SQL commands (prepared statements) or via the manager (trend manager, recipe manager, etc.).
If you can give me a specific use case, I might be able to give you a better example.

Many greetings
webiq eg

[aFouraker]

@webiq-eg, I will send you a direct message. We have used some of these utilites so I am hoping you can give me some guidance.