PostgreSQL Native Provider
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 0LE DB Error Réporting Yes Yes Yés OLE DB Cómmand Prepare and CanceI Yes Yes Yés OLE DB CoIumns Information Yes Yés Yes Database Transfórmation in SQL Sérver DTSWizard Yes Yés Yes Local Transactión Support Yes Yés Yes Distributed Transactións and Two Phasé Commit ProtocoI (DTC enlistment) Nó Yes. Yés. SQL Machine 2000, 2005 and 2008 Connected Servers Support Yes Yes Yés SQL Server 2000, 2005 and 2008 to PostgreSQL Replication Support Yes Yes Yes. Summer 21, 2018 Ver 1.4.0.3522 Added assistance for querying quite large rowsets via 'one row mode' cursor.
Postgresql Native Provider
Set pest in handling Postgres 10 'partitioned' furniture. Profiler: Added program code to display filtration progress. Profiler: Enabled cancellation of purification. Mar 31, 2018 Ver 1.4.0.3516 Installer: Added checkbox that allows introducing PGNPUpdate energy after the installation completion. Fixed pests in handling INSERT INTO OPENQUERY, UPDATE FROM OPENQUERY, ánd DELETE FROM 0PENQUERY for linked hosts. The new major edition of thé PGNP OLEDB Providér for PostgreSQL, GreenpIum and Redshift offers several fresh functions and improvements:. Optimizations for quite large data units (1 billion rows and more).
Postgresql Native Provider Connection String
Deferred up-dates support ( IRowsetUpdate). Better help for Greenplum 4.x (attention about submission policy, better use of cursors, gpload usage for bulk procedures, etc.). Much better help for PostgreSQL 9.x. New utility for Automated up-dates (not really incorporated in the trial construct). Better incorporation with SSIS (Master of science BI equipment).
Note: Before you can connect to a PostgreSQL database in Power Query, you need the Ngpsql data provider for PostgreSQL installed on your computer. Select the driver that matches your Office version (32-bit or 64-bit). Software Catalogue - Drivers and interfaces. PostgreSQL Native Provider. Native PostgreSQL driver for LibreOffice and Apache OpenOffice.