Replication - User and group import - JDBC

Click here to find out how to configure a JDBC source for user and group import. Carry out the steps described there and then continue reading here.

After you have selected "JDBC" as the connection in the previous dialogs and assigned a name for it, you can now enter the connection data.

JDBC connection

Here you can enter the required JDBC driver, the JDBC URL, user and password directly or with

Click on "Wizard" to start a wizard that guides you through the configuration of the connection.

Import settings - Profile

Profiles are stored in the portal directory "internal/replication_profiles/jdbc" as XML files.

There you will also find the file "sample.xml", which serves as a sample profile for the import of an Intrexx user administration. You can change this file as required. The "Sample" entry must be selected in the "Profile" selection list in the "JDBC connection" dialog.

From Intrexx version 12.0.0

There you will also find the files

• sample_intrexx_current_postgresql.xml (PostgreSQL databases)

• sample_intrexx_current_generic.xml (other databases)

• sample_intrexx_historic.xml (older versions)

which are used as sample profiles for the import of an Intrexx user administration. You can change these files as required. To do this, select the corresponding entry in the "Profile" selection list and open the profile file in a standard editor. Adjust the SQL queries and field mappings accordingly. The functions ($...()) contained in Intrexx that can be used in the assignments correspond to those of the LDAP replication.

Click "Next".

If all entries are correct, a dialog will appear in which the import settings can be configured. You can find all the information here.

You then have the option of setting the schedule for automatic execution. You can find all the information here.

In the last step, the replication job can also be started immediately if desired. You can find all the information here.