# How to connect Athena to ignition?

**URL:** <https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150>\
**Category:** Ignition\
**Tags:** perspective, database, ignition80\
**Created:** [March 16, 2023, 11:24am UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150 "2023-03-16T11:24:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sabhareeswaran\_Ravi](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@Sabhareeswaran\_Ravi](https://forum.inductiveautomation.com/u/Sabhareeswaran_Ravi)\
**Post date:** [March 16, 2023, 11:24am UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150/1 "2023-03-16T11:24:22Z")

</div>

I am new to ignition and would like to connect athena and fetch some data...  
Not able to find clear documentation in this regard.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 16, 2023, 2:43pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150/2 "2023-03-16T14:43:29Z")

</div>

I don't know of a direct connector. My guess is you would need to use Ignition to collect data and store it in a relational database. Once it's in the database, Amazon Athena can access it.

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [March 16, 2023, 3:21pm UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150/3 "2023-03-16T15:21:47Z")

</div>

Edit: Nevermind, I think you're asking about sending data to Athena from Ignition. In which case, I agree with Kathy here.

I've never looked into Athena at all (just did a search out of curiosity), but it does appear there is a JDBC driver. Might be able to import and explore there? I've never tried using a JDBC driver that wasn't part of the Ignition Documentation, so not sure what speedbumps could be there.

> **[Connecting to Amazon Athena with JDBC - Amazon Athena](https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html)**
>
> Use a JDBC connection to connect Athena to business intelligence tools and other applications.

---

<div class="post-metadata">

**Author:** ![Sabhareeswaran\_Ravi](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@Sabhareeswaran\_Ravi](https://forum.inductiveautomation.com/u/Sabhareeswaran_Ravi)\
**Post date:** [March 17, 2023, 6:09am UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150/4 "2023-03-17T06:09:43Z")

</div>

@ grietveld @ KathyApplebaum Thanks for your responses,

I am trying to fetch my data from AWS using Athena,  
I want to bring the data and store it in Ignition for visualization. I've tried adding a new JDBC driver but cannot connect Athena to the ignition.

---

<div class="post-metadata">

**Author:** ![Sabhareeswaran\_Ravi](https://avatars.discourse-cdn.com/v4/letter/s/f6c823/32.png) [@Sabhareeswaran\_Ravi](https://forum.inductiveautomation.com/u/Sabhareeswaran_Ravi)\
**Post date:** [March 17, 2023, 6:18am UTC](https://forum.inductiveautomation.com/t/how-to-connect-athena-to-ignition/71150/5 "2023-03-17T06:18:24Z")

</div>

Now I am able to connect, just tried a different version of JDBC by Amazon. 🙂
