PostgreSQL Integration and Synchronization with SharePoint or Office 365
often simply "Postgres", is an open source object-relational database management
system (ORDBMS) that can be connected and synchronized with almost any other
corporate data sources, e.g. native lists in Microsoft SharePoint or Office 365,
codeless and bi-directional via the Layer2 Cloud Connector.
To connect and synchronize Postgres with SharePoint (or almost any other
corporate data source) we need to create a sample table or query in Postgres
Fig.: Data table in Postgres to
integrate with SharePoint or Office 365.
To connect and sync we need to
install the Npgsql .NET Data Provider. You can download the provider here:
the version that matches your installed Microsoft .NET Framework version.
Please execute the setup program to install the required components. Make sure that the provider is also installed into the GAC.
Fig.: Component selection required
for PostgreSQL data integration.
Now we are ready to synchronize our contacts sample table from PostgreSQL with a
native Microsoft SharePoint contact list, on-premises or even in the Microsoft
Office 365 cloud.
Fig.: The PostgreSQL sample table
contacts has some usual columns to sync with SharePoint.
- Use lowercase characters for table and column names.
- You need to specify a primary key containing unique values, „email“ in this