i4connected Knowledgebase

The SQL Adapter

Abstract

Present article describes the particular settings required in order to configure an SQL Adapter. Check this out for more details!

Present article describes the particular settings required in order to configure an SQL Adapter. The SQL Adapter is capable of reading historical data.

The SQL Adapters can be configured by accessing the Devices tile from the Administrative area of i4connected.

SQL_Device.jpg

The SQL Device

The particular SQL settings required to configure an SQL Device, are available within the Add Device panel.

SQL_Settings.jpg

The SQl Settings

By clicking on the SQL query name field, the Select SQL query panel is opened, allowing the user to select the desired SQL query settings or to add new ones.

Adding the SQL query

By clicking the toolbar button Add in the Select SQL Query panel, opens the Add SQL Query panel.

Add_SQL_query_panel.jpg

The Add SQL query panel

In the Select SQL query panel, the following settings are required to be organised:

  • Name - The name of the SQL settings, that will be displayed in the configured device, under the Sql query name field.

  • Connection string - The connection string, providing information about a data source and the means of connecting to it.

  • SQL query - The SQL query that retrieves the Signal data

    Before saving a new SQL Query, the user can click on the Test query (max. 10 results) button, to check the connection and the query.

    If the query is correctly set up, a maximum of 10 results will be returned and displayed in the table. The SQL Adapter table is defined by the following columns:

    • Timestamp

    • Source

    • Signal

    • Value

    Query_test_successful.jpg

    If there are errors, instead of the results table, the error message will be displayed.

    SQL_query.jpg

    Example of SQL query syntax error

  • Poll interval (ms) - The time interval (in milliseconds) between subsequent polls. By default, the value is set to 60000 ms.

  • Time zone - The time zone used by the new SQL Adapter. By default, the Time Zone defined for the currently logged in user is set.

  • Trace level - The level of logging used by the new SQL Adapter. Trace levels determine which events the trace provider generates. The Trace level value can be Trace, Debug, Info, Warn, Error, Fatal or Off.

  • Enabled - If the setting is turned on, the Adapter is enabled and functional.