Skip to main content
RS_89419843-Newcomer
3-Newcomer
Aug 9, 2024 1:49 PM UTC
Solved

Kepware Datalogger

I am trying to configure Datalogger and keep running into issues in the configuration. I have created my DSN correctly and it successfully passed the connection test. But whenever I try to select the table name, the dropdown list does not show any of the tables in my database. I attached a screenshot of what shows up in the dropdown. 

aservetasAnswer
15-Moonstone
Aug 14, 2024 10:33 AM UTC

When you set the user credentials in the DataLogger configuration to be passed through the DSN to the DB, make sure the user account being passed has the correct permission set for the table.  If the user cannot interact with the required table (read/write/modify) then you wont be able to select it from the DB for use.

 

Also, it needs to be a real table, not a view.

 

-Andy

Andy Servetas
Principal Technical Support Engineer | Kepware Technologies

View in thread

5 replies

ntripathi16-Pearl
16-Pearl
Aug 9, 2024 3:13 PM UTC

Greetings @RS_8941984 ,

 

I hope you're doing well.

 

When creating a LogGroup in Datalogger, please ensure that you specify the Table. This step is crucial for proper configuration.

 

Additionally, I would like to know which database you are using with Datalogger. Sometimes, certain databases or versions might have compatibility issues. Please verify the compatibility of your database to avoid any potential problems.

 

 

Kindly check the logs or any error messages that Datalogger might be generating. These can provide clues about what might be going wrong. 

 

Translate
RS_89419843-NewcomerAuthor
3-Newcomer
Aug 12, 2024 5:35 PM UTC

Thats the problem. When I try to specify the table that I want, the dropdown does not list any tables I have in my database. Instead, it has a list of what looks like configuration data.

KepData.png

Translate
SlidingDownhill12-Amethyst
12-Amethyst
Aug 12, 2024 5:44 PM UTC

As I recall you have to type the table name in and you only know if you are wrong by looking at the event messages. 

Translate
aservetas15-MoonstoneAnswer
15-Moonstone
Aug 14, 2024 10:33 AM UTC

When you set the user credentials in the DataLogger configuration to be passed through the DSN to the DB, make sure the user account being passed has the correct permission set for the table.  If the user cannot interact with the required table (read/write/modify) then you wont be able to select it from the DB for use.

 

Also, it needs to be a real table, not a view.

 

-Andy

Andy Servetas
Principal Technical Support Engineer | Kepware Technologies

Translate
    RS_89419843-NewcomerAuthor
    3-Newcomer
    Aug 14, 2024 2:46 PM UTC

    Thank you! I had permissions setup in the database for that user, but I did not have permissions setup in the actual table for the user. As soon as I added that user INSERT permissions the table came up the in the dropdown. Thank you so much!

    Translate
    Terms & ConditionsAccessibility statement