read/write data (and spatial data) to postgresql 13 in azure

[pdx]

Hi,

I'm trying to read data and spatial data to Alteryx from PostgreSQL 13 (Flex). The postgis extensions are in place in PostgreSQL. When I attempt to setup a database connection the only PostSQL selection includes ODBC. I'm looking for specific details for reading/writing spatial and non-spatial data to postgresql database in Azure. Is a driver required? Where can I get the driver if it is needed? Is an ODBC required? Running Alteryx 2022.3 and Postgresql-flex 13 in Azure with pgadmin. Thank you- Kathy

[alexnajm]

Not sure if I understand the question, but yes drivers are required: PostgreSQL | Alteryx Help

[apathetichell]

You could build your own connection using Python or the download tool - but the ODBC is the most in-workflow way.

https://learn.microsoft.com/en-us/azure/postgresql/single-server/connect-python