PGNP OLEDB Providers for PostgreSQL*, Greenplum and Redshift
The PGNP provider is a thin layer between Microsoft ADO and PostgreSQL database. It implements most of the OLEDB interfaces and uses libpq to access a PostgreSQL database. The provider can be used from 32-bit and 64-bit applications both native and .NET.Main features are:
- High performance in all OLTP and OLAP scenarios.
- Full support for SSRS, SSAS and SSIS in SQL Server 2005-2022.
- OS Platforms: Windows XP, Windows Servers 2003-2022, Windows Vista, Windows 7-11.
- SQL Server Linked Servers and Replication support.
- Error reporting and execution tracing.
- Transactions support: standard OLEDB, and "nested" PostgreSQL transaction using savepoints.
- Distributed transactions, two phase commit protocol.
- Schema support for tables, views, provider types, columns, primary/foreign keys, indexes, etc.
PGNP Project History
May 31, 2023 Ver 1.4.0.3690
Fixed bug in handling table name longer than 63 symbols. Added extended property parameter NAMEDATALEN.
Fixed bug in processing results of commands batch with size larger than 16.
Fixed bug in returning rowset when CURSOR=SINGLEROW.
February 8, 2023 Ver 1.4.0.3684
Added TYPES schema.
Fixed bug in handling recursive CTE query when it joins to itself.
Fixed bug in handling CTEs with list of columns.
Fixed bug in processing complex expressions with aggregate functions.
Fixed bug in processing Numeric fields that resulted in the following linked server error: Invalid data for type "numeric".
Fixed side-effect from changes in release 3672 related to handling stored procedures.
PGNProfiler: added global lock for better resources isolation.
PGNP Features Matrix (32- and 64-bit Platforms); DE vs SE
| FEATURE | PGNP 1.3.0 | PGNP 1.4.0* | PGNP 1.5.0* |
| PostgreSQL Support | 8.x, 9.x | 9.x-15.x | 9.x-latest |
| OLE DB Connection Pooling | Yes | Yes | Yes |
| OLE DB Error Reporting | Yes | Yes | Yes |
| OLE DB Command Prepare and Cancel | Yes | Yes | Yes |
| OLE DB Columns Information | Yes | Yes | Yes |
| Database Transformation in SQL Server DTSWizard | Yes | Yes | Yes |
| Local Transaction Support | Yes | Yes | Yes |
| Distributed Transactions and Two Phase Commit Protocol (DTC enlistment) | No | Yes** | Yes** |
| SQL Server 2005-2019 Linked Servers Support | Yes | Yes | Yes |
| SQL Server 2005-2019 to PostgreSQL Replication Support | Yes | Yes | Yes |
What's New in 1.5?
The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift has several new features and improvements:
- IDP/SSO Login support for Redshift.
- 64-bit Profiler for unlimited tracing.
- Subscriptions support.
The PGNP v1.5 (beta) evaluation modules and documentation is provided to approved Beta Testers only. The v1.4 evaluation is available on the Download page.
See also: What's new in 1.4?