I'm trying to create an AWS Glue connection to MS SQL Server on an EC2 Instancce.

I selected "Microsoft SQL Server" under "Choose Data Source".

I have users and security groups etc. prepared and I know what JDBC URL to use. The problem is that AWS won't let enter a JDBC url, it seems to expect me to select from a predefined list, but the list is empty. "No JDBC URLs available".

How can I enter the JDBC url?

I'm trying to create an AWS Glue connection to MS SQL Server on an EC2 Instancce.

I selected "Microsoft SQL Server" under "Choose Data Source".

I have users and security groups etc. prepared and I know what JDBC URL to use. The problem is that AWS won't let enter a JDBC url, it seems to expect me to select from a predefined list, but the list is empty. "No JDBC URLs available".

How can I enter the JDBC url?

• aws-glue

1 Answer 1

The Microsoft SQL Server data source is for those databases you have provisioned in AWS RDS.

Since you are running Microsoft SQL Server in EC2 use the JDBC datasource when setting up your glue connection. That will allow you to enter JDBC URL