Management Agent Configuration – Part 4: Delimited Text File Management Agent


This is Part 4 in a series of commonly used management agents. In Part 1 we looked at configuration of an Active Directory Management Agent (ADMA); in Part 2 we looked at the configuration of the FIM Service Management Agent (FIMMA), and in Part 3 we looked at the configuration of a Microsoft SQL Management Agent (SQLMA). With this post, we’ll take a look at delimited text file management agents.


As before, to begin navigate to your Synchronization server.

clip_image002


From here, click “Create”. Using the “Management agent for:” drop down menu, select “Delimited text file”. Enter a name, then click “Next”.

clip_image004


It is necessary to input a “template” file so that FIM may know the formatting. It is perfectly acceptable here to use the actual user data containing file as the template. To locate it, click “Browse”.

clip_image006


Select the text file you wish to use and click “Open”, then click “Next” to continue.

clip_image008


If your input text file has a header row (such as the below example), place a check in the box next to “Use first row for header names”. Select the delimiter type and text qualifier. In this scenario, we are delimiting with commas and using an apostrophe as a qualifier. Click “Next” to continue.

clip_image010


Here we should see all the attributes being read in from the file. If any of these are multi-valued and need to be changed, select “Edit”. Also, under “Configure special attributes”, select “Set Anchor…”

clip_image012


This will display the “Set Anchor” dialogue. Select an anchor attribute from the left-hand list and click “Add”. Note that an anchor attribute must be present and unique on each side (i.e. text file as well as inside FIM). Once selected, click “OK”.

clip_image014


For “Define Object Types”, we may leave these default. Click “Next” to continue.

clip_image016


For “Configure Connector Filter”, we will leave these default. Click “Next” to continue.

clip_image018


For “Configure Join and Projection Rules”, you may wish to include join logic. If so, click “New Join Rule..”

clip_image020


In this scenario, I am creating a “Direct” join mapping of “PoliticianID” to “PoliticianID”. This is because I know (in this environment) it is unique for every user object. Click on “Add Condition” and then click “OK”. Click “Next” to continue.

clip_image022


For “Configure Attribute Flow”, we will leave this default. By doing so, we will pull all available attributes from the source file into FIM and then manipulate them there (based on workflows, sets and synchronization rules). Click “Next” to continue.

clip_image024


For “Configure Deprovisioning”, we may leave this default or select another option based on your environment. Click “Next” to continue.

clip_image026

For an explanation of these options, please see this post for disconnections, this post for explicit disconnections and this post for deletions.


Click “Finish” to complete.

clip_image028


We should now see our newly created management agent.

clip_image030





Questions? Comments? Love FIM/MIM so much you can’t even stand it?

EMAIL US!

>WE WANT TO HEAR FROM YOU<

## https://blogs.msdn.microsoft.com/connector_space##

Comments (2)

  1. @shashidhar can you detail the error a bit more? does the file have a header row? what character are you using to delimit your values?

  2. shashidhar says:

    i am facing configuration file error, when tries to create run profile for delimited text file connector

Skip to main content