Add odbc data from SQL to Kepware server v6.13
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Add odbc data from SQL to Kepware server v6.13
Hi,
I would like to import some values from a table in SQL to be available in Kepwware server. I would like to know what must be the format of the SQL table.
The format of my table is
- Tagname
- Timestamps
- Tagvalue
When imported in Kepware, it add a itemid for each column, i want 1 itemID by row, where the itemId is the tagname, the value the tagvalue and timestamp is time of the values which could be the crurrent time if not possible to use it.
How could i do that?
I have 250 tags to add to Kepware, example for 1 row
- tagname = 021-ENV:AjoutNutriment_Azote_Ajout.EM
- tagvalue = 210.0
- timestamp = 2023-05-30 07:30:00
I would like to see in Kepware
- ItemID = 021-ENV:AjoutNutriment_Azote_Ajout.EM
- Value = 210.0
- timestamp = 2023-05-30 07:30:00
Thanks
Solved! Go to Solution.
- Labels:
-
Tips
- Tags:
- odbc client
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Take a look - "ODBC Client Driver": https://www.kepware.com/getattachment/5db91cc5-7a93-4979-87d6-947f75eb6b94/odbc-client-manual.pdf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Take a look - "ODBC Client Driver": https://www.kepware.com/getattachment/5db91cc5-7a93-4979-87d6-947f75eb6b94/odbc-client-manual.pdf