Creating a Azure SQL connection

To configure a connection to Azure SQL:

1. In AWS Secrets Manager, create a secret using your Azure SQL credentials. To create a secret in Secrets Manager, follow the tutorial available in Create an AWS Secrets Manager secret in the AWS Secrets Manager documentation. After creating the secret, keep the Secret name, secretName for the next step.

   • When selecting Key/value pairs, create a pair for the key user with the value azuresqlUsername.

   • When selecting Key/value pairs, create a pair for the key password with the value azuresqlPassword.

2. In the AWS Glue console, create a connection by following the steps in Adding an AWS Glue connection. After creating the connection, keep the connection name, connectionName, for future use in AWS Glue.

   • When selecting a Connection type, select Azure SQL.

   • When providing Azure SQL URL, provide a JDBC endpoint URL.

     The URL must be in the following format: jdbc:sqlserver://databaseServerName:databasePort;databaseName=azuresqlDBname;.

     AWS Glue requires the following URL properties:

     • databaseName – A default database in Azure SQL to connect to.

     For more information about JDBC URLs for Azure SQL Managed Instances, see the Microsoft documentation.

   • When selecting an AWS Secret, provide secretName.