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
November 8, 2020 Ver 1.4.0.3612
Fixed bug resulting in "undefined table" and "port number: 0".October 8, 2020 Ver 1.4.0.3610
Added handling of query comments as Extended Properties parameters, e.g.: --PGNP:CURSOR=OFF;MIN_FETCH_ROWS=543;Added failover capability, and updated Developers Manual.
Added support for Extended Property parameter GSSENCMODE=disable; and for SSLCERT, SSLKEY, SSLROOTCERT, SSLCRL.
Enabled cross-db queries for Yellowbrick.
Recompiled with libpq12 and openssl-1.1.1h.
Fixed bug in handling an aggregation function filter-clause.
Fixed bug in handling CTE resulting in error "Undefined table xyz".
Fixed bug in handling mixed case catalog name in a 3-part identifier.
Fixed bug in handling 3-part function call, e.g. SELECT * FROM postgres.public.testproc().
PGNProfiler: fixed minor misalignment for selected line.
PGNPUpdate: removed dependency on Windows Server 2008. Now utility can be used on Win Server 2003 and later.
PGNPUpdate: fixed error "Could not determine the installation location" when 32-bit msi is installed on 64-bit OS.
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!