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:
- 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.
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 | 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 |
PGNP Project History
November 8, 2018 Ver 1.4.0.3542
Stability improved in VS2017/SSIS.Fixed bug resulting in Error: Invalid ColumnID when processing tables in SSAS 2017 Tabular.
Fixed bug in handling TFD in square brackets, e.g. CREATE TABLE [t] ([id] [int]), when SYNTAX=T-Sql.
Fixed bug in mapping columns in FastLoad mode (it was visible as ERROR: cannot cast type integer to timestamp without time zone).
PGNPUpdate: added console parameters support.
October 4, 2018 Ver 1.4.0.3538
Added Extended Properties parameter BULK_METHOD=TEXTCOPY for faster data import from text files in SSIS.Added support for Redshift external tables.
Optimized performance of execution trace logging (checking connected pipes every 50ms).
Enabled connection string parameter SYNTAX for Postgres and T-Sql.
Sorted properties names in the Advanced pane of the Data Link Properties.
Implemented several stability enhancements.
Fixed bug in handling bit(1) fields.
Fixed bug: missing 'n' character when handling CREATE TABLE statement.
Fixed sorting in tables schema.
Enabled connection string parameter SYNTAX for Postgres and T-Sql.
Sorted properties names in the Advanced pane of the Data Link Properties.
Implemented several stability enhancements.
Fixed bug in handling bit(1) fields.
Fixed bug: missing 'n' character when handling CREATE TABLE statement.
Fixed sorting in tables schema.
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