Skip to main content
B
Billy1-Visitor
1-Visitor
January 24, 2022
Question

What is the best way to migrate data from Kepserver EX6 Datalogger to Thingworx

  • January 24, 2022
  • 2 replies
  • 2291 views

Hello Everyone,

 

I am looking for some knowledge and advice here.  Right now my team is logging data from machines using Kepserver EX6 and its Datalogger feature with the goal of migrating it to our Thingworx server.  We have other Thingworx server and I know it has the import/export feature but I am not sure if this works with data from Datalogger.  Also I do not know if Kepserver has an export feature to allow exporting data to Thingworx seamlessly.  Is there an export feature in Kepserver Datalogger?

 

Lastly (and I know this is broad in scope) but currently we have one Device per Channel and then we create a new Log Group with each device and log all of their tags/log items in that group.  Is that a industry best practice?  Considering I want to migrate/import this data to Thingworx.

 

Thanks for your feedback!

 

-Billy

 

Ultimately I am just looking for an easy way to migrate the data into Thingworx.  

2 replies

V
24-Ruby III
VladimirN24-Ruby III
24-Ruby III
January 25, 2022

 Hi Billy,

 

Some helpful article - ""How to configure KEPServerEX / ThingWorx Kepware Server Data Logger plug-in to log data to relational databases"": https://www.ptc.com/en/support/article/CS274384 

B
Billy1-VisitorAuthor
1-Visitor
January 25, 2022

Hey VladimirN,

 

I already know how to do this.  But my question is if there is a good way to take the data logged from the database and import it into Thingworx Foundation.  Like possibly import it into the Value_Stream table for the Thingworx Database.

B
Billy1-VisitorAuthor
1-Visitor
January 27, 2022

Anyone else have any ideas?  Do I have to manually export the raw data from the database and then manually import it into Thingworx using the import/export tool in Thingworx 9.1?

Terms & ConditionsCookie settingsAccessibility statement