Hi eksantrik,

Might you happened to have seen my post in this thread: https://forum.infiniteautomation.com/topic/3115/sql-data-source-query/2

It may have some relevant information / inspiration.

The connection between the SQL points is the 'column name' on the point. If 'Row-based query' is not checked on your data source, then the point will get the value in the value column if its column name matches the ID column. If you are doing a row-based query, then it's the first selected column contains the identifier.

@eksantrik The SQL Data Source should accomplish what you need.

https://help.infiniteautomation.com/configuring-data-sources-and-data-points/
Once you have added a SQL Data Source, click the blue help icon for more documentation.

Hi eksantrik,

The JDBC driver for MSSQL is not bundled with Mango. You can download it here: https://docs.microsoft.com/en-us/sql/connect/sql-connection-libraries#anchor-20-drivers-relational-access (has links for 6.0 and 6.2 for Java currently). You want the .tar.gz download, it'll have the driver compiled for Java 8, so copy that jar into your Mango/overrides/lib directory and try again.

Good day,

We are trying to develop bacnet explorer using bacnet4j. the thing is that this explorer will not be in the same subnet as the bacnet controller most of the time. We can send who-is messages to the local broadcast address with destination network address 65535. We are trying to figure out how we can achieve the same when we are not in the same network as bacnet controller but we know the IP of the bacnet controller.

Does bacnet4j support it?

Thanks