Connect Microsoft SQL Server on EC2 to EMR Serverless

0

How do I connect EMR Serverless to read and write to a Microsoft SQL Server database hosted on EC2

Mary
asked 2 months ago202 views
1 Answer
3

Hello,

Basically, you need to add the JDBC jar for connecting the spark/hive from EMR serverless to MSSQL database. In the network connection, you have to pay attention as the connectivity from EMR-S for the specific port allowed to MSSQL DB in the VPC. Please refer this document for steps. Let me know if you have any issues.

AWS
SUPPORT ENGINEER
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions