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:
- High performance in all OLTP and OLAP scenarios.
- Database conversion with DTS Wizard (MSSQL 2000) or SSRS, SSAS and SSIS Wizard (SQL Server 2005-2022).
- Supported 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, 2022 Ver 1.4.0.3662
Fixed bug in handling 'string' type in the Redshift/Glue external tables.Fixed bug in handling 'citext' type on insert.
Fixed bug in handling 'bytea' type resulting in memory corruption (side effect of optimization in build 3656).
Fixed bug when inserting Nulls and and handling columns with default values.
PGNProfiler: fixed issue when trace was not collected from Redshift OLEDB Provider.
PGNProfiler: fixed crash on startup when remote hosts configured without user password.
February 14, 2022 Ver 1.4.0.3656
Fixed a side-effect from previous performance optimization for query results.Fixed bug in handling bpchar column without specified size.
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 | 9.x-13.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 2005-2019 Linked Servers Support | Yes | Yes | Yes |
SQL Server 2005-2019 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!