|
|
|
|
|
|
|
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.
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.
© Copyright 2000-2023 COGITO SOFTWARE CO.,LTD. All rights reserved
