Ident2JDBC_SyncAccountDel

Sync Workflow JDBC Accounts in state TBDEL

Ident2JDBC_SyncAccountDel processes accounts in state TBDEL in the Identity Store. It exports the relevant account identifiers with MetaCP and then passes them to JDBCImport, which deletes the corresponding accounts in the JDBC-connected database.

Ident2JDBC_SyncAccountDel is a companion sub-workflow of Ident_JDBC_Sync and is designed to run as part of that scheduled synchronization chain.

The workflows in this reference are delivered as factory data and are loaded into the Connectivity configuration database during the initial configuration. They are samples: use the Identity Manager to copy a workflow into your own scenario and adapt the copy. Do not change the delivered objects, because a product update can replace them.

At a Glance

Name

Ident2JDBC_SyncAccountDel

Category

Target Scheduled / JDBC

Technology

Tcl-based scheduled workflow

LDAP object class

dxmWorkflow

Workflow type

-

Connected system / controller type

-

Configuration wizard

LDAP-JDBC

Active in the factory data

not set

Factory data version

7.0

Factory data path

Workflows/Default/Target Scheduled/JDBC/Ident2JDBC_SyncAccountDel

Prerequisites

  • Configure JDBCImport for the JDBC-connected database.

  • Configure MetaCP for the target system subtree that contains the accounts marked with state TBDEL.

Workflow and Activities

Step Activity Description Agent Runs after

1

Ident2JDBC_SyncAccountDel_MetaCP

export accounts to be deleted in JDBC

MetaCP

start activity

2

Ident2JDBC_SyncAccountDel_JDBCImport

delete accounts in JDBC

JDBCAgent

Ident2JDBC_SyncAccountDel_MetaCP

Jobs and Agents

Activity Job Agent Operation Input channel Output channel

Ident2JDBC_SyncAccountDel_MetaCP

Ident2JDBC_SyncAccountDel_MetaCP

MetaCP

Full Export

Ident2JDBC_SyncAccountDel1

OutData

Ident2JDBC_SyncAccountDel_JDBCImport

Ident2JDBC_SyncAccountDel_JDBCImport

JDBCAgent

Full Import

InData

Ident2JDBC_SyncAccImport1

Configuration Parameters

Table 1. Parameters of job Ident2JDBC_SyncAccountDel_MetaCP
Parameter Default value

debug_trace

0

delta_mode

delta-or-full

delta_on

1

exact_action

FALSE

init_mode

REAL

max_trace_entries

10

min_source_entries

0

notify_not_ok

0

statistics

TRUE

test_mapping_only

FALSE

test_max_entries

10

trace_level

1

trace_recordcount

0

Table 2. Parameters of job Ident2JDBC_SyncAccountDel_JDBCImport
Parameter Default value

controller_tracelevel

9

delta_mode

full

delta_on

0

A Tcl-based workflow runs scheduled in the C++-based Server (IdS-C). Its activities run in the order defined by the dxmPredecessorActivity-DN chain, and each activity starts a job that runs one agent with one input and one output channel. Agents exchange their data through files or directly through the meta controller, so a typical workflow consists of an export activity that writes the data of the connected system and an import activity that maps and loads that data into the Identity Store.

You start these workflows manually from the Identity Manager or attach them to a schedule.

In this workflow, the C++-based Server runs these activities in sequence:

  1. Ident2JDBC_SyncAccountDel_MetaCP exports the accounts that are marked for deletion in the Identity Store.

  2. Ident2JDBC_SyncAccountDel_JDBCImport deletes the corresponding accounts in the JDBC-connected database.

If one activity fails, the workflow stops at that point and the remaining activities do not run.

Operation

  1. Start Ident2JDBC_SyncAccountDel directly or let Ident_JDBC_Sync call it as part of the full JDBC synchronization run.

  2. The workflow first selects the accounts that are already in state TBDEL and exports them with MetaCP.

  3. JDBCImport then consumes that export and removes the matching accounts from the JDBC-connected database.

  4. If the delete import fails, the workflow stops and the account remains in the Identity Store state that triggered the deletion attempt.

  5. A successful run removes the selected JDBC-side accounts that were flagged for deletion in the Identity Store.