community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Community v19.9

The latest release includes several enhancements designed to improve your Community experience!

Learn More

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

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
 
18 Comments
Alteryx
Alteryx
 
Atom

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.

 

Alteryx
Alteryx

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.

 

postgres.jpg

 

Best,

Alex

Atom

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.

Meteoroid

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?

Atom

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:

image.png

 

Select Greenplum as the data source:

image.png

 

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

image.png

 

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

Meteoroid

 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?

 

 

 

Capture.JPG

 

Capture.JPG

Community Operations Manager
Community Operations Manager
Status changed to: Implemented

This idea was implemented in version 11.5