SparePoint Online to Alfresco Integration Tutorial

Overview

In this tutorial we will walk through how to set up a job in Simflofy that will migrate the content from your SharePoint Online repository into your Alfresco system. We will be using the CMIS connection to access our SharePoint Online repository. For more detail on how to get content into Alfresco see the TCS: FAQS Section of the Alfresco Connector Documentation

Step 1. Set up your SharePoint Online Repository Authentication Connection.

This will allow Simflofy to connect to your SharePoint Online Repository through CMIS.

To set up your SharePoint Online Authentication Connection

1. Select Authentication from the Connections section of the navigation menu.
2. At the bottom of the Authentication Connections page select the "Create New Auth Connection" button.
3. In the new Auth Connection form
   1. Name your connection. In this example we will use “Alfresco Demo CMIS”
   2. Select the connection type which for this example will be "CMIS Authentication Connector"
4. Next edit your new CMIS Authentication Connection with the following input.
   1. Give your connection a description. Example "CMIS Authentication"
   2. Enter the Username and Password for this connection
   3. Enter the CMIS URL. Example:
      http://18.205.245.254:8080/alfresco/api/-default-/public/cmis/versions/1.1/atom
   4. For Binding select atom from the dropdown
   5. Under repository ID enter -default-
   6. And for vendor select no vendor

Step 2. Set up your Alfresco Authentication Connection.

This will allow Simflofy to connect to your Alfresco Repository.

To set up your Alfresco Authentication Connection:

1. At the bottom of the Authentication Connections page select the Create New Auth Connection button.
2. In the new Auth Connection form
   1. Name your connection. In this example we will use Alfresco Demo Authentication (Simflofy)
   2. Select the connection type. In this case we will use Alfresco Webscript Auth Connector
   3. In the next page we will edit your new Alfresco authentication connection
      1. Enter the username and password for this connection
      2. Enter the URL for your Alfresco server. Example: http://18.205.245.254:8080/alfresco/service

Step 3. Set up SharePoint CMIS as your Repository Integration Connection.

Using this connection Simflofy will generate a query, or use one provided, to retrieve unique ids for documents.

To set up your SharePoint CMIS Integration Connection:

1. Select Integration from the Connections section of the navigation menu.
2. At the bottom of the Integration Connections page click the Create Integration Connection button.
3. In the New Integration Form
   1. Name your integration connection. In this example we will use the name Alfresco CMIS
   2. For the connection type choose CMIS Connector from the drop-down list. You can also begin typing Box in the search field to filter the drop-down list and then select it.
   3. Click save to edit this new integration connection
4. In the Edit Connection: Alfresco CMIS page enter the following
   1. Give your connection a description. Example: Alfresco CMIS Demo
   2. Choose the Authentication Connection you created in Step 1 from the dropdown. Alfresco Demo CMIS
   3. Leave the rest of the fields as is and click save to lock in your changes and return to the Integration Connections page

Step 4. Set up Alfresco as your Output Integration Connection

In Output mode, connectors push content and metadata. Many of them can also build version series' from the source systems.

To set up your Alfresco Integration Connection:

1. At the bottom of the Integration Connections page click the Create Integration Connection button.
2. In the New Integration Form
   1. Name your integration connection. Here we will use the name Alfresco Batch Output (Simflofy)
   2. Chose the Alfresco Authentication Connection we created in Step 2. Alfresco Demo Authentication (Simflofy)
   3. Leave the rest of the fields as is and click Save to finish creating this connection and return to the Integration Connections page.

Step 5. Set up your integration job.

This will migrate the files in your SharePoint Online repository into your Alfresco Server.

To set up your integration job:

1. Select List Jobs from the Integration section of the navigation menu
2. At the bottom of the JOBS page click the button Create New Job
3. In the Create New Job Form
   1. Give your new job a name. For this example we will use SharePoint Online to Alfresco (Simflofy)
   2. For Repository Connection select the SharePoint CMIS Integration connection we created in Step 3 from the drop-down. Alfresco CMIS
   3. For Output Connection select the Alfresco Connection we created in Step 4 from the drop-down. Alfresco Batch Output (Simflofy)
   4. Leave the other fields as is and click save to continue setting up this new integration job.
4. In the Mappings Tab we will map three fields. Last Modification Date, Document and Folder
5. Enter the Following mapping for Last Modification Date
   1. Source: cmis:lastModificationDate
   2. Target: cmis:lastModificationDate
   3. Type: Date Time
   4. Click add new mapping and Select Field Mapping from the drop-down
   5. Enter the following mapping for Document
      1. Source: cmis:document
      2. Target: cmis:document
      3. Type: String
      4. Click add new mapping and Select Field Mapping from the drop-down
   6. Create the following mapping for Folder
      1. Source: cmis:folder
      2. Target: Title
      3. Type: String
      4. Click add new mapping and Select Calculate Field from the drop-down
6. The Alfresco CMIS tab is where you will add any necessary configurations for the CMIS Integration connection you are using as the repository.
   1. In the CMIS Query Config Tab enter your CMIS Query. Example: select * from cmis:folder d where in_tree('workspace://SpacesStore/906c9b9b-7418-43b7-973c-634f87434a3f') (add how to find)
   2. Leave all other fields as is
7. The Alfresco Batch Output (Simflofy) tab is where you will enter any additional settings needed to use Alfresco as your Output integration connection under the Server Tab.
   1. In the Configuration Tab enter your Alfresco Path. Example: /Sites/my-stuff/documentLibrary/test-output
   2. Leave all other fields as is
8. Click Save to save your job configurations and return to the Jobs page

Step 6. Run and Monitor the job

This step will migrate the chosen content from your CMIS repository to your Alfresco server.

To run and monitor this job:

1. Select Run and Monitor Jobs from the Integration section of the navigation menu
2. Find the job created in Step 5. SharePoint Online to Alfresco (Simflofy)
3. Select the triangle next to the job to run this Integration job.

Depending on how many files you have stored this could take more than a few minutes. To monitor the progress of this integration you can click the refresh button at the top of the page. You can also set Simflofy to automatically refresh every 30 seconds, every minute, or every 5 minutes.

Once the integration is complete the status will change to green and state Complete.

Congratulations! You have successfully integrated your SharePoint Online content into your Alfresco server!