Suggestion to include support for Postgres in the In-DB functionality

[SHILPAHV]

Hello,

We have been storing data on the PostgresDB and would be using variables from these tables for modeling processes in Alteryx. The ODBC connectors for postgres don't seem to be geared towards optimal performance, hence it would be extremely useful if Alteryx came up with an in-db functionality for postgres database in the future release.

Thanks

[jono_hct]

Hi AlexP, thanks for this. Can you connect to any PostgreSQL instance using the Greenplum functionality? I guess you'd need to use the Greenplum driver?

It would be great if the documentation here could be updated to reflect in-DB support for Greemplum/Postgres.

[ARich]

Hi @jono_hct,

Thanks for the heads up- we'll get that documentation updated.

We've tested compatibility with postgres 9.4, so we know that works using the Greenplum option via the Connect In-DB tools. And, we actually recommend using the postgres driver (version 09.06.0310) rather than the greenplum driver.

Best,

Alex

[jono_hct]

Great, thanks - we're managed to get it working with the PostgreSQL driver under the Greenplum connection option. Helpful instructions are here for getting the ODBC connection set up.

Worth noting that the Greenplum driver isn't licensed to work with raw PostgreSQL databases so can't be used.

[gcarmich]

I want to use Alteryx In-DB functions in my PostgreSQL database.  If the Greenplum driver isn't licensed to work with raw PostgreSQL databases how can I setup the connection for In-DB?

[jono_hct]

Set up the ODBC connection using the native Postgres ODBC driver (which you may need to install - if you're on Windows you probably want the latest driver here). Instructions are here for getting an ODBC connection set up.

Then...

Use the 'Connect In-DB' tool:

Select Greenplum as the data source:

Choose your ODBC Postgres connection from the 'Connections' box:

Then build your In-DB workflow, which should work fine in Postgres.

[gcarmich]

 I setup the Greenplum driver  as specified (second image below). When I use it with the In-DB tools, the workflow doesn't return any results or errors (first image below).  Earlier in this thread, someone mentioned that "Worth noting that the Greenplum driver isn't licensed to work with raw PostgreSQL databases so can't be used."  I'm not sure what "raw" means but could this be the issue?

[DanM]

This idea was implemented in version 11.5

[wwatson]

I can see Greenplum there as an option for in-db connections. Is this what is recommended when the database is Postgres, or should we use the standard ODBC connector and the latest Postgres ODBC driver?