Skip to main content
R
RS_89419843-Newcomer
3-Newcomer
August 9, 2024
Solved

Kepware Datalogger

  • August 9, 2024
  • 2 replies
  • 1780 views

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. 

Best answer by aservetas

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

2 replies

N
ntripathi15-Moonstone
15-Moonstone
August 9, 2024

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. 

 

R
RS_89419843-NewcomerAuthor
3-Newcomer
August 12, 2024

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

S
SlidingDownhill12-Amethyst
12-Amethyst
August 12, 2024

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. 

A
aservetas15-MoonstoneAnswer
15-Moonstone
August 14, 2024

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

    R
    RS_89419843-NewcomerAuthor
    3-Newcomer
    August 14, 2024

    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!

    Terms & ConditionsCookie settingsAccessibility statement