How to access user list in a Database SQL Centralized

[andrea]

Hello,

we need to read and get the list of user/login from an external centralized database on a server Microsoft SQL Server and use it in iX.
How is it possible? And the better method?

Thank you

Andrea

[mark.monroe]

This forum post has a project that adds users to the security system on the HMI.

If you are using a PC based HMI, then you should be able to use a C# SQL connection library to connect to your remote SQL server. If it is a Windows CE unit, you will have to do more digging and see if you can find a C# library that allows you to remotely connect to your SQL server.

[andrea]

The better thing should be to be able to syncronize user defined inside iX (installed on more machines) with a table of users managed on SQL Server.
is that possible?
We would like to continue to use the user management offered by iX but with data of user and password updated on the server.

Thank you

[mark.monroe]

Passwords are hashed in iX Developer and you can not just send a password directly to iX Developer. You first have to hash it.

What you want to do is possible, but you would have to write all the C# code yourself.