ADO.Net Integration
Npgsql is an open source ADO.NET Data Provider for PostgreSQL. It can be integrated with Teiid to provide access from programs written in C#, Visual Basic, F#.
Prerequisites
-
Install the Npgsql using the .msi Windows installer. Teiid integration was last tested with version 3.2.6.
-
Your Teiid installation should already be setup for pg/ODBC access.
-
Have a VDB deployed.
Npgsql Configuration
See the documentation for supported connection parameters. Not all configuration parameters have been tested for use with Teiid.
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.