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

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

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

    Step result:

    The JDBC URL template pane populates with the corresponding JDBC URL template.

    oauth_refresh_token_grant template

    jdbc:ddcloud:dynamics365:ServiceUrl=${ServiceUrl};ClientId=${ClientId};
   TokenUri=${TokenUri};ClientSecret=${ClientSecret};RefreshToken=${RefreshToken}

    oauth_client_credentials_grant template

    oauth_client_credentials_grant=jdbc:ddcloud:dynamics365:ServiceUrl=${ServiceUrl};
   ClientId=${ClientId};TokenUri=${TokenUri};ClientSecret=${ClientSecret};Scope=${Scope}
  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 Dynamics 365 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.