Before you can create a SharePoint connection in AWS Glue, you must obtain account credential information for your SharePoint data source. The SharePoint connector currently supports the OAuth 2.0 refresh token grant. Therefore, you must obtain the credentials for this grant type to connect to SharePoint. For an overview of required credential information, see Refresh token grant.

Important: Once you obtain the credential information for your data source, you must store this information as a secret in AWS Secrets Manager. The secret allows you to connect using an OAuth 2.0 grant. When creating a connection, you must specify the name of the secret you created to store your data source credential information. See Storing your credentials in AWS Secrets Manager.

If it is not already registered, you will need to register your application as an Azure Active Directory application to run an application against a SharePoint web instance. This process is detailed in Registering your application on the Azure portal.

To configure the driver for an OAuth 2.0 implementation, you will need client credentials and endpoints related to your registered application. See Obtaining application client information and endpoints for details.

You will need to use a third-party application such as Postman to obtain a refresh token. See Obtaining refresh token using Postman for details.