Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Add odbc data from SQL to Kepware server v6.13

LouisG_9111027
2-Explorer

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

  •  

 

 

 

ACCEPTED SOLUTION

Accepted Solutions
1 REPLY 1

Announcements
Top Tags