Alfresco to SharePoint Online Integration Tutorial

In this tutorial we will walk through how to set up a job in 3Sixty 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

This will allow 3Sixty 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 Online”

    2. Select the connection type which for this example will be “SharePoint REST Authentication Connection”

    3. Next edit your new SharePoint Authentication Connection with the following input.

    4. Give your connection a description. Example “SPO Repository”

    5. Enter the Username and Password for this connection as well as the tent url for your SharePoint. The tenant url should look like https://[tenant].sharepoint.com

      Example: https://3sixty.sharepoint.com

This will allow 3Sixty to connect to your Alfresco Repository through the CMIS protocol. For reading from Alfresco we will be using the CMIS connector.

To set up your Alfresco Authentication Connection:

  1. Select Authentication from the Connections section of the navigation menu.

    1. At the bottom of the Authentication Connections page select the "Create New Auth Connection" button.

  2. Fill out 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"

  3. 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 drop-down

    5. Under repository ID enter -default-

    6. And for vendor select no vendor

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

To set up your Alfresco CMIS Integration Connection:

Select Integration from the Connections section of the navigation menu.

  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. 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

  3. In the Edit Connection: Alfresco CMIS page enter the following

  4. Give your connection a description. Example: Alfresco CMIS Demo

  5. Choose the Authentication Connection you created in Step 1 from the drop-down. Alfresco Demo CMIS

  6. Leave the rest of the fields as is and click save to lock in your changes and return to the Integration Connections page

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 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 Output

    2. Chose the SharePoint Authentication Connection we created in Step 2.

    3. Leave the rest of the fields as is and click save to lock in your changes and return to the Integration Connections page

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 (3Sixty)

    2. For Repository Connection select the SharePoint 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 (3Sixty)

    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. 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'), The long hexadecimal string is the reference for the folder and can be found in the folder’s URL or metadata.

    2. Leave all other fields as is

  6. Then In the Output tab you can enter additional settings to control where data will be written in SharePoint

    1. Include the site you wish to write to. If its a tenant site, it should include “sites/“: https://3sixty.sharepoint.com/sites/accounts

    2. Include the list you wish to write to. Leave blank or default for Documents (Shared Documents in SharePoint)

    3. Include the output folder in the list. If left blank, 3Sixty will write to the root folder of whatever list is in use.

  7. Click Save to save your job configurations and return to the Jobs page

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 (3Sixty)

  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 3Sixty 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 content into your SharePoint server!

 

 

 

In this tutorial we will walk through how to set up a job in 3Sixty 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

This will allow 3Sixty to connect to your Alfresco Repository through CMIS.

  1. To set up your Alfresco Authentication Connection:

  2. At the bottom of the Authentication Connections page select the Create New Auth Connection button.

    1. In the New Auth Connection form

    2. Name your connection. In this example we will use Alfresco Demo CMIS

    3. Select the connection type. In this case we will use Alfresco Webscript Auth Connector

    4. 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

This will allow 3Sixty 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

Using this connection 3Sixty 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 drop-down. 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

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.

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 drop-down. 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 will 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

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 3Sixty 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!