PGNP OLEDB Providers for PostgreSQL*, Greenplum and Redshift

* Wide range of Postgres-compatible databases are supported, i.e. Amazon RDB, Heroku, Yellowbrick, etc.
Main features are:
- Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (SQL Server 2005/2008/2012/2016/2017/2019).
- Support for SSRS, SSAS and SSIS (SQL Server 2005/2008/2012/2016/2017/2019).
- 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
February 8, 2021 Ver 1.4.0.3624
Fixed bug in evaluating column information returned from some functions (BTRIM).Fixed bug in retrieving column information the the pre-9.1 Postgresql.
Fixed bug in setting Syntax parameter in DataLink dialog.
Fixed scale calculated in expressions for date and time types.
Fixed bug in releasing unused rows.
Fixed bug resulting in Profiler crash when RemoteHosts configuration is very long.
Fixed minor bug in loading SSL certificate from a custom path (SSLCERT parameter).
Fixed bug in DataLink Advanced tab UI when handling SSLCERT and other parameters.
Changed allowed range for MIN_FETCH_ROWS to 100..20000.
Set permanent flag for msvcr120.
Improved stability of the OLEDB provider in VS2019 and other applications.
PGNP Features Matrix (32- and 64-bit Platforms); DE vs SE
FEATURE | PGNP 1.2.8 | PGNP 1.3.0 | PGNP 1.4.0* |
PostgreSQL Support | 8.0 | 8.x, 9.x | 8.x-10.x |
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 2000, 2005 and 2008 Linked Servers Support | Yes | Yes | Yes |
SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support | Yes | Yes | Yes |
What's New in 1.4?
The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift has several new features and improvements:
- Optimizations for very large data sets (1 billion rows and more).
- Deferred updates support (IRowsetUpdate).
- Better support for Greenplum 4.x (awareness about distribution policy, better use of cursors, gpload utilization for bulk operations, etc.)
- Better support for PostgreSQL 9.x.
- New utility for Automated updates (not included in the trial build).
- Better integration with SSIS (MS BI tools).
Login Form
Search
VM - Shopping cart
Cart empty
Don't have an account yet? Register Now!