CODEWITHSUNDEEP
aws-glue
Vercinegetorix
Vercinegetorix

Reputation: 109

AWS Glue Create Connection to MS SQL Server

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".

Create AWS Glue Connector Screenshot

How can I enter the JDBC url?

Upvotes: 0

Views: 13

Answers (1)

Tim Mylott
Tim Mylott

Reputation: 2723

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

Datasource

Connection Setup

Upvotes: 0

Related Questions