PostgreSQL Data Connection

[John]

Hello,

     Does Report Server support a PostgreSQL data connection for reports?  I do not see it in my dropdown for my free trial version of 6.0.20.219.

Thank you.

[Neli]

Hello John,

Our SqlDataSource component uses standard ADO.NET classes and can fetch data from any database with an available ADO.NET provider. You may test installing Npgsql version 3.2.7 and add the connection as explained in the Data Connections Management.

Please, let us know if you need further assistance.

Regards,
Neli
Progress Telerik

[John]

OK.  Thank you.  Why did you link specifically to version 3.2.7 of Npgsql?  They are on version 5.0.3 now.

[Neli]

Hi John,

You can test using a newer version of Npgsql. Note that this might require adding binding redirects. Please, find further information in the How to Configure Postgres with Npgsql? and How to configure Telerik Report Server to use reports with custom functions KB articles.

Regards,
Neli
Progress Telerik

[Ejay]

Hello Robert, 

I been a new user of telerik reporting using postgres here is an article that helped me with the connection

https://telerikhelper.net/2020/12/22/connect-telerik-reporting-with-postgres-sql/

[John]

Please see this issue on Npgsql about no longer supporting .msi installation of their latest releases: https://github.com/npgsql/npgsql/issues/3574.

[Neli]

Hello John,

In this case, you may test the approach from the following KB article How to register SqlDataSource data providers without driver installation. It explains how to register the Npgsql data provider without installing its driver.

Regards,
Neli
Progress Telerik