The community will undergo maintenance on October 16th at 10:00 PM PDT and will be unavailable for up to one hour.
Hello,
I am trying to log the data from KEPServerEx to MongoDB using MongoDB ODBC Driver and
Unable to open recordset on log group 'LogGroup2'. Reason: parse sql 'SELECT * FROM "KepserverData"' error: unexpected STRING at position 30 near KepserverData
Solved! Go to Solution.
Hello,
Unfortunately we do not expect Kepware Server's DataLogger Plugin's ODBC implementation to be compatible with MongoDB's ODBC driver. We have not officially tested, however other customers who have tried have had similar experiences and direct connection hasn't been possible. Currently we do not have plans to add specific support to DataLogger for MongoDB, but you might be able to use an alternative method.
If ThingWorx is involved in your solution, then I'd recommend that you explore its direct integration with MongoDB. Kepware could use its AlwaysOn interface to stream the data to ThingWorx, at which point ThingWorx could be configured to store the values received in MongoDB.
Additionally, you could use Node-RED and nodes attached to either Kepware's OPC UA server interface or IoT Gateway Plugin (MQTT Client or HTTP Server/Client). Also, I do not believe MongoDB has a native REST API that you could target directly with our HTTP Client Agent within the IoT Gateway Plugin, but you could explore the use of these REST API wrappers for MongoDB:
https://stackoverflow.com/questions/7386740/does-mongodb-have-a-native-rest-interface
We haven't tested these and can't speak to compatibility, but if you're interested in following up with our pre-sales support team about further help on this topic, you can send an email to presales.support@kepware.com.
Thanks,
Sam
Hello,
Unfortunately we do not expect Kepware Server's DataLogger Plugin's ODBC implementation to be compatible with MongoDB's ODBC driver. We have not officially tested, however other customers who have tried have had similar experiences and direct connection hasn't been possible. Currently we do not have plans to add specific support to DataLogger for MongoDB, but you might be able to use an alternative method.
If ThingWorx is involved in your solution, then I'd recommend that you explore its direct integration with MongoDB. Kepware could use its AlwaysOn interface to stream the data to ThingWorx, at which point ThingWorx could be configured to store the values received in MongoDB.
Additionally, you could use Node-RED and nodes attached to either Kepware's OPC UA server interface or IoT Gateway Plugin (MQTT Client or HTTP Server/Client). Also, I do not believe MongoDB has a native REST API that you could target directly with our HTTP Client Agent within the IoT Gateway Plugin, but you could explore the use of these REST API wrappers for MongoDB:
https://stackoverflow.com/questions/7386740/does-mongodb-have-a-native-rest-interface
We haven't tested these and can't speak to compatibility, but if you're interested in following up with our pre-sales support team about further help on this topic, you can send an email to presales.support@kepware.com.
Thanks,
Sam
Hi @harshadbhandure.
If the previous response answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.
We appreciate your participation in our community!
Regards.
--Sharon