We found in documentation the following: AWS Glue can connect to the following data stores by using the JDBC protocol: • Amazon Redshift • Amazon Relational Database Service (MySQL, PostgreSQL, Aurora, and MariaDB) • Publicly accessible (Amazon Redshift, MySQL, PostgreSQL, Aurora, and MariaDB) databases
Is it possible to make a JDBC connection with SQL Server for data stores? I'm trying create to Crawler with data store in SQL Server.
Should I create new instance of SQL Server on RDS?
Thanks
It would be possible if the correct JDBC driver was integrated into AWS Glue but it is not. One of the downsides of a serverless environment is you can't add drivers to the server.