Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.
SQL DataSource
-
I linked an external database I did Statement test with a simple select * from my table query and I managed to get the result set. So, I tried to create a datapoint because I imagined that they could be used to derive data through a sql script. As far as I could understand, can only insert and update?
Thanks in advance for the support -
@pierjsap Not following. What is the problem? You said you could query and get a result, then you said you could insert and update. Not there are two buttons "Submit query" and "Submit update".
I would not recommend trying to insert data points via the SQL console regardless. There is a binary blob field which you will not be able to insert easily. Also you will need to restart Mango after doing any manual SQL inserts in this manner.
There will be a new UI module out today probably which will enable you to create data points via CSV. Hopefully that will help you.
[edit] Wait.. SQL data source.. I was thinking you were talking about the SQL console. Why are you trying to create data points from within a data source?
-
Hi pierjsap,
I too am somewhat confused. It sounds like you're asking if the SQL data source can read data? The answer is yes, it can store data from the data source's select statement or it can be configured only to update the table (which it must be if you wish to set the point to some dynamic value in the update statement, a point that isn't "Modify Table Only" will only have a constant update statement), You either have to match the 'Column name' property of the point to the column names returned, or do a "row based query" and have the column name match the value in the first column of the results, then its value in the second column.
There are a few examples scattered around the forum. If you can say more, perhaps I can recall a relevant thread for you.
