Well First Let me explain what does it mean by Promotion and Demotion
- Promotion – It means that you capture the value present in the document (*.xml or wordML or you can write your own document parser) and expose it to the SharePoint document library as a Column. What you get out of it is that you have a synchronization of the Data between the document and Column of the doc library. (When you update the document it gets automatically reflected in the document library and vise versa.)
- Demotion – It means the opposite. You capture the column of the Document Library and display it in the Document.
Well whenever you publish a InfoPath form to the SharePoint server using File->Publish, at the end of the Wizard you will be provided
with a Option that will allow you to the add the field of the InfoPath to the document. How can do that when I automation the publishing of the InfoPath using features or When I publish the form using Central Administration Website?. There is an option in InfoPath, where you can specify the fields to be promoted to the Document Library at the design time. Use Tools->Form Option -> Property Promotion
After going through this article, I got to know the power of Universal Data Connection UDC files in the InfoPath forms and how it helps during multiple deployment and migration scenarios. But what I missed to note is How do I get a Data Connection File from the Central Administration Site – > Manage Data Connection. This article describes how to do that. Also below I have highlighted the points that you need to get a file from Data Connection File from the Central Administration. (Managing the Data Connection Files centrally) with few quick screen clips that will help you.
Let’s assume that you have created an InfoPath form as per this article. To recap you have added the data connection from the Data Connection Library of your SharePoint site, while doing so you will find an option called Connection Options. Click on the Connection Options and Select the option centrally managed connection Library, by this what you mean is that you are asking the Form template to get the connection file from the Centrally Managed Connection Files from Central admin.
From now on your InfoPath form template will get the Connection Setting from the UDC File of the Central Admin. In case if you want to make any changes to the connection setting all you have to do is to change the Connection File present in the Central Administration Server.