# Odbc connection

**URL:** <https://forum.inductiveautomation.com/t/odbc-connection/91349>\
**Category:** General Discussion\
**Tags:** database\
**Created:** [June 4, 2024, 2:49pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349 "2024-06-04T14:49:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Kern](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@Matt\_Kern](https://forum.inductiveautomation.com/u/Matt_Kern)\
**Post date:** [June 4, 2024, 2:49pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/1 "2024-06-04T14:49:19Z")

</div>

Hi: Does Ignition support ODBC drivers? Any links to describe how to setup connectivity with Ignition? Thanks!

---

<div class="post-metadata">

**Author:** ![bschroeder](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bschroeder/32/13260_2.png) [@bschroeder](https://forum.inductiveautomation.com/u/bschroeder)\
**Post date:** [June 4, 2024, 2:53pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/2 "2024-06-04T14:53:00Z")

</div>

What database are you trying to connect to?

Ignition uses JDBC since it runs on java. ODBC is a Windows only connection.

---

<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:** [June 4, 2024, 3:00pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/3 "2024-06-04T15:00:41Z")

</div>

The java JDBC-ODBC bridge technology was removed long ago (Java 8 and later). There might be third party implementations. This one, perhaps:

> **[JDBC-ODBC Bridge Driver - JDBC | JDBC Drivers | JDBC Connection | JDBC API](https://www.cdata.com/drivers/bridge/jdbc/)**
>
> The JDBC-ODBC Bridge provides JDBC access from any Java App to ODBC data sources on Windows, Linux and Mac. Whether your organization uses Java-based tools for reporting and analytics, or builds custom Java solutions, the CData JDBC-ODBC Bridge...

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [March 7, 2025, 4:23pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/4 "2025-03-07T16:23:13Z")

</div>

can this be implemented into ignition?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 7, 2025, 4:25pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/5 "2025-03-07T16:25:57Z")

</div>

What do you mean by "this"?

ODBC, the underlying technology, as mentioned above is Windows specific and semi-proprietary. We have no interest in supporting it first party.

ODBC via JDBC 'bridge' drivers exist, as linked above. You are welcome to use these (exclusively commercial) options with Ignition, as you can readily add new JDBC drivers to Ignition. We also have no interest in doing this first party.

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [March 7, 2025, 4:46pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/6 "2025-03-07T16:46:11Z")

</div>

The best way to deal with ODBC is to add your old ODBC stuff as linked servers in MSSQL and then use JDBC to connect to MSSQL.

---

<div class="post-metadata">

**Author:** ![drewdin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drewdin/32/3363_2.png) [@drewdin](https://forum.inductiveautomation.com/u/drewdin)\
**Post date:** [March 7, 2025, 4:47pm UTC](https://forum.inductiveautomation.com/t/odbc-connection/91349/7 "2025-03-07T16:47:01Z")

</div>

Thanks, I just came across this in another post and I think this is the best way to go. Thank you
