Setup
- Currently we are using SQL Server installed on an EC2 instance as our central data warehouse. We pull in data from a long list of data sources.
- This is done via SQL Agent Jobs that execute Stored Procedures querying the data sources.
- The SQL Server instance has Linked Server connections to several databases (Postgres, MySQL, Oracle, SQL Server) and also to Hive.
- These data sources are either on-premise or also deployed in AWS.
- The connections are enabled by ODBC drivers which we installed directly on EC2.
Problem
Now there is a new company rule that we have to use AWS RDS for SQL Server instead of EC2. The problem is that AWS RDS does not support installing our own ODBC drivers. So we can't connect to the data sources anymore.
Question
How could we go about connecting AWS RDS to data sources which previously we could talk to via Linked Server + ODBC drivers?
Note
Abandoning SQL Server altogether should only be a last resort. There are lots of SSIS packages and migrating them to a new technology would take a lot of time and effort, so should be avoided if possible.