This is a migrated thread and some comments may be shown as answers.

PostgreSQL Data Connection

6 Answers 94 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
John
Top achievements
Rank 2
John asked on 26 Feb 2021, 05:51 PM

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.

6 Answers, 1 is accepted

Sort by
0
Accepted
Neli
Telerik team
answered on 03 Mar 2021, 01:34 PM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
John
Top achievements
Rank 2
answered on 03 Mar 2021, 02:56 PM
OK.  Thank you.  Why did you link specifically to version 3.2.7 of Npgsql?  They are on version 5.0.3 now.
0
Neli
Telerik team
answered on 08 Mar 2021, 11:32 AM

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

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

0
Ejay
Top achievements
Rank 1
answered on 24 Mar 2021, 01:20 AM
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/
0
John
Top achievements
Rank 2
answered on 12 Apr 2021, 02:29 PM
Please see this issue on Npgsql about no longer supporting .msi installation of their latest releases: https://github.com/npgsql/npgsql/issues/3574.
0
Neli
Telerik team
answered on 15 Apr 2021, 11:17 AM

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

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Tags
General Discussions
Asked by
John
Top achievements
Rank 2
Answers by
Neli
Telerik team
John
Top achievements
Rank 2
Ejay
Top achievements
Rank 1
Share this question
or