After you purchase and activate the connector, you can proceed with creating a SharePoint connection in AWS Glue Studio.

Take the following steps to create a SharePoint connection in AWS Glue Studio.

  1. Sign in to the AWS Glue Console.
  2. Click AWS Glue Studio
  3. Click Connectors from the left-hand navigation menu. from the left-hand navigation menu.
  4. Under Your connectors, select the SharePoint connector.
  5. Click Create connection to open the Create connection page.
  6. Enter a name and description for your connection.
  7. In Connection access, select a JDBC URL format for your connection. oauth_refresh_token_grant is currently the only supported format.

    Step result:

    The JDBC URL template pane populates with the oauth_refresh_token_grant template.

    jdbc:ddcloud:sharepoint:ServiceUrl=${ServiceUrl};ClientId=${ClientId};
   TokenUri=${TokenUri};ClientSecret=${ClientSecret};RefreshToken=${RefreshToken}
  8. Under Data source credentials, select Use a secret. Then, from the Secret drop-down menu, select the name of the secret used to store credential information in AWS Secrets Manager.
    Note: For details, see Storing your credentials in AWS Secrets Manager.
  9. Under Additional URL parameters, provide additional key-value pairs to be used in the JDBC URL.

    See the following topics for additional information on supported properties.

    Step result:

    The JDBC URL result pane will populate with the key-value pairs you have specified.

  10. Click Create connection to create a connection to your SharePoint data source.
    Note: Network options do not apply when connecting to SaaS data sources.

Results:

Once the connection is created, the Connector page appears, showing both the available connectors and your connections. A green informational banner at the top lists the name of the recently created connection.

What to do next:

See Creating and running an ETL job in AWS Glue descriptions.