I am exploring AWS Glue connections. I have successfully connected Glue to our EC2 hosted Microsoft SQL Server (in a VPC).
We also use a 3rd party Azure-hosted SQL Server that uses "Azure Active Directory - Password" authentication mechanism. Unfortunately, it does not seem like specifying the "authentication" attribute to the JDBC connection URL is supported in AWS Glue.
jdbc:sqlserver://mydbserver.database.windows.net:1433;DATABASE=MyDBName;authentication=ActiveDirectoryPassword
When I test the connection, I get this error:
"JDBC connection URL jdbc:sqlserver://mydbserver.database.windows.net:1433;DATABASE=MyDBName;authentication=ActiveDirectoryPassword is not supported. Check the Developer Guide for the list of supported data stores / URL formatting."
I have also tried to download the latest MS JDBC driver (to ensure the driver version SHOULD support the authentication attribute) for SQL Server and specify it as the JDBC driver to use, but I get the same exact error.
Can anyone confirm that we cannot use Azure Active Directory - Password to connect to SQL Server on Azure? Or how use the authentication mechanism?
Thank you
AWS OFFICIALUpdated 3 years ago
Thank you so much for the clear answer. Can't say that I am not disappointed as this means Glue might not work for our needs, but again thank you for the clear answer.
Does this only pertain to Azure AD authentication or to Active directory authentication as well.