Custom User Storage Provider for Synchronizing SQL Server with Keycloak

Getting advice
1

Hi,

I am trying to create a custom user storage provider for Keycloak that will sync user data from a SQL Server database to Keycloak’s database. The idea is to read user information from the SQL Server database and keep it in sync with Keycloak’s internal user store.

Here are the details of my approach:

  1. Data Source: User data is stored in an SQL Server database.
  2. Synchronization: I need to sync the users between the SQL Server database and Keycloak, ensuring data consistency.
  3. Custom Storage: I am looking to implement a custom storage provider in Keycloak that will handle this sync process.

If anyone has experience with this or can provide guidance on how to approach creating a custom user storage provider for Keycloak, I would really appreciate your help.

Thank you in advance!

2

There are several examples out there available. Giyf!
E.g. keycloak-quickstarts/extension/user-storage-jpa at main · keycloak/keycloak-quickstarts · GitHub