JDBC

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

Now that you have selected "JDBC" as the connection type in the previous dialogs and assigned a name to it, you can enter the connection details.

JDBC Connection

Here you can enter the required JDBC driver, JDBC URL, username, and password directly, or use

Click "Wizards" to launch a wizard that will guide you through the connection setup.

Import Settings - Profile

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

There you will also find the "sample.xml" file, which serves as a sample profile for importing an Intrexx user management system. You can modify this file as needed. To do this, the "sample" entry must be selected in the "Profile" drop-down list in the "JDBC Connection" dialog box.

Starting with Intrexx version 12.0.0

You'll also find the files there

• 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 importing an Intrexx user management system. You can modify these files as needed. To do this, select the appropriate entry from the "Profile" drop-down list and open the profile file in a standard text editor. Adjust the SQL queries and field mappings accordingly. The functions available in Intrexx that can be used in assignments ($…()) correspond to those used in LDAP replication.

Click "Next."

If all the entries are correct, a dialog box will appear where you can configure the import settings. You can find all the information here.

You will then have the option to set the schedule for automatic execution. You can find all the information here.

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