Azure VM with SQL Server linked server connection to AWS RDS Oracle database

K M 1 Reputation point

We'll have a Azure VM with SQL Server 2022 (not managed instance) and we would like to create a linked server connection to Amazon (AWS) RDS Oracle database. If this is possible, please provide detail steps. Thanks

Azure SQL Database
{count} votes

3 answers

Sort by: Most helpful
  1. Vinodh247 7,421 Reputation points

    Hi K M,

    Thanks for reaching out to Microsoft Q&A.

    If you say you have azure VM with SQL 2022 that would be a managed instance. Pls confirm if yours is Azure SQL database, or a database hosted under managed instance.

    If it is azure sql database then you won't be having linked server option, you can use pipelines from azure data factory after creating a linked service inside it.

    Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

  2. K M 1 Reputation point

    I will have SQL Server on Azure Virtual Machine as mentioned in my question post. Can I know how to create linked server to AWS RDS Oracle database. See this

  3. K M 1 Reputation point

    Can someone please understand my requirement in initial question and provide steps accordingly please

    0 comments No comments