Intellisoft OLE DB Provider for PostgreSQL, Server Edition

Intellisoft OLE DB Provider for PostgreSQL, Server Edition

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

 

Main features are:

•Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (MSSQL 2005/2008/2012).

•Support for SSRS, SSAS and SSIS.

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

•Multiple results support.

•Command cancel, prepare and column information on a prepared command.

•Unicode (UTF8) and various languages support.

•Support for PostgreSQL syntax with POSIX and other extensions.

•Partial support for T-SQL statements syntax.

•Internal stored procedures.

•Extended syntax for parameters ('@', ':' and '?') and support for IN, OUT and INOUT parameters.

 

PGNP Features Matrix (32- and 64-bit Platforms)

	PGNP 1.2.8	PGNP 1.3.0	PGNP 1.4.0*
PostgreSQL 8.x Support	Yes	Yes	Yes
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
Multiple Result Sets, Multiple SQL statements/MARS	From Procedures Only  From	From Procedures Only  From	Full
Execution Tracing and Profiling	TraceMgr	PGNP Profiler	PGNP Profiler
Schema Support (tables, views, provider types, columns, primary/foreign keys, indexes, procedures, etc.)	Yes	Yes	Yes
SSL, Kerberos, GSSAPI and SSPI Support	No	Yes	Yes
Extended parameters syntax support ('@', ':' and '?')	Yes	Yes	Yes
IN, OUT and INOUT Parameters Support	Yes	Yes	Yes
Recycling of the Internal MetaData Cache	Manual **	Automatic	Automatic
OLE DB Command Timeout	No	Yes	Yes
Array Type Support	No	Yes	Yes
Nested Transactions Support	No	Yes	Yes
COPY Command and high-performance import support in SSIS	No	Yes	Yes
IRowsetUpdate Support	No	No	Yes
Automated Product Updates Support	No	No	Yes

 

** The internal stored procedure pgnp_refreshmetadata allows recycling of internal metadata cache in all connected instances of the provider.

What's New in 1.4?
The new major version of the PGNP OLEDB Provider for PostgreSQL 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).

The provider is available in two editions: for Desktops (DE)/for Servers (SE). Following table summarizes differences:

 

Postgres DE Intended for use from desktop applications connecting to Postgres databases only. Some functions would not work with Greenplum, e.g. scrollable cursors, deferred updates, etc.

Postgres SE Intended for use from servers (IIS, SSAS, SSIS, linked servers, etc.) connecting to Postgres databases only. Optimized for extremely large rowsets, supports two phase commit protocol (DTC enlistment), and provides better integration with SSIS.

Server Edition (SE) has all the features of Desktop Edition (DE), and adds more features as shown in the table above.

 

FEATURES of Intellisoft OLEDB Provider for PostgreSQL, Server Edition:

* Database conversion with DTS Wizard (MSSQL 2000) or SSIS Wizard (MSSQL 2005, 2008, 2012, 2014).

* Support for Linked Servers, OLAP, Aggregation Providers, etc.

* Transactions support.

* Schemas for tables, views, provider types, columns, indexes, procedures, etc.

* Support for Multiple results, Bookmarks, Grids, etc.

* Command prepare and column information on a prepared command.

* Commands cancellation.

* Additional utilities for converting indexes, etc.

* Unicode support for schema and data.

* PGNP Profiler for collecting and analyzing statements executed via Provider.

* PGNP Updater utility for the automated product updates.

Supported OS Platforms: Windows XP, Windows Servers 2003/2008 R2/2012 R2, Windows Vista, Windows 7, Windows 8, Windows 10.