Gallery Data Connections

[Srigiri]

How to access or use a Gallery Data Connections within a Python tool and run a dynamic SQL query ?

I have a ODBC connector and my local IT is having issues setting it up but not as a Gallery Data connection. If it’s a ODBC DSN I can use pyodbc within python tool and run a SQL command and fetch data. 

what if I can use only a gallery data connection and then how to dynamically create and call a SQL within python using Gallery data connection?

[apathetichell]

What's the ODBC and what kind of error messages is your IT getting?

[Srigiri]

Well local IT having a policy of not installing a ODBC driver rather asking us to use a gallery data connection. 

Is there a way I can use the gallery data connection in my python tool and fetch data using sql command ?