PostgreSQLThe 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.
* 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.

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.

 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


The new major version of the PGNP OLEDB Provider for PostgreSQL, Greenplum and Redshift has several new features and improvements:
    1. Optimizations for very large data sets (1 billion rows and more).
    2. Deferred updates support (IRowsetUpdate).
    3. Better support for Greenplum 4.x (awareness about distribution policy, better use of cursors, gpload utilization for bulk operations, etc.)
    4. Better support for PostgreSQL 9.x.
    5. New utility for Automated updates (not included in the trial build).
    6. Better integration with SSIS (MS BI tools).
  • You are here:  
  • Home