This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've been using PostgreSQL 9.3 with PostGIS to serve up data to QGIS and ArcGIS as well as provide multi-user editing for a variety of our data. It's been working wonderfully for two years. We can view/query the data in Alteryx just fine using the 64-bit Spatial ODBC Connection, but all efforts to write/update back to the DB via Alteryx are not working.
Just curious if anyone has a similar configuration, and if you've been able to have success writing / posting back to the PostgreSQL DB via Alteryx?
I would like to know what kind of problem you are actually facing.
The problem that we encounter while updating the data back to DB via Alteryx is that, the datatype of fields automatically changes to "ntext" from "V_WString" datatype, due to which data fails to update. To resolve this we first convert the datatype from "ntext" to "V_String" and then the data gets updated to DB successfully.
Hey John, No, I worked quite a bit testing with their DB specialists, but in the end was told it's a bug that they hope to fix. Haven't heard back in a couple of months. Honestly, it doesn't seem they're very motivated to work with Postgres as (I assume) it's not a common DB platform with their clients. The new In DB processing tools don't support it either. We've just moved forward only utilizing Alteryx/PostGIS as a read-only relationship. Again, it works fine for non-spatial data, but nothing with a spatial object in it.
FYI, just got this from Carlos Avila @ Alteryx.... (he's been very helpful btw)
I wanted to follow up on the issue below. Our development team have looked extensively on making the PostgreSQL 9.3 driver work with the spatial objects in the PostgreSQL database, and have concluded that there is a bug in the driver that prevents this from happening. They recommend that you use the 9.2 driver instead, which works successfully with the spatial objects. Let me know if you have any questions,
I uninstalled the 9.3 ODBC driver and installed the 9.2 x64 version from here: http://www.postgresql.org/ftp/odbc/versions/msi/
Reestablished Spatial ODBC connection in Alteryx and so far, everything seems to be working with having Alteryx create/update postgresql/PostGIS data.