That is great, thanks Istvan Hahn.

I am also looking to authenticate restful API with oAuth2. I have configured my ensemble instance to act as a authorisation server, but not sure how to integrate it with the api.

Is there a short step by step guide on how to do this?

Thanks, Imran

Yes, you can set up a linked server but first, you need to create an ODBC connection.

1. Create an ODBC connection
2. Open SQL Server Management Studio
3. Create linked server using other data source
4. Select provider: Microsoft OLE DB Provider for ODBC Drivers
5. Select Product name: same as the ODBC connection name
6. Select Data source: same as the ODBC connection name
7. Under Security tab select option “Be made using this is security context”
8. Enter remote login with password

then  select top 1 * from [linked server name]..[schema name].[table name]