By using the management agent for delimited text files, you can synchronize data that is contained in delimited text files.
The following Microsoft Identity Integration Server 2003 versions support this management agent:
This is a
The schema is generated based on the discovery of the data in the template input file. When you refresh the schema for this management agent, Management Agent Designer starts, reads the template input file, and then updates the management agent schema. Then, you can update the management agent configuration based on the new schema. You cannot edit the schema for delimited text files.
The delimited text file format consists of one record per line, with each record appearing as a series of attributes that are separated by a character such as a comma, a tab, or a user-specified character. You can specify the first row in the delimited text file as header names. Make sure that all multivalued attributes and their header names are in sequential order. You can use a text qualifier (that is, either a single or double quotation mark) to enclose text in a single attribute. The following is an example of a delimited text file format:
1,"Cust,1",Jeff,Smith,12 Broad Street,San Francisco,CA,11700
2,Cust2,Chris,Preston,34 State Street,Anchorage,AK,21002
For delimited file formats, multivalued attributes and their header names must be in sequential order. A delimited field with any attribute cannot appear between delimited fields that compose a single multivalued attribute. The following is an example of a valid delimited file format containing a single multivalued attribute (Phone), composed of two delimited fields (Phone, Phone).
The following is an example of an invalid delimited file format containing a multivalued attribute (Phone). The LastName delimited field appears between two delimited fields, (Phone) and (Phone), that make a single multivalued attribute (Phone).
Configuring management agents
Create a management agent
Select a template input file
Confirm delimited text file format
Map object types
Define object types
Configure connector filter rules
Configure join and projection rules
Configure attribute flow rules
Configure deprovisioning rules
Configure password management and specify rules extensions