Postgre SQL Setup in Alteryx Gallery

HI Team,

Have a requirement to connect to Postgre SQL in alterxy after doing some research came to know that need to Install ODBC Drivers and then connect to Postgre sql DB in alteryx designer

In order to work Postgre SQL DB (to Schedule Workflow) in gallery do we need to install Drivers in gallery as well can anyone please help me what things need to install in Gallery to work Postgre sql smoothly in Gallery?

Thanks,

Varun G

Workflow

Gallery

Settings

Custom Tools

Connectors

Server

Download

Installation

Scheduler

Accepted answers

afv2688

Hello @varun511,

The drivers are needed on the gallery to test out and verify the connection settings. If your gallery is also responsible for running the workflows (acting as a worker) then the bigger the reason to have the drivers installed.

You will be able to see on the gallery admin settings, under data connections -> new connection that there are 3 predefined options to set up connections, either oracle, Microsoft sql or other.

You would need to specify other and type there the whole connection string.

Regards

All comments

afv2688

Hello @varun511 ,

to avoid any possible issues I would recommend you to have the same driver version installed on both sides. If you are going to create DSN for accessin the database, the same DSN need to be on the server (on the worker to be more specific).

You can also look and explore on the possibility to have the connections created on the gallery and share them to the users, that way you could manage the connection settings from just one place.

The third option would be then to have what it is called a DSN-less connection. This one is my favourite (given that I do a lot of migration of workflows). I would recommend you to explore this possibility as well.

Hope that helps

Kind regards

varun511

@afv2688 Thanks so much for your reply it helps me one more question

In Order to Create Connections in Gallery what parameters need to have ? do i need to install Drivers as well

if you could explain me the process that would be really helpful to me answer this

Thanks,

Varun

afv2688

Hello @varun511,

You will be able to see on the gallery admin settings, under data connections -> new connection that there are 3 predefined options to set up connections, either oracle, Microsoft sql or other.

You would need to specify other and type there the whole connection string.

Regards

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703