topic RE: Connecting to Postgress SQL Database in Product Forum

Connecting to Postgress SQL Database

BoniSahithi — Tue, 10 Aug 2021 12:32:00 GMT

Hi

I am working on a POC that uses MS Outlook VBO to fetch mails everyday into a collection and posting them to a Postgress SQL database. Can someone help me which VBO I need to use to connect to my Postgress SQL DB instance and what db details are needed to complete the post...? Appreciate your help.

------------------------------
Boni Sahithi
------------------------------

RE: Connecting to Postgress SQL Database

ewilson — Tue, 10 Aug 2021 13:00:00 GMT

Hello @BoniSahithi,

There is a PostgreSQL VBO available on the Digital Exchange. You can find it here. Please refer to the user guide for specifics about how to set it up.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Connecting to Postgress SQL Database

BoniSahithi — Tue, 10 Aug 2021 13:24:00 GMT

Hi Eric,

Thanks for the help. @ewilson Is the release file in the link provided by you the VBO? Is there any other VBO that can be used. I saw some links mentioned OLEDB-SQL Server can also be used.Thanks again

------------------------------
Boni Sahithi
------------------------------

RE: Connecting to Postgress SQL Database

ewilson — Tue, 10 Aug 2021 13:29:00 GMT

If you want to connect specifically to the PostgreSQL database you'll want to use the PostgreSQL VBO. The OLEDB and SQL Server VBOs are for connecting to other types of data sources like an Access database or a SQL Server instance.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------