Hello, new guy here.
Sorry if this is a dumb question, but I am not an IT person.
I am trying out Telerik Report Server. I have a Postgresql database that is hosted in the AWS cloud.
Is it possible to establish a connection to such database to load data into my reports?
If yes, can someone please provide me instructions on how to establish the connection? I am testing in a Windows 11 pc.
Thank you.
1 Answer, 1 is accepted
Hello Juan,
Yes, you will be able to connect to a PostgreSQL database as long as the necessary data provider is installed on the machine where the Report Server is used and the data provider is correctly selected in the data connection settings - Data Connections Management - Telerik Report Server.
For a PostgreSQL database, you may install the Npgsql data provider following our documentation - How to Configure Postgres with Npgsql? - Telerik Reporting. If the data provider does not appear in the dropdown menu when you attempt to create a new connection, it may mean that it is not available to all users and in such case, you may follow the Error Data source name not found - Telerik Report Server KB article to resolve that issue.
Lastly, you may have some issues with configuring the connection string and for that, I recommend looking at PostgreSQL connection strings - ConnectionStrings.com which has many examples of what the format of the connection string should be.
I hope that the provided information will help, please do not hesitate to let me know if you have any further questions.
Regards,
Dimitar
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/.
Rank 1
I am sorry to hear that you have been experiencing issues with the setup.
Please note that we always recommend first testing the connection strings in the most common database management tool for the given database. A connect string that works there should also work on the Report Server as long as the correct data provider is selected. Speaking of which, we you able to install the Npgsql data provider and did you see it in the dropdown when adding a new connection?
Could you please also record and share with me a Fiddler Jam log where you attempt to set up one such connection? You may do so by following the instructions from the First Steps with the Chrome Extension - Fiddler Jam (telerik.com) article.
Once done, I recommend sharing it in the private ticket thread so that no information is revealed to the public.
I will be looking forward to your response.