# Create a linked server in SQL Server 2019 with ODBC, using Dremio Connector

**URL:** <https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679>\
**Category:** Uncategorized\
**Created:** [June 1, 2023, 4:26pm UTC](https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679 "2023-06-01T16:26:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![amukjee](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/amukjee/32/4965_2.png) [@amukjee](https://community.dremio.com/u/amukjee)\
**Post date:** [June 1, 2023, 4:26pm UTC](https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679/1 "2023-06-01T16:26:54Z")

</div>

Hi There,

I’d like to understand, if this is a possible option… Also, if yes, Could you please share (/point me to any documentation etc… or if any known limitation).

So, _I’m willing to create a linked server in SQL Server 2019 with ODBC, using Dremio Connector (most likely, 1.5.1) to be able to use OPENQUERY to query datalake_

Thanks much,

---

<div class="post-metadata">

**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\
**Post date:** [June 1, 2023, 11:27pm UTC](https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679/2 "2023-06-01T23:27:20Z")

</div>

@amukjee Currently Linked Server in SQL Server is not something that is tested and supported

---

<div class="post-metadata">

**Author:** ![amukjee](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/amukjee/32/4965_2.png) [@amukjee](https://community.dremio.com/u/amukjee)\
**Post date:** [June 2, 2023, 3:33am UTC](https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679/3 "2023-06-02T03:33:34Z")

</div>

Noted. Thank you so much @balaji.ramaswamy  
Do we have any alternative guideline how we can utilize dremio (not via UI) connector to communicate with Datalake? Wondering what would be actual purpose of Connector otherwise?

---

<div class="post-metadata">

**Author:** ![lenoyjacob](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/lenoyjacob/32/3474_2.png) [@lenoyjacob](https://community.dremio.com/u/lenoyjacob)\
**Post date:** [June 2, 2023, 4:00pm UTC](https://community.dremio.com/t/create-a-linked-server-in-sql-server-2019-with-odbc-using-dremio-connector/10679/4 "2023-06-02T16:00:54Z")

</div>

@amukjee could you explain what do you mean by:

> _using Dremio Connector (most likely, 1.5.1)_

What connector is this? Any links/docs?