Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

pdx
6 - Meteoroid

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- KathyAvailable Data Sources.png

2 REPLIES 2
alexnajm
18 - Pollux
18 - Pollux

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

apathetichell
20 - Arcturus

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

Labels
Top Solution Authors