Configuring and Performing Lookup Field Synchronization

You can configure and perform lookup field synchronization to use lookup definitions as the input source for some of the fields on the process form during provisioning operations.

Perfotm the following steps:

  1. Generate the connector. This involves configuring the DBATConfiguration.groovy file and running the DBAT Generator to discover the schema and generate the connector. See Generating the Database Application Tables Connector for detailed information about connector generation.

    Note:

    While configuring the DBATConfiguration.groovy file, ensure you have specified a value for the changeLogColumn property. Otherwise, the scheduled job used to perform an incremental reconciliation run is not created.
  2. Install the generated connector. See Overview of Installing DBAT Connector for detailed information about installing the generated connector.
  3. Create the IT resource for your target system. See Configuring the IT Resource for the Target System for more information.
  4. Ensure you have empty lookup definitions such as Lookup.RESOURCE.Example to store values from child tables in your target system.
  5. Update the form and lookup definition to include information that specifies the field is a lookup field. See Using Lookup Definitions for more information.
  6. Run the RESOURCETarget Lookup Reconciliation scheduled job to perform lookup field synchronization. See Scheduled Job for Lookup Field Synchronization for more information about this scheduled job.