# Ignition support direct Azure data explorer connectivity?

**URL:** <https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386>\
**Category:** General Discussion\
**Tags:** database, perspective\
**Created:** [July 18, 2024, 10:35am UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386 "2024-07-18T10:35:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Swathi\_G](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@Swathi\_G](https://forum.inductiveautomation.com/u/Swathi_G)\
**Post date:** [July 18, 2024, 10:35am UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/1 "2024-07-18T10:35:25Z")

</div>

Hello,  
I have one question regarding azure data connectivity in ignition,  
Is direct connectivity is possible in Ignition latest version or not(As like other database SQL, PostGres etc.)?

If Yes, then how it will happen through ignition gateway?

---

<div class="post-metadata">

**Author:** ![andrew.budaiev](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andrew.budaiev/32/72921_2.png) [@andrew.budaiev](https://forum.inductiveautomation.com/u/andrew.budaiev)\
**Post date:** [July 19, 2024, 3:48am UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/2 "2024-07-19T03:48:08Z")

</div>

This could be related.

> **[GitHub - iatraviscox/azure-kusto-ignition: ADX (Kusto) injector for Inductive...](https://github.com/iatraviscox/azure-kusto-ignition)**
>
> ADX (Kusto) injector for Inductive Automation platform - Ignition - iatraviscox/azure-kusto-ignition

---

<div class="post-metadata">

**Author:** ![Swathi\_G](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@Swathi\_G](https://forum.inductiveautomation.com/u/Swathi_G)\
**Post date:** [July 19, 2024, 7:32am UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/3 "2024-07-19T07:32:11Z")

</div>

Thank you , Above GitHub repository is beneficial, I have taken .modl latest version file and added in ignition gateway by install/upgrade module and connectivity is done in ignition gateway, Also in designer launcher in tag browser added new tag (New standard tag -\> Query tag) and select History : true & in Providername : select appropriate name that is given in ignition gateway page ,  
Now, how can I show my created databases or tables(That is already in azure data explorer) in perspective view or in ignition gateway page?

Using named query is it possible?  
Or any scripting is required for that?  
Just wanted to see data of that particular database or table.

Thanks.

---

<div class="post-metadata">

**Author:** ![Swathi\_G](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@Swathi\_G](https://forum.inductiveautomation.com/u/Swathi_G)\
**Post date:** [July 29, 2024, 3:51pm UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/4 "2024-07-29T15:51:11Z")

</div>

In this above git repo I have install/upgrade \*.modl file that is useful.  
Now, using script is it possible to receive data(database and table that is created in ADX)??  
I have created one view in perspective view in which button onclick event just want to get 2-3 record form existing created table, but it is giving some error of missing some dependent files.  
I have also added required .jar files under ..\Ignition\lib\core\common , and again restart ignition but it is not worked, got this error

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/d/add2f7dbbd85b96891d1d52b6071b68dd3f9c281.png)

```python
def runAction(self, event):
	import system
	import traceback

	query = "tablename | top 2"  
	historyProvider = "ADXHistoryProvider"
	database = "database_name"

	try:
		system.util.getLogger("KustoQuery").info("Executing Kusto query: " + query)
		result = system.kusto.query(historyProvider, database, query)
		system.util.getLogger("KustoQuery").info("Kusto query result: " + str(result))
        
		table = self.getSibling("Table")
		table.props.data = system.dataset.toDataSet(result)
	except Exception as e:
			system.util.getLogger("KustoQuery").error("Error executing Kusto query: " + str(e))
			system.util.getLogger("KustoQuery").error(traceback.format_exc())

```

 ![connect](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/b/bb04b9baf4d08cfb44c66f187a3ade681c91d480.jpeg)

Can I missed anything here?  
Thanks,  
Swati

---

<div class="post-metadata">

**Author:** ![andrew.budaiev](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andrew.budaiev/32/72921_2.png) [@andrew.budaiev](https://forum.inductiveautomation.com/u/andrew.budaiev)\
**Post date:** [July 29, 2024, 11:08pm UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/5 "2024-07-29T23:08:06Z")

</div>

I haven't used it personally, but maybe somebody can ping Travis since it  
s his repo?

---

<div class="post-metadata">

**Author:** ![Swathi\_G](https://avatars.discourse-cdn.com/v4/letter/s/f04885/32.png) [@Swathi\_G](https://forum.inductiveautomation.com/u/Swathi_G)\
**Post date:** [July 30, 2024, 5:01am UTC](https://forum.inductiveautomation.com/t/ignition-support-direct-azure-data-explorer-connectivity/93386/6 "2024-07-30T05:01:57Z")

</div>

Ok sure, Thanks for helping.