Postgre SQL Setup in Alteryx Gallery

[varun511]

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

[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 · Accepted solution]

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