Database syncer

The database syncer connects to an external database and syncs user data into Casdoor. A demo users table can be imported from the template XLSX.

Create a syncer

Go to Syncers and create a new syncer with the following. Save when done.

Tipp

Fill at least ID and Name in the Casdoor column mapping. Other useful fields include createdTime, Password, and DisplayName.

Erforderliche Felder

Feld	Beschreibung
Organisation	Organization to import users into.
Bezeichnung	Syncer name.
Typ	database.
Host, Port, User, Password	Source database connection.
Datenbanktyp	MySQL, PostgreSQL, SQL Server, Oracle, or SQLite (Xorm-supported).
Datenbank	Source database name.
Tabelle	Source user table name.
Tabellenspalten	Column name (source), Column type (source), Casdoor Column (Casdoor user field).

Optionale Felder

Feld	Beschreibung
ist gehasht	If enabled, sync runs only when fields included in the hash change; other field-only changes do not trigger sync.
Ist Schlüssel	Marks the primary key used to match source and Casdoor users. At least one column must be key; if none is set, the first is used.
Avatar-Basis-URL	If set and source user.avatar does not start with http, Casdoor stores Avatar base URL + user.avatar.
Zuordnungstabelle	Table used to sync user affiliation. Int codes can be mapped to names; see getAffiliationMap() and syncer_util (e.g. score for int→string mapping).

Enable Is enable and save; the syncer will run. You can also trigger a sync with the Sync button.

Aktualisieren

With Table columns configured for key mapping, differences on the key between source and Casdoor trigger updates:

• Update in source table — changes sync to Casdoor.

• Update in Casdoor — changes sync back to source.

Hinzufügen

When row counts differ, the syncer adds rows to the table with fewer rows, using the key to match:

• Add user in source table:

• Add user in Casdoor table: