Ludwig
Reputation: 832
Establish AWS connection to SQL Server
Is there a way by which we can establish a connection from AWS to sql server and pull the data. I am aware of the method of using cdata connector with glue jobs and it looks promising but I want to explore options here. The idea is to pull the data from sql server to s3 bucket.
Upvotes: 0
Views: 263
Answers (1)
Aditya Sahu
Reputation: 63
You can directly use from_options method of GLUE to pull data from below data stores
s3, mysql, postgresql, redshift, sqlserver, oracle, and dynamodb
and dump wherever you required.
More Information on
Upvotes: 1
Related Questions
- Access AWS Glue from local Spark
- aws glue, how to connect to external database server which not locate in aws cloud？
- Connecting to DocumentDB from AWS Glue
- Using SSM Secret Strings to create a Glue Connection fails in CDK
- SQL Server named instance connection string in AWS Glue
- Using AWS Glue data connection without Glue Data Catalog
- AWS Glue: Access denied for accessing table with S3 source data
- Issues Creating a Glue Connection to an MS SQL Server RDS
- AWS Glue: How to connect oracle db using JDBC
- aws load data from s3 to rds