Flat File Connector: Creating Lookups

The lookups given here are needed for the ICF flat file connector demo. To create, modify, or delete a lookup, use design console and navigate to the Lookup Definition under Administration.

Main Configuration Lookup
This lookup contains information regarding the connector bundle like name, version, and connector name This lookup is used by the ICF to load the connector at run time.

Lookup Name: Lookup.FF.Configuration
Lookup Type 
Group: FF

Code Key	Decode	Description
Bundle Name	org.identityconnectors.flatfile	Bundle name which contains the connector SPI implementation
Bundle Version	1.0	Bundle version
Connector Name	org.identityconnectors.flatfileconnector.FlatFileConnector	Fully qualified name of the connector implementation
User Configuration Lookup	Lookup.FF.UM.Configuration	User configuration lookup containing the information about the provisioning attribute map and reconciliation attribute map

User Configuration Lookup
This lookup contains the information about the provisioning attribute map and reconciliation attribute map lookups to be used for the connector.

Lookup Name: Lookup.FF.UM.Configuration
Lookup Type
Group: FF

Code Key	Decode	Description
Provisioning Attribute Map	Lookup.FF.UM.ProvAttrMap	Contains mapping of OIM fields with the target fields and is used during provisioning operation.
Recon Attribute Map	Lookup.FF.UM.ReconAttrMap	Contains mapping of OIM object fields with the target fields and is used during reconciliation operation.

Provisioning Attribute Map Lookup
This lookup is used by the ICF OIM glue during provisioning operations. This contains mapping between OIM attributes with target attributes.

Lookup Name: Lookup.FF.UM.ProvAttrMap
Lookup Type
Group: FF

Code Key	Decode	Description
ReturnValue	__UID__	UID returned by ICF
AccountID	AccountId	Account ID as represented in flat file
FirstName	firstName	First name as represented in flat file
LastName	lastName	Last Name as represented in flat file
Email	email	Email as represented in flat file
UD_FLAT_CH~Roles	Role	Role as represented in flat file

General Rule for Single-valued Attributes: 
For Code Key use the field label on the Flat File parent process form.
For Decode use the name of the attribute on the target system. __UID__ is a special case handled by ICF.

General Rule for Multi-valued Attributes:
Code Key = <CHILD_TABLE_FORM>~<CHILD_FIELD_LABEL>
Decode = <TARGET_ATTRIBUTE>

Roles Lookup for Child Form
The values defined in this lookup would be used by the flat file child form. A scheduled task is created to populate this lookup.

Lookup Name: Lookup.FF.Roles
Lookup Type
Group: FF

Reconciliation Attribute Map Lookup
This section includes steps to creating the reconciliation attribute map. This map is referred by the OIM ICF glue during reconciliation.

Code: Lookup.FF.UM.ReconAttrMap
Lookup Type
Group: FF

Code Key	Decode
AccountId	AccountId
FirstName	firstName
LastName	lastName
Email	email
Roles~Roles	Role

General Rule for Single-valued Attributes: 
Code Key = <Recon Field Name>
Decode = <Target Attribute Name>

General Rule for Multi-valued Attributes:
Code Key = <Recon Multivalued Map Name>~<Recon Field Name>
Decode = <Target Attribute Name>

The reconciliation fields are defined in the reconciliation profile of the flat file resource object. In design console, navigate to Resource Management -> Resource Object and then search for FLATFILERESOURCE and click Object Reconciliation to view to reconciliation profile.