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

Take the following steps to create a Salesforce 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 Salesforce 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.
    • username_password
    • username_password_securitytoken

    Step result: The JDBC URL template pane populates with the corresponding JDBC URL template.

    username_password template

    jdbc:ddcloud:sforce:user=${Username};Password=${Password}

    username_password_securitytoken template

    jdbc:ddcloud:sforce:user=${Username};Password=${Password};SecurityToken=${SecurityToken}
  8. Under Data source credentials, provide your data source credentials. Choose from one of the following.
    • Select Enter username and password. Then enter username and password in the fields provided.
    • 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.
  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 Salesforce 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.