Chapter 9. ADO.Net Integration

Npgsql is an open source ADO.NET Data Provider for PostgreSQL. It can be integrated with Data Virtualization to provide access from programs written in C#, Visual Basic, F#.

9.1. Prerequisites

  • Install the Npgsql using the .msi Windows installer. Data Virtualization integration was last tested with version 3.2.6.
  • Your Data Virtualization installation should already be setup for pg/ODBC access.
  • Have a VDB deployed.

9.2. Npgsql Configuration

For information about the available connection parameters, see the Npgsql documentation. Not all configuration parameters have been tested for use with Data Virtualization.

9.3. Known Limitations

  • TEIID-5220 prevents displaying the metadata of tables and views, but does not affect querying. Certain tools, such as PowerBi, may have options to turn of the need to perform metadata introspection.