Kepware Datalogger

[RS_8941984]

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. 

[ntripathi]

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. 

[RS_8941984]

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.

[SlidingDownhill]

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. 

[aservetas · Accepted solution]

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

[RS_8941984]

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!