Score:1

Is it possible to create a linked server between the ServiceNow ODBC driver and an AWS/RDS SQL Server instance?

in flag

I have an internal .NET 7 web application that uses an MSSQL database hosted on Amazon RDS.

I have a requirement to create a linked server to query data from a separate ServiceNow DB instance.

The only way I can see to do this is:

  • Install a new instance of MSSQL/SQLExpress on a Windows Server.
  • Install the ServiceNow ODBC driver on the same Windows Server and configure a System DSN to point to my service now instance.
  • Configure a .NET DataContext in my .NET 7 web app that points to the linked server on MSSQL/SQLExpress.

Q: Is there any way I can bypass the (extraneous!) SQLExpress install, and configure the linked server for the ServiceNow ODBC directly on my AWS RDS instance?

Score:0
in flag

The answer appears to be "no".

If I need an ODBC connection...then deploying it to an on-prem MSSQL (like SQLExpress) appears to be the only option.

I CANNOT install my Service Now ODBC driver to AWS/RDS ... because the AWS/RDS instance is "serverless" (SASS)... and consequently there's no "server" to install/configure the ODBC driver on. Besides additional restrictions on MSSQL "linked servers" for AWS/RDS instances...

Relevant links:

Linked Server is supported for only SQL Server (EC2 or on-premises) to RDS SQL Server RDS SQL Server to SQL Server (RDS, EC2, or on-premises) vs. RDS linked server to on-prem...

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.