# ODBC Database Connection - CMS AS400

**URL:** <https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149>\
**Category:** Ignition\
**Tags:** ignition81, database\
**Created:** [January 30, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149 "2023-01-30T13:47:10Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![David\_Choi](https://avatars.discourse-cdn.com/v4/letter/d/34f0e0/32.png) [@David\_Choi](https://forum.inductiveautomation.com/u/David_Choi)\
**Post date:** [January 30, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149/1 "2023-01-30T13:47:11Z")

</div>

Hello All,

We're trying to create a real-time display for production line where the data only resides within our CMS AS400 system, but no way to visualize.

Attempt is to use Ignition to work as the visualization tool.

Realizing that this connection is ODBC, I know Ignition does not support ODBC drivers. There appears to be some documentations regarding it, but does anyone have experience doing this? I'd like to see if there's some step-by-step instruction from those who's already done it using Ignition.

> **[Connecting Ignition to Microsoft Access](https://www.easysoft.com/blog/ignition.html)**
>
> How do you connect Ignition software to this popular database application.

[https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-CommonThirdPartyDrivers](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-CommonThirdPartyDrivers)

Thank you,

David Choi

---

<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:** [January 30, 2023, 5:00pm UTC](https://forum.inductiveautomation.com/t/odbc-database-connection-cms-as400/69149/2 "2023-01-30T17:00:46Z")

</div>

It's possible you can get a JDBC driver:  
[https://jt400.sourceforge.net/](https://jt400.sourceforge.net/)

Another option might be to connect a more modern RDBMS to Ignition, and use it as a 'middleman' to the ODBC-only database. MSSQL calls this 'linked servers', Postgres calls this 'foreign data wrappers', for instance. I would actually generally prefer this option.