SharePoint and Postgresql database

SharePoint and Postgresql database

Postby lazevedo » Mon 23 May 2016 10:04

I'm trying to add postgresql data sources to SharePoint through data providers but so far I wasn't able to do it, not even by using dotConnect Postgresql. I tried to trial version because I wanted to test if it worked before buying and it doesn't seem to work, here are the steps that I did (images below):
1. Installed dotConnect on the SharePoint 2016 Server
2. Run SharePoint Designer (also on the server)
3. Tried to add a Database data source through a OLED DB provider
4. Used the connection string on this page (with the values login and DB values changed to my scenario): https://www.connectionstrings.com/dotconnect-for-postgresql/
5. Still got an error

Any ideas on how to get it working?

Image
Image
Image

Thanks in advance
lazevedo
 
Posts: 1
Joined: Mon 23 May 2016 09:35

Re: SharePoint and Postgresql database

Postby Shalex » Mon 23 May 2016 16:06

We did not test dotConnect for PostgreSQL with SharePoint Designer and do not guarantee its compatibility. dotConnect for PostgreSQL implements standard ADO.NET interfaces, so if SharePoint Desiger supports third-party ADO.NET providers, it should work with dotConnect for PostgreSQL as well.

You select OLE DB provider on your screenshot, but dotConnect for PostgreSQL is an ADO.NET provider.
There is an ODDB option in the list described, so you can also try to empoy the ODBC provider (instead of dotConnect for PostgreSQL) which supports standard ODBC API functions and data types: https://www.devart.com/odbc/postgresql/.

We recommend you to contact the Microsoft Support Team to find out the list of third-party providers supported by SharePoint Designer.
Shalex
Devart Team
 
Posts: 7774
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL