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/dotco ... ostgresql/
5. Still got an error
Any ideas on how to get it working?
Thanks in advance
SharePoint and Postgresql database
Re: SharePoint and Postgresql database
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.
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.