# Pyodbc and Azure

**URL:** <https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [September 28, 2023, 5:47pm UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803 "2023-09-28T17:47:56Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Siebold](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/siebold/32/47336_2.png) [@Siebold](https://forum.inductiveautomation.com/u/Siebold)\
**Post date:** [September 28, 2023, 5:47pm UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803/1 "2023-09-28T17:47:56Z")

</div>

I am looking to do some querying from a secondary database in Azure but I don't want to add it to my gateway because it is just going to be used on an Edge device. I have used Pyodbc on other projects outside of Ignition, is it possible to add that library to Ignition?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 28, 2023, 6:29pm UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803/2 "2023-09-28T18:29:11Z")

</div>

Pyodbc requies the use of C++ extensions, so no.

But, this one may be of interest, as it's suppose to be able to work with Jython.

> **[JayDeBeApi](https://pypi.org/project/JayDeBeApi/)**
>
> Use JDBC database drivers from Python 2/3 or Jython with a DB-API.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 28, 2023, 8:17pm UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803/3 "2023-09-28T20:17:34Z")

</div>

> [@Siebold](#):
>
> just going to be used on an Edge device

So, evading the IA license restriction against database connections? Not cool.

---

<div class="post-metadata">

**Author:** ![humphrey.daniel](https://avatars.discourse-cdn.com/v4/letter/h/8e8cbc/32.png) [@humphrey.daniel](https://forum.inductiveautomation.com/u/humphrey.daniel)\
**Post date:** [September 29, 2023, 2:01am UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803/4 "2023-09-29T02:01:14Z")

</div>

As I understand it, Edge doesn't come with DB connectivity. If a customer wants to create their own solution to access a DB, that seems fine in my book.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 29, 2023, 2:02am UTC](https://forum.inductiveautomation.com/t/pyodbc-and-azure/79803/5 "2023-09-29T02:02:42Z")

</div>

> [@humphrey.daniel](#):
>
> seems fine in my book

Good to know.