The JDBC Connector enables Strivacity to synchronize identities from relational databases using JDBC. It runs as part of the Directory Connector and communicates with Strivacity while maintaining connectivity to your database.

Unlike the LDAP Connector, the JDBC Connector retrieves identity data by executing SQL queries configured in an inbound connection. The connector periodically retrieves its configuration from Strivacity, executes the configured queries against the target database, and reports synchronization status and statistics.

Before you begin

Before configuring the JDBC Connector, ensure that:

• An identity store has been created in Strivacity.
• You have the identity store's Client ID and Client secret.
• The Directory Connector is installed and running.
• You have a JDBC driver for your database.

Configure the connector

Configure the Directory Connector to operate in JDBC mode and connect to your Strivacity tenant.

Configure connector authentication

The connector authenticates to Strivacity using the Identity Store credentials.

1. In the Admin Console, navigate to Identities and Identity stores.
2. Select an identity store.
3. Under the Configuration tab, navigate to Directory Connector settings.
4. Copy the Client ID.
5. Copy the Client secret.
6. Configure these values in the connector.

Configure the operation mode

Configure the connector to operate in JDBC mode.

datastoreType: jdbc_aggregation

Configure scheduling

The connector periodically retrieves configuration updates from Strivacity and sends heartbeat information.

connector:
  inboundJdbc:
    scheduling:
      heartbeatInitialDelay: 5s
      heartbeatInterval: 30s

Configure retry behavior

Configure how the connector retries failed requests after receiving an HTTP 4xx response from Strivacity.

connector:
  inboundJdbc:
    failureAttemptCycleCount4xx: 3

Configure Redis

Configure the Redis settings used by the connector.

spring:
  data:
    redis:{redis_configuration}

For information about Redis configuration, see the Spring Data Redis documentation.

Install JDBC drivers

The connector requires a JDBC driver for each database that it connects to.

1. Obtain the required JDBC drivers for your database connections.
2. Mount the directory containing the JDBC drivers to the connector Docker container under the /workspace/BOOT-INF/lib/ path.
3. During startup, the connector loads the available JDBC drivers from the mounted directory.

Configure an inbound connection

After the connector has been configured, create an inbound connection in Strivacity.

The inbound connection defines:

• the JDBC connection URL
• authentication credentials
• synchronization schedule
• SQL queries
• identity correlation
• attribute mappings
• synchronization behavior

For detailed instructions, see Inbound connection.

Verifying the connection

After configuring the connector and the inbound connection:

1. Start the connector.
2. Verify that the connector successfully authenticates with Strivacity.
3. Verify that the inbound connection configuration is retrieved.
4. Run an initial synchronization using a small data set.
5. Confirm that identities are imported successfully.