You can create a synchronization task to read data from a Microsoft SharePoint source and write data to the Microsoft SharePoint target.
•You need to create a Microsoft SharePoint connection before you configure the synchronization task.
•You can upload attachments to the doc library only when you are using the Sharepoint 2013 version.
•When you upgrade from Sharepoint 2013 and run an existing mapping, you need to refresh the existing mapping and the fields for the task to run successfully.
•Ensure that the Microsoft Sharepoint document library path from where you want to read or write data does not contain special characters. When you import the objects, the data preview fails to display the objects.
1In Data Integration, click New > Tasks.
2Select Synchronization Task, and click Create.
The Definition tab appears.
3Configure the following fields on the Definition tab:
Field
Description
Task Name
Name of the synchronization task.
Description
Description of the synchronization task.
Maximum length is 255 characters.
Task Operation
Select the task operation that you want to perform.
4Click Next.
The Source tab appears.
5Specify the source Connection and Source Object to be used for the task.
6Click Next.
The Target tab appears.
7Select the target Connection and Target Object required for the task.
8Click Next.
The Data Filters tab appears.
9Select the filter object, filter field, and filter operator to create a data filter on the Data Filters page.
10Click Next.
The Field Mapping tab appears.
11Click Automatch on the Field Mapping tab to map source fields to target fields accordingly.
When you insert data in the document library object, you must specify the Name, Body, BodyLength, and ContentType fields.
- When you select Source connection as Salesforce or any database and Target connection as Microsoft SharePoint, in the field mapping: Edit Body function and then add DEC_BASE64 expression to map the body. You need to ensure that “BodyLength” is mapped.
- When you select Source connection as Microsoft SharePoint and Target connection as Salesforce or any database, in the field mapping: Edit Body function and then add ENC_BASE64 expression to map the body. You need to ensure that “BodyLength” is mapped.
- To add or edit expression in Field Mapping, click fx.
12Click Validate Mapping to validate the mapping.
13Click Next.
The Schedule tab appears where you can schedule the task for each requirement and save.
14Configure the advanced source properties on the Schedule tab.
15Click Save > Finish.
16Select the synchronization task from the Explore page and click Actions > Run.
In the Monitor, you can monitor the status of the logs after you run the task.