Alfresco to SharePoint Online 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 Alfresco repository into your SharePoint Online system. We will be using the CMIS connection to access our Alfresco repository. For more detail on getting content from Alfresco see the TCS Section of the Alfresco Connector Documentation

Step 1. Set up your Alfresco CMIS Authentication Connection.

This will allow Simflofy to connect to your Alfresco Repository through CMIS.

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 CMIS
   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 2. Set up your SharePoint Online Authentication Connection.

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

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 SharePoint REST Demo Authentication Connection
   2. Select the connection type which for this example will be SharePoint REST Auth Connector
4. Next edit your new SharePoint REST Authentication Connection with the following input.
   1. Give your connection a description. Example SharePoint REST Demo Authentication Connection
   2. Enter your Username and Password for this connection
   3. Enter your SharePoint Online Service URL.
      Example: https://simflofy.sharepoint.com

Step 3. Set up Alfresco 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 SharePoint Online 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 SharePoint Online 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 SharePoint REST Demo Migration Connection
   2. Give your connection a description.
      Example: SharePoint REST Demo Migration Connection
   3. Chose the Alfresco Authentication Connection we created in Step 2. SharePoint REST Demo Authentication Connection
   4. 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 Alfresco repository into your SharePoint Online system.

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 Alfresco(CMIS) to SharePoint Online
   2. For Repository Connection select the Alfresco CMIS Integration connection we created in Step 3 from the drop-down. Alfresco CMIS
   3. For Output Connection select the SharePoint Online Connection we created in Step 4 from the drop-down. SharePoint REST Demo Migration Connection
   4. Leave the other fields as is and click save to continue setting up this new integration job.
4. In the Tasks Tab we will be adding the Default Date Based Folder Path Task.
   1. Select Date Based Folder Path Task from the dropdown. You can begin typing the task name in the search field to filter the task list
   2. Click the plus button to add the task to this job. This wil open an edit task properties form.
   3. Leave the fields as is
   4. Click Done to close the edit properties form.
5. In the Mappings Tab we will map two fields. Document and Title
   1. Enter the following mapping for Document
      1. Source: cmis:document
      2. Target: Document
      3. Type: String
      4. Click Add New Mapping and Select Type Mapping from the drop-down
   2. Create the following mapping for Title
      1. Source: '#{rd.path}’
      2. Target: Title
      3. Type: String
      4. Click Add New Mapping and Select Calculated 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 SharePoint REST Demo Migration Connection tab is where you will enter any additional settings needed to use SharePoint Online as your Output integration connection under the Server Tab.
   1. In the Output Specification Tab
      1. Enter your Site Name. Example: sites/ParksandRecreation
      2. Enter your Output Folder Path: Example: outputDemo3
   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 SharePoint Online system.

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. Alfresco(CMIS) to SharePoint Online
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 Alfresco Server into your SharePoint Online system!