Open menu
  • Home
  • Products
    • Features Matrix
    • Our Customers
    • FAQ
    • License Status
    • License Agreement
    • History
  • Download
  • Forum
  • Purchase
  • My Account
    • My Orders
    • Profile
  • Contact Us

PGNP OLEDB Providers for PostgreSQL*, Greenplum and Redshift


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:

  • 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.

Read more: PGNP OLEDB Providers for PostgreSQL*, Greenplum and Redshift

PGNP Project History

August 12, 2023    Ver 1.4.0.3698

Added support for custom user impersonation (to address issue in Kerberos+SSAS2019).
Fixed bug in parsing concat expression in LIKE operator, e.g.: ... LIKE t.col||'%'
Fixed bug in handling queries with CASE-WHEN-THEN(SUBQUERY) clause.
Fix for a bug in SSPI login (current user name was not processed correctly in some scenarios).

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.

Read more: PGNP Project History

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

Read more: PGNP Features Matrix (32- and 64-bit Platforms); DE vs SE

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:
    1. IDP/SSO Login support for Redshift.
    2. 64-bit Profiler for unlimited tracing.
    3. 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?

Login Form

  • Forgot your password?
  • Forgot your username?
  • Create an account

VM - Shopping cart

 x 

Cart empty
 
  1. You are here:  
  2. Home
 
Copyright © 2007-2023 Intellisoft LLC. All Rights Reserved.