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).
The provider is available in two editions: for Desktops (DE)/for Servers (SE). Following table summarizes differences:
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.
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.
Intended for use from desktop applications connecting either to Postgres or Greenplum. Handles distribution policies, able to work with Greenplums’ forward-only cursors, utilizes gpload.
Intended for use from servers (IIS, SSAS, SSIS, linked servers, etc.) connecting to Postgres and Greenplum databases. 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.
New PGNPUpdate Utility
The purpose of PGNPUpdate application is help users to automate product updates. It may function in either one of two modes that are automatically determined on the application start up.
PGNPUpdate launches in Normal mode when the product is activated and is fully functional. It launches in Activation mode when the product requires activation.
Evaluation build 1.4 is available from Download page.