PostgreSQLThe 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.
* Wide range of Postgres-compatible databases are supported, i.e. Amazon RDB, Heroku, Yellowbrick, etc.

 

    Main features are:

  • High performance in all OLTP and OLAP scenarios.
  • Database conversion with DTS Wizard (MSSQL 2000) or SSRS, SSAS and SSIS Wizard (SQL Server 2005-2022).
  • Supported OS Platforms: Windows XP, Windows Servers 2003-2022, Windows Vista, Windows 7-11.
  • 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.
  • Commands cancel, prepare and column information on a prepared command.
  • Unicode (UTF8/UTF16) and various languages support.
  • Support for PostgreSQL 8.x-14.x with POSIX and other extensions.
  • Partial support for T-SQL, Oracle and EnterpriseDB statements syntax.
  • Internal stored procedures, queries optimizer.
  • Extended syntax for parameters ('@', ':' and '?') and support for IN, OUT and INOUT parameters.
  • PGNP Profiler and PGNPUpdate utilities.