self-hosted integration from sharepoint to synapse

Nick Wong 170

Hello,

I successfully connect my synapse to file system by setting up self-hosted integration. However, previous I would like to connect my sharepoint to synapse but it keeps on having this error.

User's image

We investigated, was wondering if we also need self-hosted on premise integration set up between sharepoint and synapse, if it is, how do the operator of the sharepoint application place the authenicated key generated by Synpase, any document I could read through? or just need to run them via powershell?

Kind regards

Nick

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-15T18:29:16.7066667+00:00
Hello Nick Wong,

Sharepoint online supports the below two integration run times.

Azure integration runtime

Self-hosted integration runtime

Please see this Prerequisites: https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory#prerequisites

Can you please follow the steps mentioned in the document to create a linked service for SharePoint. If not, I would recommend following the steps mentioned in the document to create a linked service for SharePoint in Synapse.

To authenticate the self-hosted integration runtime, you can generate an authentication key and use it to register the integration runtime agent on the machine where you installed the self-hosted integration runtime

Doc: https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory#configure-a-self-hosted-ir-via-ui

Reference document:

https://learn.microsoft.com/en-us/azure/data-factory/connector-sharepoint-online-list?tabs=data-factory

I hope this helps. Please let me know if you have any further questions.
Nick Wong 170 Reputation points

2024-05-16T08:29:27.2633333+00:00

I understand this part but on the sharepoint side, they have to config (fill in) this authenication key, do they have somewhere on the sharepoint side to config?
Nick Wong 170 Reputation points

2024-05-17T07:37:36.1233333+00:00

Oh this is the one we tried initially, but we keep on having the error code 2200

There isnt any firewall issue as far as we know, they said this is the solution but how are we going to resolve?

Kind regards

Nick
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-17T17:01:16.0133333+00:00

Did you test the sharepointonline linked service connection? If you are getting any error, could you please share the detailed error meessage?
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-21T20:30:33.79+00:00

I am checking to see if you had a chance to look into my above response.

1 answer

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-16T19:25:13.0133333+00:00

Hello Nick Wong,

When it comes to integrating SharePoint with Azure Synapse, you would use a service principal for Azure resources, and the service principal's ID and secret are used in the linked service configuration for SharePoint.

This configuration is not done directly in SharePoint but rather in the Azure Synapse workspace where you set up the linked service to connect to SharePoint.

Please see the below sceeenshot for your reference.

If you need to configure the authentication key for the App ID(which is used for integration with Azure services like Synapse) you would do it in the Azure portal.

https://learn.microsoft.com/en-us/sharepoint/dev/solution-guidance/security-apponly-azuread

I hope this answer your question.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

self-hosted integration from sharepoint to synapse

1 answer

Your answer